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 57 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
Thanks for the timely response, appreciate it

billybob123

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

« previous next »
 

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

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

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Phenotypic and molecular markers mapped on human chromosome 1 Phenotypic and molecular markers mapped on human chromosome 1
Position of lung lobes in relation to anatomical landmarks Position of lung lobes in relation to anatomical landmarks
The hypothalamus and pituitary glands and their relation to the brain. The hypothalamus and pituitary glands and their relation to the brain.
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)
How to determine an exponential relation from a table of values How to determine an exponential relation from a table of values
Posterior view of midbrain in relation to brain stem Posterior view of midbrain in relation to brain stem
Video: Global warming and its effect on climate change

For a complete list of videos, visit our video library