I am looking into a feasible way of drawing relationships between Elements from a database. An example: Element x is related to Element Y via the Role "sister".
Relationships exist in the form 1:1, 1:n or m:n, so one element may link to >1 other elements, there are also >1 element types and >1 role types.
Right now it is done manually in Powerpoint, which is really prone to errors. Is there a suitable way to draw these diagrams via TikZ/PGF or any other software? I'd love to write some SQL script to get me the list of elements with their relationship and have e.g. Python prepare the TeX Code. The major challenge is for me, that I have no clue how many elements come from the database and I would like to have LaTeX do the positioning.