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 77 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
Great answer, keep it coming :)

aliotak

  • Member
  • Posts: 326
Reply 3 on: Yesterday
Excellent

« previous next »
 

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?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

The roles of transpiration, cohesion, adhesion, and tension in long-distance water transport. The roles of transpiration, cohesion, adhesion, and tension in long-distance water transport.
Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco Change in American Gender Attitudes, 1977-2006 Over recent decades, views of gender roles have beco
Cultures Ideal Body Types Cultures Ideal Body Types
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 ...
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Video: Glucose Evaluation Procedure

For a complete list of videos, visit our video library