Geek Answers Handbook

Genealogy Relations

I am developing a genealogy application, and I am currently in the process of modeling relationships between people.

Based on my research, I noted that most comparisons of relationships are based on families (father + mother), so I would like to understand the main reasons for this before I blindly accept it.

Since my project is patriarchal, I assume that as soon as a person adds a father, then this will create a new family

+8
database-design genealogy database-schema
source share
1 answer

Most Genealogy software developers have decided to follow the model used by professional genealogies. The basis is a group sheet , which includes the father in the upper left corner, the mother in the upper right corner and the children below.

Then, a database structure consisting of two types is selected: individuals and families. An example is the GEDCOM standard , which is used to transfer genealogy data between programs.

Then they use the so-called line-bound data structure . This structure has two connections:

  • The person will refer to the family in which they are husband or wife (FAMS link), and the Family will contact two people (HUSB and WIFE link).

  • A person will refer to families that are their parents, either by blood or adopted (FAMC), and each Family will refer to their children (CHIL links).

Once you have developed your program, make sure that it can read and write GEDCOM.

+10
source share

More articles:


All Articles