How to normalize a database

Monday, July 17, 2006 5:17 AM

Posted by Jonathan Danylko | Tag: HowTo | Comments: 1 | View blog reactions

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. :-)

Technorati Tags: , ,

RSS LogoLike this article? Link to the RSS feeds to always get the latest posts.
What is RSS?

Related Articles:

Chatterbox - 1 Comments

 

Posting anonymous comments requires approval
and will not appear immediately.

Please Register or Login to post a comment.

 Post a Comment