Higher Normal Forms: 4NF and 5NF
You'll learn how Fourth and Fifth Normal Forms eliminate complex redundancies involving multiple independent relationships and join operations.
What Are 4NF and 5NF?
While 3NF and BCNF handle functional dependencies (where one column determines another), 4NF and 5NF address subtler forms of redundancy that occur when tables store multiple independent facts or when data can be losslessly decomposed further.
Fourth Normal Form (4NF)
4NF eliminates multi-valued dependencies. This occurs when a table contains two or more independent one-to-many relationships.
Analogy: Imagine an instructor table storing both the courses they teach AND the books they've authored. If Professor Smith teaches Math and Science, and has written Book A and Book B, you'd need four rows to capture all combinations—but these facts are independent! Teaching Math has nothing to do with Book B.
A table violates 4NF when:
- It's already in BCNF
- Column A determines multiple independent values of Column B and Column C
Solution: Split into separate tables—one for instructor-courses, another for instructor-books.
Fifth Normal Form (5NF)
5NF (also called Project-Join Normal Form) eliminates join dependencies. This happens when a table can be decomposed into smaller tables that, when joined back together, reconstruct the original without introducing false data.
Analogy: A table storing which suppliers supply which parts to which projects. If the business rule is "Supplier S supplies Part P to Project J only if S supplies P generally AND Project J uses P," you can split this into three simpler relationships without loss.
5NF is rarely needed in practice—most real-world databases stop at 3NF or BCNF.
Key Takeaway: 4NF removes multi-valued dependencies (independent repeating groups), while 5NF handles join dependencies where complex relationships can be losslessly decomposed—both eliminate redundancy beyond functional dependencies.