I may have replied in the past to you and mentioned you should go to
google and look around there. Goto http://www.yqcomputer.com/
AdvancedSearch. In the Words To Search enter
and for the groups to search enter
Anyway, here is just ONE response from the google search. There are 84
threads on just the word Geneology to review. Then start looking for
Dam and Sire and it should have even more results.
The human relationships that you want to trace will define
the data structure you need.
For a simple example, see:
Self Joins: tables that look themselves up (Pedigrees example)
That article handles biological parents only, not step parents.
For those, you would need a lookup table that defines the
relationship types, and a link table between 2 copies of your
Person database that links the 2 people by a defined relationship
For more complex tree tracing, see Joe Celko's article:
A Look at SQL Trees at: