Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)
Date: Tue, 8 Jun 2004 08:14:34 -0400
Message-ID: <-N-dnc8F2LHJMFjdRVn-vw_at_comcast.com>
"Neo" <neo55592_at_hotmail.com> wrote in message news:4b45d3ad.0406071940.2c8e32c9_at_posting.google.com...
> Although brown appears three times in the script, XDb1 normalizes the
> second two by making them references to the first one. There is only
> one brown in XDb1's db. Using RM#1 or #2, brown is stored three
> separate times.
This is BS of the worst magnitude.
You have mangled the concept of "normalization" to the point where any use of a foreign key for reference purposes is "redundant" to the primary key it relates to. Such a concept of "normalization" would be worse than useless in the development of a relational model of data.
I'm glad Hugo put in the energy to meet your original challenge. But I'm equally glad that I did not. Received on Tue Jun 08 2004 - 14:14:34 CEST