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]
|