What is database normalization?

Normalization is the process of organizing relational data to reduce unnecessary redundancy and avoid data anomalies. It typically decomposes large structures into related tables while preserving meaningful relationships through keys.

Normalization improves consistency and maintainability. However, the goal is not to create the maximum possible number of tables; the schema should model the business correctly while supporting required workloads.