Questions tagged [family-tree]

A family tree, or pedigree chart, is a chart representing family relationships in a conventional tree structure.

The more detailed family trees used in medicine, , and social work are known as genograms. (From Wikipedia)

165 questions
3
votes
3 answers

SQL Loop over a family tree

Using SQL server 2008. I have a family tree of animals stored in a table, and want to give some information on how 'genetically diverse' (or not) the offspring is. In SQL how can I produce sensible metrics to show how closely related the parents…
simon831
  • 5,166
  • 7
  • 33
  • 50
3
votes
2 answers

SQL database design

I am making a database for a program where i am supposed to model some relations in the family. ex: X is father to Y , Y is son to X So , i have a Members table with all info about each member so i thought about making a many to many relation…
Bashawy
  • 115
  • 1
  • 9
3
votes
3 answers

Simple recursive tree in PHP / MySQL

I have this table in MySQL: id name mother 1 grandma 0 2 myuncle 1 3 mymom 1 4 me 3 5 mysister 3 6 myson 4 7 new_grandma_son…
Albatrosz
  • 309
  • 1
  • 3
  • 9
2
votes
4 answers

Graph and relational database

I'm looking for the best way to store and query a family tree (a graph of people with their relationships like a genealogy ) into a relational database. I guess, that can be easily achieved by using a graph database but I have a strong constrain. I…
Riana
  • 689
  • 6
  • 22
2
votes
1 answer

Partners on same rank in family tree using Python and Graphviz

I am trying to create a family tree using graphviz in python but have a problem with getting the persons on the same rank. In my example I'd like all the partners to be on the same rank for as much as possible. In this example Alice is alone highest…
Jahlove
  • 65
  • 9
2
votes
1 answer

Insert data into table while adding nodes of FamilyTree

hope you all will be fine (sorry for my bad English), I am making a FamilyTree in Oracle apex using PL/SQL Dynamic Content following this example this. Here multiple nodes can be made but the problem is that actually I want to add Node's Data into…
Ali
  • 21
  • 3
2
votes
1 answer

Recursively printing a family tree with objects

I need help with recursive representation of a family tree. Here is the data: children_and_parents = { "Mary": ["Patricia", "Lisa"], "Patricia": ["Barbara", "Helen", "Maria"], "Maria": ["Keren", "Carol"], "Barbara": ["Betty"] } I…
D. K.
  • 137
  • 10
2
votes
1 answer

Which function can replace multiple nested loops in php?

I work on a family-tree function, and I need to iterate a for() statement for each generation. I don't know the number of generation in advance and all for() statements will contain almost the same script... $nb_parents_line1 = 1; for($i = 0 ; $i <…
TOPKAT
  • 6,667
  • 2
  • 44
  • 72
2
votes
2 answers

Prolog - family tree

I am working on creating a family tree in prolog. Where I am running into trouble is when I call on sister or brother. The results I get are correct, where julie is the sister of mike, julie is the sister of amanda, amanda is the sister of mike and…
OmonoiatisUSa
  • 21
  • 1
  • 3
2
votes
1 answer

Best way of implementing a family tree in Java using a data structure

https://softwareengineering.stackexchange.com/questions/285418/name-of-data-structure-thats-tree-like-with-multiple-root-nodes I stumbled upon the above where someone answered a question regarding implementing a tree that has > 2 nodes and I just…
Tj895
  • 56
  • 2
  • 8
2
votes
0 answers

Family Tree class design, in Django

I am working on a Family Tree web app, with Django (which I am new to), and am deciding on how to design a FamilyTree class so that Users can be authorized to view/edit certain Trees only. As it stands, I have two abstract meta classes: Entity and…
2
votes
1 answer

Prolog: Unification or Backtracking errors in program

I have a simple knowledge base that encodes a family tree. Some important rules in this representation are as follows: %…
DarkyTheOdd
  • 128
  • 1
  • 12
2
votes
1 answer

Infinite recursion in SWI-Prolog

I am trying to define a family tree and the relationships between its nodes basing their definitions on three predicates: male/1, female/1 and parent_of/2. I have defined the notions of ascendant, descendant, father, mother, son, daughter,…
2
votes
1 answer

How can I infer closest relatives from other's family trees, based on a seed of distant relatives?

I've taken one of the numerous DNA tests online, and it has identified genetic relatives based on DNA, but most of these relatives are at least 3rd cousins. These other users have their family trees online, which I can access as JSON data. I'm…
coding_hero
  • 1,759
  • 3
  • 19
  • 34
2
votes
0 answers

Prolog Family Tree Blood Relations, Recursion?

I need a recursive function that finds all blood relatives in a family tree. But I honestly have no idea how to implement this in Prolog. My current understanding for a solution, would be to search the current branch for a match and proceed to the…