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