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 76 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
:D TYSM

bblaney

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Most childhood vaccines are 90–99% effective in preventing disease. Side effects are rarely serious.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

The Evolution of an OB Association The Evolution of an OB Association
During their elderly years, men and women continue to exhibit aspects of the gender roles that they ... During their elderly years, men and women continue to exhibit aspects of the gender roles that they ...
(B) Interneurons or association neurons. (B) Interneurons or association neurons.
Association of Different HLA Alleles and Increased Susceptibility to Autoimmune Diseases Association of Different HLA Alleles and Increased Susceptibility to Autoimmune Diseases
Professional association conventions provide opportunities for networking with other massage ... Professional association conventions provide opportunities for networking with other massage ...
Historical gender roles in Canada Historical gender roles in Canada
Video: Gastrin (gastric emptying) & Secretin (buffering gastric acid)

For a complete list of videos, visit our video library