engineering computer science MCQ #813

What is the difference between 3NF and BCNF?

engineering computer science MCQ #813

  1. Question 1

    Q1. What is the difference between 3NF and BCNF?

    • A) 3NF eliminates transitive dependencies, BCNF eliminates partial dependencies
    • B) 3NF eliminates partial dependencies, BCNF eliminates transitive dependencies
    • C) 3NF is a higher normal form than BCNF
    • D) BCNF is a higher normal form than 3NF

    Answer: BCNF is a higher normal form than 3NF

    Explanation: BCNF is a higher normal form than 3NF, as it eliminates transitive dependencies and ensures that a table is in 3NF and has no transitive dependencies.