nomalizing tables

  • Thread starter Thread starter ben
  • Start date Start date
B

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