Wednesday, October 7, 2009

Genealogy Logical Data Model (LDS)

This is a simple genealogy logical data model that I developed in 10 minutes. Excuse my ascii art.

I hope to build an application on top of it.


+---------------+
| FATHER |
+--------------------+---------------+
| fathered | |
-+- +---------------+
^ v
+---------------------+ -+-
|PERSON | | father to
+---------------------+ |
|person_id |---------------+
|~~~~~~~~~ |
|person_date_of_birth |
|person_place_of_birth|
|person_name |---------------+
|person_details | | mother to
+---------------------+ -+-
v ^
-+- +---------------+
| mothered | MOTHER |
+--------------------+---------------+
| |
+---------------+




This is how it reads
  • About each person we can remember their person_id, person_date_of_birth, person_place_of_birth, person_name, person_details, person's father, person's mother, person mother to and person father to.
  • About each mother we can remember the person, and people mothered.
  • About each father we can remember the person, and people fathered.
One interesting this about this model is that a person can father and mother themselves. I hope this is not how life begun.

1 comments:

Dickens said...

Missing gender! I think that is somehwat important.