Re: Entity Overlap and Relationships

From: Bob Badour <>
Date: Fri, 21 Apr 2006 00:17:45 GMT
Message-ID: <JwV1g.63425$>

Mikito Harakiri wrote:

> GB wrote:

>>2.  What is the best way to handle people-people relationships (from a
>>schema perspective - I can see the sarcastic remarks now)?  Has anyone
>>solved this problem of how to store {father, son, uncle, friend, etc.}?
>> Did you have to set up a trigger to update the table to include the
>>son relationship entry if the father relationship was added for
>>instance?  Or would you just store the "parent" and "child" title for
>>the relationship, in this case "father" and "son" then the related
>>unique ID's for the people with the relationship?

> table People (...)
> table Parents (
> mother_id integer, foreign key to people, null if unknown
> father_id integer, foreign key to people, null if unknown
> child_id integer, foreign key to people
> )
> The other relations -- sibling, uncle, etc are derived from the
> Parents.
> BTW, you don't actually need the concepts of entity and relationship
> for designing a good database schema.

How does your proposed design capture 'friend' ? Even the obviously incomplete requirements included that. Received on Fri Apr 21 2006 - 02:17:45 CEST

Original text of this message