Re: A Normalization Question

• Post for FREE via your newsreader at post.usenet.com ****

"Alan" <alan_at_erols.com> wrote in message news:2l2cohF7alv2U1_at_uni-berlin.de...

> Here's an idea. 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. But wait, these codes are
> numbers. No sense storing those again. Lets create an ID column for the ID
> column. No, wait... Lather, rinse, repeat, lather, rinse, repeat, lather,
> rinse....

He might do just that (with an SQL DBMS) for saving disk space. :-)

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=