QUOTE(dhiraj75 @ 18 Feb, 2008 - 06:05 AM)
how to create database for family tree
what are the tables and what are the columns
First - I'm not sure this is supposed to be in the Java section of the forum. Databases seems more likely.
Second - Post your attempts, we are not supposed to do your homework.
Just an idea from where to start if that is the problem. This is pseudocode:
You have families ( mother, father, kids ) and people
so I would guess something like
Person
name:String
birthDate:Date
sex:Sex
...
Family
mother:Person // check for sex:female!
father:Person // check for sex:male!
kids:Person[]
Note: Each person can be in only one Family as a kid and in several!!! as a mother/father
Note: This structure does not allow homosexual families and expects only 2 parents to be present ( supposed to be the birth ones )
eventual extension to Family is
adoptedChildren:Person[]
Hope this helps.
This post has been edited by oubless: 18 Feb, 2008 - 07:26 AM
18 Feb, 2008 - 05:05 AM
| 