In the normalization process,if you find a candidate key that is not a primary key 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) remove the determinant from the original relation
E) None of the above

Question

Quizplus · Accepted Answer

The Answer of In the normalization process,if you find a candidate key that is not a primary key 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) remove the determinant from the original relation
E) None of the above

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