Which Normal Form eliminates partial dependency by ensuring that all non-key attributes are fully functionally dependent on the entire primary key?
AFirst Normal Form (1NF)
BSecond Normal Form (2NF)
CThird Normal Form (3NF)
DBoyce-Codd Normal Form (BCNF)
Explanation
2NF requires the table to be in 1NF and have no partial dependencies (non-prime attributes depending on only part of a composite primary key). 3NF eliminates transitive dependencies.
Exam Relevance
- Topic: Database Management Systems
- Subtopic: Database Normalization

No Comments