Re: A Normalization Question

Larry Coon <lcnospam_at_assist.org> wrote:

[snip]

>Ah, how convenient for you. You get to cling to definitions
>that suit you (like the above) while ignoring ones (like the
>definitions for redundancy and normalization) which don't.
>
>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?

     I see where you are headed with that. Someone has already tried the infinite recursion argument to no apparent avail.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.