in reply to Re: OT: benefits of database normalization
in thread OT: benefits of database normalization

My take is:

I am everyday dealing with a not normalized operational database, the biggest problem we facing is "out of sync'd data". From time to time, when my users complaining some data is wrong, I go check database, some of the data is stored in 4 or 5 different tables, and they simply have different values, which one is right? which one is wrong? That's a living hell. You have to do database design right at the beginning, don't expect to fix anything later, that is just not possible.

  • Comment on Re^2: OT: benefits of database normalization