CSE Roadmap

Common tier · about 3 hours · 5 parts

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.