Data in ____ cannot have partial functional dependencies but can 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

In second normal form (2NF), a database table is free from partial dependencies, which means that no non-prime attribute is functionally dependent on a part (proper subset) of any candidate key. However, 2NF does not eliminate transitive dependencies, where a non-prime attribute is dependent on another non-prime attribute.

Data in ____ Cannot Have Partial Functional Dependencies but Can