- Why normalize: reduce redundancy, avoid update anomalies
- Normal forms and criteria:
- 1NF: atomic values, no repeating groups
- 2NF: remove partial dependencies (on part of a composite key)
- 3NF: remove transitive dependencies (non-key → non-key)
- BCNF: every determinant must be a candidate key
- Normalization examples:
SQL/normalistaion.sql
- Normalization Intro: https://www.sqltutorial.org/sql-normalization/
- 1NF/2NF/3NF: https://www.guru99.com/database-normalization.html
- BCNF: https://www.geeksforgeeks.org/boyce-codd-normal-form-bcnf/