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 49 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
:D TYSM


skipfourms123

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

 

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

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

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

For a complete list of videos, visit our video library