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) All of the above
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) All of the above
E) None of the above

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