A table that is in 2NF and contains no transitive dependencies is said to be in _____.
A) 1NF
B) 2NF
C) 3NF
D) 4NF

Question

Quizplus · Accepted Answer

A table in 2NF is already normalized to eliminate any partial dependencies, and a table is in 3NF when all non-key attributes are independent of each other and they depend only on the primary key. Therefore, a table that is in 2NF and contains no transitive dependencies is already in 3NF. It is not necessary to go to the fourth normal form (4NF).

A Table That Is in 2NF and Contains No Transitive