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 34 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
Gracias!

chjcharjto14

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

« previous next »
 

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Did you know?

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

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly
Relation between form, particular objects, and images in Plato’s Line. Relation between form, particular objects, and images in Plato’s Line.
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.
The relation between a raw EMG signal and its integrated version. The volunteer tensed her muscle ... The relation between a raw EMG signal and its integrated version. The volunteer tensed her muscle ...
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
Video: Definitions of stroke volume, preload definition & Factors influencing stroke volume

For a complete list of videos, visit our video library