Which type of dependency is eliminated when a relation is converted from 2NF to 3NF?

Options

  • A. Partial dependency
  • B. Transitive dependency
  • C. Multivalued dependency
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Transitive dependency

Detailed Explanation

  • 3NF: Eliminates transitive dependencies of non-prime attributes on candidate keys.
  • A transitive dependency occurs when a non-key attribute depends on another non-key attribute.
  • 3NF also requires the relation to satisfy 2NF.