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.
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. :-)
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."
Like this article?Subscribe for FREE to receive the latest posts before they become public.
- Question: What kind of laptop or PC should I buy?
- How To Use Technology For Christmas With Digsby
- HOWTO: Connect a FreeNAS to a TiVo
- How to create the ultimate Windows XP Installation CD/DVD
- PVR: Three MythTV Distros Reviewed