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 21 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
Great answer, keep it coming :)

smrtceo

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Phenotypic and molecular markers mapped on human chromosome 1 Phenotypic and molecular markers mapped on human chromosome 1
Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram Jugular Venous Pulse Waves in Relation to the Phonocardiogram and Electrocardiogram
The Mass-Luminosity Relation The Mass-Luminosity Relation
The Mass-Luminosity Relation The Mass-Luminosity Relation
How to evaluate composite functions (f∘g∘h) (Part 3) How to evaluate composite functions (f∘g∘h) (Part 3)
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
Video: Inflammation

For a complete list of videos, visit our video library