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.

July 17th, 2006 at 5:17am — Comments: (2) — By: Jonathan Danylko — Tags: 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. :-)

Picture of Jonathan Danylko
  • Jonathan Danylko Twitter Account LinkedIn Account Facebook Account

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 doing in his spare time, he answers..."programming."

Related Posts

2 Comments

  1. Netu
    May 13th, 2011 at 6:55am
    Nice guide lines..
  2. John Rob
    December 27th, 2011 at 9:52am
    Hi,

    I was reading your article and I would like to appreciate you for making it very simple and understandable.
    This article gives me a basic idea of normalization in database and it will help me a lot.
    Check out this link too its having a nice post with wonderful explanation on how to use normalization in database.

    http://mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?

    Thank you very much!

Post a comment