Re: A Normalization Question

>
>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?

V Harris Received on Fri Jul 09 2004 - 07:02:46 CDT