A relation is in fourth normal form if it is in BCNF and it has no ________.
A)transitive dependencies
B)multivalued dependencies
C)partial dependencies
D)deletion dependencies

Question

Quizplus · Accepted Answer

Fourth normal form (4NF) is a level of database normalization where there are no non-trivial multivalued dependencies other than a candidate key. Hence, option B, multivalued dependencies, is the correct choice. Option A, transitive dependencies, represents the third normal form (3NF), which is a prerequisite for BCNF, and option C, partial dependencies, represents the second normal form (2NF), which is a prerequisite for 3NF. Option D, deletion dependencies, is not a commonly known type of dependency in database normalization.

A Relation Is in Fourth Normal Form If It Is