New 55% Off on All Courses - Enroll Now! Click Here

    Question

    Which normalization form eliminates transitive

    dependency in relational databases?
    A First Normal Form (1NF) Correct Answer Incorrect Answer
    B Second Normal Form (2NF) Correct Answer Incorrect Answer
    C Third Normal Form (3NF) Correct Answer Incorrect Answer
    D Boyce-Codd Normal Form (BCNF) Correct Answer Incorrect Answer
    E Fourth Normal Form (4NF) Correct Answer Incorrect Answer

    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.

    Practice Next