normalize

  • Thread starter Thread starter fajita
  • Start date Start date
fajita said:
please explain to me why it is important to normalize your
database....
Thank you muchos
Click to expand...

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.
 
Back
Top