Normalization

From Computer Science Wiki
Normalization can be hard to understand. This quote helps (image source[1])


Database normalization (or normalisation) is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy.

Normalization involves decomposing a table into less redundant (and smaller) tables without losing information; defining foreign keys in the old table referencing the primary keys of the new ones. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys.[2]

If any data is duplicated in a table, you probably don't have a normalized table.

References[edit]