How to normalize a database

Most programmers don't normalize their databases. Use this guide to get a better understanding of how to do it.

Last Updated: July 17th, 2006 • HowTo •

I was in a recent project with a client where I was given a database and told to work off of that.

The database wasn't normalized at all, but it was working. I noticed there were redundant fields in the tables that could be removed. Well, you can only do so much without rewriting the app.

A good article was posted at databasedev.co.uk called Relational Database Normalisation Process, which explains the database normalization process in detail with some examples.

Forward this to your architects and developers. :-)

Did you like this content? Show your support by buying me a coffee.

Buy me a coffee  Buy me a coffee
Picture of Jonathan Danylko

Jonathan Danylko is a freelance web architect and avid programmer who has been programming for over 20 years. He has developed various systems in numerous industries including e-commerce, biotechnology, real estate, health, insurance, and utility companies.

When asked what he likes to do in his spare time, he replies, "Programming."

comments powered by Disqus