Database Normalization

Author: James Dansie

What is database normalization? Witchcraft. It will sort out a lot of database problems early on. The primary focus of DB norm is that each table should only have one purpose. When a database has many purposes it becomes cluttered, and difficult to maintain. It also makes it error prone, and difficult to maintain. If you think of this in terms of an excel spreadsheet, then instead of one monster spreadsheet, it would be broken into many smaller unique spreadsheets. Each spreadsheet would have unique, non repeating entries.

---

References

• https://www.essentialsql.com/get-ready-to-learn-sql-database-normalization-explained-in-simple-english/