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 71 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

amit

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

« previous next »
 

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Roles of the central and peripheral nervous systems. Roles of the central and peripheral nervous systems.
Chimpanzees live in complex kin groups in which lifelong bonds and individual personalities play key Chimpanzees live in complex kin groups in which lifelong bonds and individual personalities play key
PMDD Diagnostic Criteria from the American Psychiatric Association PMDD Diagnostic Criteria from the American Psychiatric Association
Association of Different HLA Alleles and Increased Susceptibility to Autoimmune Diseases Association of Different HLA Alleles and Increased Susceptibility to Autoimmune Diseases
Oxygen Transport: The Roles of Hemoglobin and Myoglobin Oxygen Transport: The Roles of Hemoglobin and Myoglobin
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Video: Transcription—A molecular view

For a complete list of videos, visit our video library