engineering computer science MCQ #837

Which normal form ensures that a table has no transitive dependencies?

engineering computer science MCQ #837

  1. Question 1

    Q1. Which normal form ensures that a table has no transitive dependencies?

    • A) 1NF
    • B) 2NF
    • C) 3NF
    • D) BCNF

    Answer: 3NF

    Explanation: 3NF eliminates transitive dependencies by ensuring non-prime attributes depend only on the primary key.