Re: A Normalization Question

From: VHarris001 <vharris001_at_aol.com>
Date: 09 Jul 2004 13:30:36 GMT
Message-ID: <20040709093036.29796.00001161@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 Received on Fri Jul 09 2004 - 08:30:36 CDT