Which normalization form eliminates transitive

Solution

Third Normal Form (3NF) eliminates transitive dependency, ensuring that all attributes in a relation are functionally dependent only on the primary key. This minimizes redundancy and enhances data integrity. • Example: In a database storing student details: Table: Student   Columns: Student_ID, Course_ID, Course_Name   Here, Course_Name depends on Course_ID, which in turn depends on Student_ID. Moving Course_ID and Course_Name to a separate table removes the transitive dependency. Why Other Options Are Incorrect: 1. 1NF: Ensures data is atomic but does not address transitive dependency. 2. 2NF: Eliminates partial dependency but not transitive dependency. 3. BCNF: Resolves anomalies arising from functional dependencies but does not focus on transitive dependency directly. 4. 4NF: Eliminates multi-valued dependencies, a different concept.