From a structural point of view, 3NF is better than _____.
A) 2NF
B) 3NF
C) 5NF
D) 6NF

Question

Quizplus · Accepted Answer

3NF is a higher level of normalization compared to 2NF. In 3NF, every non-key attribute is dependent on the primary key or on a non-key attribute. This eliminates transitive dependencies (where a non-key attribute is dependent on another non-key attribute), which are present in 2NF. Therefore, 3NF ensures better structural integrity of the database compared to 2NF.

From a Structural Point of View, 3NF Is Better Than