Which normal form is primarily concerned with eliminating non-trivial multivalued dependencies?

Options

  • A. 2NF
  • B. 3NF
  • C. 4NF
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. 4NF

Detailed Explanation

  • Fourth Normal Form (4NF): Deals with non-trivial multivalued dependencies.
  • A relation is in 4NF if it is in BCNF and every non-trivial multivalued dependency has a superkey as its determinant.
  • It helps eliminate redundancy caused by independent multivalued facts.