In the normalization process,if you find a candidate key that is not a determinant then you should not ________.
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) rename the determinant to another attribute description
E) create a referential integrity constraint between the original relation and the new relation

Question

Quizplus · Accepted Answer

If a candidate key is not a determinant, it means that it does not uniquely determine any other attribute in the relation. Therefore, it cannot be used as the primary key of a new relation. However, renaming it to another attribute description does not change its functional dependency and does not affect the normalization process. Choices A, B, and E are incorrect because they all involve creating a new relation based on the candidate key, which is not applicable in this case. Choice C is incorrect because leaving a copy of the determinant as a foreign key in the original relation violates normalization.

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