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
E)referential integrity conflicts

Question

Quizplus · Accepted Answer

Fourth normal form (4NF) requires a relation to be in Boyce-Codd normal form (BCNF) and to have no multivalued dependencies (MVDs). It is not concerned with transitive dependencies, partial dependencies, deletion dependencies, or referential integrity conflicts.

A Relation Is in Fourth Normal Form If It Is