Which of the following may contain transitive dependencies, but not partial dependencies?
A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question

Quizplus · Accepted Answer

Second normal form (2NF) may contain transitive dependencies but not partial dependencies, as it requires that all non-key attributes are fully functionally dependent on the primary key, eliminating partial dependencies. However, transitive dependencies can still exist in 2NF.

Which of the Following May Contain Transitive Dependencies, but Not