Part 1 of 4 · 1 min read
Why this page comes first
In this module you will
- Identify a multivalued dependency and the redundancy it causes.
- Check whether a table satisfies 4NF.
- Explain, at a conceptual level, what a join dependency and 5NF cover.
- Recognize that 4NF and 5NF address rare cases, not everyday schema design.
BCNF catches nearly every real redundancy problem. A small number of cases slip through it anyway, caused by independent multivalued facts sharing one table. This page names those remaining cases precisely, so they can be recognized if they ever appear.