View Single Post
  #4  
Old November 1st, 2005, 04:37 PM
John Vinson
external usenet poster
 
Posts: n/a
Default Denormalizing Dillema!

On Tue, 1 Nov 2005 12:52:00 +0200, "1" 1@1 wrote:

Surpassing that, completely normalizing all the tables is giving me a
headache because the tables that need maintenance multiply!


Well... all I can say is, that's why database administrators get
paid...

Putting data into a table which was designed for a different kind of
data is NOT a good idea; creating a table for undefined, freeform data
is possible but a much worse administrative headache in the long run
("what does THIS mean? Who put it into this table and why?").

It's just a reality that a properly designed relational database
system needs a table for each business Entity that needs to be
represented.

John W. Vinson[MVP]