In the normalization process,if you find a candidate key that is not a determinant then you should:
A) place the columns of the functional dependency in a new relation.
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) All of the above
E) None of the above

Question

Quizplus · Accepted Answer

In normalization, if a candidate key is not a determinant, you should create a new relation with the columns of the functional dependency, make the determinant the primary key of the new relation, and leave a copy of the determinant as a foreign key in the original relation.

In the Normalization Process,if You Find a Candidate Key That