Relationship(s) for human family structure

From: <woger151_at_jqpx37.cotse.net>
Date: Fri, 17 Aug 2007 10:29:41 -0700
Message-ID: <1187371781.176756.217150_at_x40g2000prg.googlegroups.com>



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 - 19:29:41 CEST

Original text of this message