Which normal form is concerned with join dependencies?

Options

  • A. Third Normal Form (3NF)
  • B. Fourth Normal Form (4NF)
  • C. Fifth Normal Form (5NF)
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. Fifth Normal Form (5NF)

Detailed Explanation

Explanation: Fifth Normal Form (5NF), also called Project-Join Normal Form (PJNF), deals with join dependencies and prevents spurious tuples during decomposition.