Re: A Normalization Question

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

"VHarris001" <vharris001_at_aol.com> wrote in message news:20040709080246.29796.00001155_at_mb-m18.aol.com...
> >
> >How about numbers? Do you tokenize those? Given the
> >following schema:
> >
> >create table person_pets (
> > person_id numeric(5) not null,
> > number_of_dogs int,
> > number_of_cats int,
> > number_of_fish int,
> > primary key (person_id)
> >)
> >
> >Given the tuple (12345, 2, 2, 2) what do you do with
> >those horrific redundant 2's?

> >Larry Coon
> >University of California

> Why isn't each "pet" considered a unique thing rather than a quantity?

Consider other kind of quantities instead. How about money, weights and lengths ?

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

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