Database Design Fundamentals

Designing a scalable database schema.

Normalization

Process of organizing data to minimize redundancy.

1. 1NF: Atomic values
2. 2NF: No partial dependencies
3. 3NF: No transitive dependencies