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

bigsis44

  • Member
  • Posts: 317
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

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

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly Coelacanth Genes Mapped, "Living Fossil" Evolved Slowly
Position of lung lobes in relation to anatomical landmarks Position of lung lobes in relation to anatomical landmarks
Inverse Relation Between IQ and Disease. Could this explain the Flynn effect? Inverse Relation Between IQ and Disease. Could this explain the Flynn effect?
The Body as Mapped on the Motor Cortex and Somatosensory Cortex The Body as Mapped on the Motor Cortex and Somatosensory Cortex
The human hypothalamus (in color) in relation to the optic chiasm and the pituitary gland. The human hypothalamus (in color) in relation to the optic chiasm and the pituitary gland.
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Video: Cardiac Cycle (Part 2 of 4)

For a complete list of videos, visit our video library