Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Decompose a table that violates a normal form into two or more smaller tables.
- Check whether a decomposition is lossless.
- Check whether a decomposition is dependency-preserving.
- Explain why a decomposition that loses either property is a real design problem, not a minor detail.
The previous modules named which normal forms a table might violate. This page is the actual repair step: splitting a table apart correctly, since splitting it carelessly can create new problems worse than the one being fixed.