The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:
A) fifth normal form.
B) fourth normal form.
C) Boyce-Codd normal form.
D) sixth normal form.

Question

Quizplus · Accepted Answer

Boyce-Codd normal form (BCNF) is used to remove functional dependencies when there is more than one primary key for the same nonkeys, ensuring that every determinant is a candidate key.

The Normal Form Which Removes Any Remaining Functional Dependencies Because