Database Normalization and Table Structures Made Easy

Wow, i’m almost stunned. Digg has lots of interesting stuff but not a whole hell of a lot of it is actually useful. This page very clearly explains the basic principles of creating a good database table structure and also normalization.

I have noticed in a lot of the different databases I have worked with that database designers a lot of the time either normalize way too much or way too little. The mark of a good database designer is normalizing to a point, but realizing that going nuts with 3rd form normalization is sometimes almost as bad as not normalizing and having duplicate information in multiple places in the database.

read more | digg story