If a table is designed so that every determinant is a candidate key,then that relation is in ________.
A)First Normal Form
B)Second Normal Form
C)Third Normal Form
D)Boyce-Codd Normal Form
E)Fourth Normal Form

Question

Quizplus · Accepted Answer

If a table is designed so that every determinant is a candidate key, then that relation is in Boyce-Codd Normal Form (BCNF). In BCNF, every determinant (non-key attribute) is functionally dependent on the candidate key. This means that there are no functional dependencies between non-key attributes. Therefore, BCNF is a higher normal form than First Normal Form, Second Normal Form, and Third Normal Form. Fourth Normal Form is even higher than BCNF and deals with multi-valued dependencies.

If a Table Is Designed So That Every Determinant Is