Relationship(s) for human family structure

I have a database with individuals in it, and I'd like to store their kin relationships also.

A quick, clumsy way of doing it would be to have three columns: two for individuals, and the third expressing their relationship (e.g. 'a is sibling of b', 'a is parent of b', etc).

But that's clumsy and has redundancies.

Does anyone know of a clean, efficient way to store this information? (I assume it would involve modelling a tree or graph.)

TIA Received on Fri Aug 17 2007 - 12:29:41 CDT