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 63 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 :)

kthug

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

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 Period-Luminosity Relation The Period-Luminosity Relation
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 camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing. The camshaft is rotated in relation to the camshaft by the PCM to provide changes in valve timing.
Split-brain patients were shown composite photographs Split-brain patients were shown composite photographs
Video: Chemical Messengers Animation

For a complete list of videos, visit our video library