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 34 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!