1. Identify all the candidate keys of the relation, and then identify all the fu

Question

1. Identify all the candidate keys of the relation, and then identify all the functional dependencies in the relation.

2. Examine the determinants of the functional dependencies. If any determinant is not a candidate key, the relation is not well formed. In this case: a. Place the columns of the functional dependency in a new relation of their own. b. Make the determinant of the functional dependency the primary key of the new relation. c. Leave a copy of the determinant as a foreign key in the original relation. d. Create a referential integrity constraint between the original relation and the new relation.

3. Repeat step 3 as many times as necessary until every determinant of every relation is a candidate key.

Explanation / Answer

Please upload the image for complete answer.

A candidate key is  is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is special, and it is called the primary key.

A unique candidate key as another name for primary key.

Functional dependencies are the dependency of one key-y on another key-X and is defined as X -> Y.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.