Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2005
    Posts
    22

    Family Tree Database design project

    I'm want to design a database to store family tree information. I want to be able to capture the Name, DOB, Mother, Father, Date of Death, childern name's and other extra data about the person, military career info, clubs, personal achievements, etc...... I'm kind of stuck on were to start and the table designs for this project. I want something that is very scalable and dynamic.

    Here are the entities that I have thought of trying to develop the tables

    Person Table:
    Person ID,
    First Name,
    Last Name,
    Middle Name,
    Date of Birth,
    Date of Death

    Spouse Cross Reference Table: Link the Person ID to the other Person ID to show they were spouses many to many relationship (since a person can have more than 1 spouse
    Spouse CRef ID,
    Person ID (f Key to person table)
    Spouse ID (Person ID as F key to person table)

    Childern Cross Reference Table:
    Link the person to there childern, same principle as Spouse cross reference
    Childern CRef ID,
    Person ID,
    Childern ID

    Person Information
    Person ID,
    Category,
    Information


    I not sure if this will work. I was looking for some help to see if I could come up with a better design and normaliztion of the data needed. Also suggest fields that I may need to make the database more scalable.

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Yes, it is has been done, thought through, and implemented before...

    Family 0.8.pdf
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  3. #3
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    This is the simplest I know of

    If you're a purist, birth and death are also a relationship.
    Attached Thumbnails Attached Thumbnails untitled.JPG  
    Last edited by certus; 08-14-06 at 04:27.

  4. #4
    Join Date
    Jul 2003
    Posts
    74

    Kick-Start Data Model for Family Tree

    Here's a Model on my Database Answers Site to get you started with Genealogy :-
    http://www.databaseanswers.org/data_...logy/index.htm

    Barry Williams

  5. #5
    Join Date
    Apr 2014
    Posts
    1

    Family Tree progress

    Have you ever used Access 2007 to create your family tree database? I'm looking for someone who has.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •