Re: A Normalization Question
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Wed, 07 Jul 2004 22:24:20 GMT
Message-ID: <oK_Gc.177811$Ti6.8700991_at_phobos.telenet-ops.be>
>
> 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.
Date: Wed, 07 Jul 2004 22:24:20 GMT
Message-ID: <oK_Gc.177811$Ti6.8700991_at_phobos.telenet-ops.be>
Neo wrote:
>>You have to show that in the tuple ("brown", "brown", "brown") the
>>string "brown" each time represents the same fact.
>
> 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.
Why would you do that? What update anomaly would that solve? Recall that this is what normalization is about, and not for example finding a more compact representation.
- Jan Hidders