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


tanna.moeller

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

 

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

For a complete list of videos, visit our video library