This topic contains a solution. Click here to go to the answer

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

 

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.

For a complete list of videos, visit our video library