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 64 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
Excellent

essyface1

  • Member
  • Posts: 347
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

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.
Thick filaments are bipolar structures created by the association of many myosin molecules Thick filaments are bipolar structures created by the association of many myosin molecules
Major biosynthetic roles of some citric acid cycle intermediates Major biosynthetic roles of some citric acid cycle intermediates
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
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
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: Introduction to Insulin

For a complete list of videos, visit our video library