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 29 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
Wow, this really help


marict

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

 

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

For a complete list of videos, visit our video library