Re: A Normalization Question

> Suppose a database contains two "browns" and one "green."
> Given your requirement, It is just as much a "corruption"
> to change both browns and miss the green as it is to change one brown
> but not the other.

The above is incorrect. The string 'brown' and string 'green' are two distinct and different things which are not redundant with respect to each other. Updating the string 'brown' should have absolutely no impact on the string 'green'. Updating 'brown' to 'nworb' which does not affect 'green' is not an update anomaly.

If one desires to update all strings (ie reverse their spelling) then the change needs to be implement on all instances of string which would include 'brown', 'green', 'yellow', etc. Received on Tue Jul 13 2004 - 05:15:18 CEST