Data in ____ cannot have transitive dependencies.
A) first normal form
B) second normal form
C) third normal form
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

Third normal form (3NF) ensures that there are no transitive dependencies in the data. This means that if there is a dependency between A and B and a dependency between B and C, then there should not be a dependency between A and C. In simpler terms, every non-key attribute must depend on the primary key, not on another non-key attribute. First normal form (1NF) ensures that there are no repeating groups and second normal form (2NF) ensures that every non-key attribute is fully dependent on the entire primary key, but they do not address transitive dependencies.

Data in ____ Cannot Have Transitive Dependencies