reading-notes

---

Project maintained by will-ing Hosted on GitHub Pages — Theme by mattgraham

Normalization

Database normalization is a process used to organize a database into tables and columns.

By limiting a table to one purpose you reduce the number of duplicate data contained within your database.

Three reasons to normalize a database

• to minimize duplicate data
• to minimize or avoid data modification issues,
• simplify queries

There are three common forms of database normalization: 1st, 2nd, and 3rd normal form. They are also abbreviated as 1NF, 2NF, and 3NF respectively.

Main Page