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.
OOps! You are currently offline.