Re: A Normalization Question

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 - 15:30:36 CEST