A table is in third normal form when it is
A)free of repeating group data
B)free of transitive dependencies
C)free of partial dependencies
D)free of deletion anomalies

Question

Quizplus · Accepted Answer

Third normal form requires that a table be free of transitive dependencies. Transitive dependencies occur when a non-key attribute depends on another non-key attribute, which in turn depends on the primary key. To eliminate transitive dependencies and achieve 3NF, we break the table into two separate tables.

A Table Is in Third Normal Form When It Is