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

> 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.

Within the context of a db, the use of underlying, data-independent links/refs (ie ID 1429476) to the one and only original data within the db is not considered redundant data because:

1. they are independent of the data being modelled.
2. they are or should be hidden/inaccessible/transparent to the user.