Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q12: In Microsoft Access,a relationship between two tables
Q47: Explain the concept of a surrogate key.
Q58: In practice,why would tables that have duplicate
Q61: When the primary key of one relation
Q62: Every table is a relation,but not every
Q62: Explain the terms relation,tuple,and attribute.
Q65: A(n)_ is a unique,numeric value that is
Q66: The primary key is used both to
Q67: Since Microsoft Access is a personal database,it
Q68: A rule that requires every value in