In database normalization, which normal form eliminates transitive dependency?
A
Second Normal Form (2NF)
B
Third Normal Form (3NF)
C
First Normal Form (1NF)
D
Fourth Normal Form (4NF)
Correct Answer: Option B — Third Normal Form (3NF)
Explanation:
Third Normal Form (3NF) eliminates transitive dependency, ensuring that non-key attributes depend only on the primary key and not on other non-key attributes. This reduces data redundancy and improves the overall integrity of the database structure.