Question: In the normalization process, if you find a candidate key that is not a determinant then you should not _ _ _ _ _ _
In the normalization process, if you find a candidate key that is not a determinant then you should not
Question options:
A
make the determinant of the functional dependency the primary key of the new relation
B
rename the determinant to another attribute description
C
create a referential integrity constraint between the original relation and the new relation
D
leave a copy of the determinant as a foreign key in the original relation
E
place the columns of the functional dependency in a new relation
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
