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

xiazhe

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

« previous next »
 

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

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?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram
Position of lung lobes in relation to anatomical landmarks Position of lung lobes in relation to anatomical landmarks
Composite Faces Composite Faces
Relation between form, particular objects, and images in Plato’s Line. Relation between form, particular objects, and images in Plato’s Line.
How to write a composite function f(g(x)) and g(f(x)) (Part 2) How to write a composite function f(g(x)) and g(f(x)) (Part 2)
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
Video: Functional zones in a mitochondrion

For a complete list of videos, visit our video library