Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

> The first challenge was much too easy for my liking.

Besides the redundancy in the schema, the provided solutions stores redundant data. Using either #1 or #2, enter the equivalent of the following XDb1 script.

color isa thing.
brown isa color.

person isa thing.
john isa person.
john's color is brown.
mary isa person.
mary's color is brown.

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 actually stored three separate times. This is redundant and unnormalized. Received on Tue Jun 08 2004 - 04:56:58 CEST