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 52 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
Excellent


patma1981

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

 

Did you know?

Medication errors are three times higher among children and infants than with adults.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

For a complete list of videos, visit our video library