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

Author Question: Deleting tables and relationships is basically a matter of dropping foreign key constraints and then ... (Read 57 times)

evelyn o bentley

  • Hero Member
  • *****
  • Posts: 564
Deleting tables and relationships is basically a matter of dropping foreign key constraints and then dropping the tables.
 
  Indicate whether the statement is true or false

Question 2

Explain the relationships among primary keys and functional dependencies.
 
  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

lkanara2

  • Sr. Member
  • ****
  • Posts: 329
Answer to Question 1

TRUE

Answer to Question 2

Relations store instances of functional dependencies in their rows. All primary keys represent a functional dependency, since each primary key functionally determines the entire row. Since the primary key determines the entire row, if a primary key were duplicated in a relation, then the entire row would have to be duplicated. Since a relation can contain no duplicate rows, the primary key must be unique.




evelyn o bentley

  • Member
  • Posts: 564
Reply 2 on: Jul 7, 2018
Gracias!


sultansheikh

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

 

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

For a complete list of videos, visit our video library