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

The Boyce-Codd normal form (BCNF) is designed to eliminate anomalies that can arise from having functional dependencies between non-key attributes and only applies to relations that have a candidate key containing two or more attributes. It is a stronger form of the third normal form (3NF), which is designed to eliminate anomalies that can arise from having functional dependencies between non-key attributes and any candidate key attribute.

The Normal Form Which Removes Any Remaining Functional Dependencies Because