📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    In a relational schema, which normal form eliminates

    transitive dependencies (i.e., non-prime attribute depends on another non-prime attribute)?
    A 1NF Correct Answer Incorrect Answer
    B 2NF Correct Answer Incorrect Answer
    C 3NF Correct Answer Incorrect Answer
    D BCNF Correct Answer Incorrect Answer
    E 4NF Correct Answer Incorrect Answer

    Solution

    Third Normal Form removes transitive dependencies; every non-prime attribute must depend only on a key, not on other non-prime attributes.

    Practice Next
    ask-question