normalize

[fajita]

please explain to me why it is important to normalize your
database....
Thank you muchos

 

[Kevin3NF]

No redundant data decreases file size.

Normalized tables generally lead to faster performance.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Peter van der Goes]

please explain to me why it is important to normalize your
database....
Thank you muchos

And... in addition to what Kevin said, elimination of redundant data means
no (less) danger of incomplete updates, making your data more reliable. The
basic idea is that if we store the same data in multiple places, and it
needs to be updated (like a person's name changing due to marriage, for
example), one or more instances of that person's name may be missed during
the update. If we store the name (and other personal information) in one
place, and relate other data in other tables to it (like multiple account
records at a bank), then we can change the name in one place and can be sure
it is in effect for all accounts.

 

[M.L. Sco Scofield]

To add to what everyone else has said; "It's the right thing to do!"

Take a look at
http://support.microsoft.com/defaul...upport.microsoft.com/default.aspx?kbid=289533
and http://support.microsoft.com/default.aspx?kbid=283878 and download the
document at http://support.microsoft.com/default.aspx?scid=kb;en-us;283698.

Last, but not least, I'd recommend getting a copy of "database Design for
Mere Mortals" by Michael Hernandez.

Good luck.

Sco