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

Zebsrer

  • Member
  • Posts: 284
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

In 1864, the first barbiturate (barbituric acid) was synthesized.

Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram
Composite Faces Composite Faces
When the IQ scores of identical twins differ, behavior genetics researchers attribute these to ... When the IQ scores of identical twins differ, behavior genetics researchers attribute these to ...
The hypothalamus and pituitary glands and their relation to the brain. The hypothalamus and pituitary glands and their relation to the brain.
How to find the maximum and minimum of a quadratic relation How to find the maximum and minimum of a quadratic relation
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
Video: Chemical Messengers Animation

For a complete list of videos, visit our video library