This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What are the roles of aggregation and association in relational database? What will be an ideal ... (Read 35 times)

notis

  • Hero Member
  • *****
  • Posts: 596
on: Jul 7, 2018
What are the roles of aggregation and association in relational database?
 
  What will be an ideal response?

Question 2

Design patterns are usually classified based on the type of the problems that they address.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

fraziera112

  • Sr. Member
  • ****
  • Posts: 356
Reply #1 on: Jul 7, 2018
Answer to Question 1

To map to a relational database, aggregation must be flattened into association; that is, the relational model is flat: tables do not own each other and are not composed of each other. This means that aggregation and composition relationships must be changed to association to map to tables. The task is not complicated: the table for the aggregate class provides the primary key, the tables for aggregating classes implement the foreign keys, and the multiplicity stays the same.

Answer to Question 2

TRUE


notis

  • Member
  • Posts: 596
Reply 2 on: Jul 7, 2018
Wow, this really help

lkanara2

  • Member
  • Posts: 329
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

In Hindu marriages, the roles of husband and wife are firmly established. Neither this woman, whom I ... In Hindu marriages, the roles of husband and wife are firmly established. Neither this woman, whom I ...
The major cortical input and output pathways of the posterior parietal association cortex. Shown are ... The major cortical input and output pathways of the posterior parietal association cortex. Shown are ...
The major cortical input and output pathways of the dorsolateral prefrontal association cortex. ... The major cortical input and output pathways of the dorsolateral prefrontal association cortex. ...
Professional association conventions provide opportunities for networking with other massage ... Professional association conventions provide opportunities for networking with other massage ...
Results of a genome-wide association study (GWAS) to detect SNPs Results of a genome-wide association study (GWAS) to detect SNPs
General model of the association of histones and DNA to form nucleosomes General model of the association of histones and DNA to form nucleosomes
Video: Ear Animation

For a complete list of videos, visit our video library