But wait! There's more!
- Multi-value dependencies.
- Elementary Key Normal Form.
- 4th Normal Form.
- 5th Normal Form.
- Redundancies not caught by YOUR_FAVORITE_NORMAL_FORM.
- Schema design algorithms:
- Inputs: dependencies, schema
- Output: Better schema
We're stopping with BCNF
- We could spend weeks on it.
- But there are other topics to cover.
- Common sense, E/R modeling, and BCNF decomposition (to be
discussed next) suffice in the vast majority of cases.
|