What is the difference between a third normal form and fourth normal form table?
A) A 4NF table has no alternate keys.
B) A 4NF table has no foreign keys.
C) A 4NF table has no multivalued dependencies.
D) A 4NF table has no primary dependencies.

Question

Quizplus · Accepted Answer

The primary difference between 3NF and 4NF is that 4NF eliminates all multivalued dependencies in addition to the functional dependencies eliminated by 3NF. A multivalued dependency occurs when a table contains two or more independent multivalued facts about an entity. Thus, option C is correct. Options A, B, and D are incorrect because a 4NF table can have alternate keys, foreign keys, and primary dependencies.

What Is the Difference Between a Third Normal Form and Fourth