Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Modelling question

    I am new to DB design and MYSQL (using MYSQL workbench for 1st time) and trying to model a simple family tree DB. Each member of my family has contact info, and a tree of relationships. Any suggestions on how to approach the design?

    (I'm NOT a database designer, obviously), although I have some old (10+ years ago) DB2, Oracle exposure

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    The "simple" family tree is actually one of the more difficult relationships to model.

    At its most basic, you are going to need a table of Persons, a table of RelationshipTypes, and a table of PersonRelationships that implements a many-to-many self-join on the Persons table.
    If it's not practically useful, then it's practically useless.

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

Tags for this Thread

Posting Permissions

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