where can I find the best mySQL database normalization document/script on the web?
Thank you in advance for your reply
I don't think there is a script that can normalize your database, because every database is different and requires different normalization.
There is a column about normalization here on phpbuilder that explains the basics.
normalization is a process of database design that's common to all relational database systems. so, to my knowledge, there are no mySQL-specific concepts involved. there are lots of explanations available, including an article from this site. here are a few others that seem reasonably clear:
http://support.microsoft.com/support/kb/articles/Q100/1/39.asp http://www.cciw.com/content/normalization.html http://www.gslis.utexas.edu/~l384k11w/normover.html