Re: A Normalization Question
From: VHarris001 <vharris001_at_aol.com>
Date: 09 Jul 2004 12:02:46 GMT
Message-ID: <20040709080246.29796.00001155_at_mb-m18.aol.com>
Date: 09 Jul 2004 12:02:46 GMT
Message-ID: <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?
V Harris Received on Fri Jul 09 2004 - 14:02:46 CEST