brothertruffle880
asked on
Normalization for Complete Idiots
It seems to me that if you play your database before creating your first table, you'll arrive at a decently organized body of data. I tried understanding Normalization by reading some essays and found the topic arcane and needlessly complex. Could Codd explain normalization to a 5 year old?
it seems that there are concepts worth learning but surely someone must have extracted the useful essence of the subject without the excess verbiage.
it seems that there are concepts worth learning but surely someone must have extracted the useful essence of the subject without the excess verbiage.
Here is a Microsoft KB with examples:
Database Normalization Basics
http://support.microsoft.com/?kbid=283878
Database Normalization Basics
http://support.microsoft.com/?kbid=283878
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As part of the normalization process, I look for column sequences that should be moved to rows in a separate table. For instance, if a record had columns for Months of the Year (MoY), then I would create a new table that included a key column and an MoY column. It is possible that the MoY columns are actually sets of columns, containing multiple fields for each month. In such cases, the new table would have the key column and the (monthly) set of columns.
============
If you are creating a data warehouse, then some denormalization activities are in order.
============
If you are creating a data warehouse, then some denormalization activities are in order.
ASKER
SUPER Help people.
Thanks!
Thanks!
Welcome!
http://support.microsoft.com/kb/100139
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html