Re: Relationship(s) for human family structure

From: Tegiri Nenashi <>
Date: Tue, 21 Aug 2007 09:49:46 -0700
Message-ID: <>

On Aug 21, 8:21 am, Rob <> wrote:
> In short, there is no known "clean, efficient way to store this
> information" in the relational model that satisfies all constraints.
> If you have a highly restricted universe (no divorce or remarriage),
> you might be able to solve your representation problem relationally.

There are 2 relations, which can be organized as trees:

Biological_Mother( parent, child )
Biological_Father( parent, child )

That is all to it. You can derive siblings informations from these base tables. You can introduce extra relations, like

Marriage( individual1, individual2 )

but the assertion that "no known clean, efficient way to store this information in the relational model" is clearly BS. Received on Tue Aug 21 2007 - 18:49:46 CEST

Original text of this message