Re: A Normalization Question

Neo wrote:

> A clearification. While the 1st, 2nd and 3rd "brown" in the above
> tuple do represent different things (ie fact), the name of each of
> those things is the same (ie string "brown") and it is the name of
> those things that can be normalized.
>
> Below is approximately how XDb1 normalizes the above tuple.
>
> Thing Person Color Street
> 1 ->2 ->3 ->4
>
> Person Name
> 2 ->5
>
> Color Name
> 3 ->5
>
> Street Name
> 4 ->5

You'll have to explain why storing "brown" three times is redundant, while storing ->5 three times is okay.

Also, you confuse adding useless layers of indirection with normalization.

Larry Coon
University of California Received on Wed Jul 07 2004 - 16:46:06 CDT