A table is in 4NF if it is in 3NF, and _____.
A) all attributes must be dependent on the primary key and must be dependent on each other
B) all attributes are unrelated
C) it has no multivalued dependencies
D) no column contains the same values

Question

Quizplus · Accepted Answer

Fourth normal form (4NF) requires a relation to be in third normal form and have no dependencies between candidate keys. In other words, there should not be any sets of multiple values that are related to a single value in a different table. Therefore, option C is the best choice as it correctly defines the requirements for a table to be in 4NF.

A Table Is in 4NF If It Is in 3NF