Re: A Normalization Question

"VHarris001" <vharris001_at_aol.com> wrote in message news:20040709093036.29796.00001161_at_mb-m18.aol.com...
> Alan wrote:
>
> >To achieve perfect normalization (zero redundancy), there
> >should be a database that contains one table for each possible attribute
in
> >the universe- that way each value is stored only once. So, there would be
a
> >table called COLOR with every possible color stored in it. Another table
> >called NUMBERS with Numbers stored in it (no sense storing a number more
> >than once), and so on. Then, all you need to do is create tables that run
> >your business with meaningless id codes in them so you can connect all of
> >your attributes into rows of business data.
>
> Isn't the problem with normalization the necessity of adding too many
tables?
> I thought neo's proposal was to put all 'things' in one table?
>
> V Harris
>
A common misperception. "Too many" tables is irrelevant. The right number of tables is the right number of tables for any given implementation. Received on Fri Jul 09 2004 - 16:16:10 CEST