Re: A Normalization Question

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

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

> You could normalize to a higher NF to prevent storing the value of either
> attribute more than once. This is done is real estate databases to save
> space:

> STREETS
> street_id
> street_name

> HOUSES
> house_number
> street_id
> etc

> The idea here is that the street_id will _usually_ take less space on disk
> than the street name, so it is not necessary to record the street name for
> each house- just the street id.

No. The idea here is that you may need to know if a given street exists and what houses are on it.

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

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