nomalizing tables

[ben]

will someone please explain the purpose of normalizing
tables. I have looked and looked and I cant find
something that really explains it. I have a db that
apparently has tables that are not normalized...but I
cant fix that unless I know what the hell is going on...

ben

 

[Rebecca Riordan]

Ben,

One short answer is "to avoid redundant data". Another is "to more
accurately model the problem space". The long answers, of course, require
volumes (I wrote one of them myself <eg>)

But why don't you describe what your schema looks like, and maybe we can
teach you by example?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Walter Levine]

-----Original Message-----
http://databases.about.com/library/weekly/aa080501a.htm

Good place to start...

Two main reasons:
Avoid storing redundant data
Store data logically

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm






.