Which normal form eliminates transitive functional dependencies?

Options

  • A. First Normal Form (1NF)
  • B. Second Normal Form (2NF)
  • C. Third Normal Form (3NF)
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. Third Normal Form (3NF)

Detailed Explanation

Explanation: Third Normal Form (3NF) eliminates transitive dependencies of non-prime attributes on candidate keys. A relation must first satisfy 2NF.