Re: Generalised approach to storing address details

> My impression has been that the IP transcends the relational model, in
> that it requires that what a system allows a user to see is all that a
> user needs to predict what the system might do, ie., it doesn't demand
> attributes and tuples per se in order to do that. I'd say that any data
> model besides the well-described relational one (not that I'm suggesting
> another one) would be right to follow the IP, otherwise it is hiding
> information which seems crazy to me. That way people don't have to
> memorize what a particular product does under such and such a
> circumstance, which would open the door for all the cuckoo arbitary
> behaviours that the products Codd was railing against.

Would you say the following table is hiding information? If so, how would you store it in a relational db such that it isn't.

T_Hierarchy
Parent Child
john jim Received on Sat Dec 09 2006 - 22:26:56 CST