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

Author Question: How is a composite attribute of an entity mapped into a relation? What will be an ideal ... (Read 69 times)

bcretired

  • Hero Member
  • *****
  • Posts: 525
on: Jul 7, 2018
How is a composite attribute of an entity mapped into a relation?
 
  What will be an ideal response?

Question 2

What is a primary key?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

31809pancho

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

If an entity contains composite attributes, each component of the composite attribute is mapped as a column of a relation, while the composite attribute itself does not appear in the mapped relation.

Answer to Question 2

Primary key is a column (or a set of columns) whose value is unique for each row. Primary keys cannot have null values. If there are multiple columns (or sets of columns) that have unique values in each row, one of them is designated as a primary key. Each relation must have a primary key.


bcretired

  • Member
  • Posts: 525
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

kswal303

  • Member
  • Posts: 316
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

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.

Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram
The female reproductive system, sagittal view showing organs of the system in relation to the urinar The female reproductive system, sagittal view showing organs of the system in relation to the urinar
Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly
The Mass-Luminosity Relation The Mass-Luminosity Relation
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Split-brain patients were shown composite photographs Split-brain patients were shown composite photographs
Video: Photosynthesis overview Animation

For a complete list of videos, visit our video library