Which normal form requires that every non-key attribute is fully functionally dependent on the primary key?
- 1NF
- 2NF
- 3NF
- BCNF
Answer: 2NF
Second Normal Form (2NF) requires: 1) Table is in 1NF, and 2) No partial dependency (non-key attributes must depend on entire primary key, not part of composite key). Eliminates redundancy from partial dependencies. Further normalization to 3NF removes transitive dependencies.