Database planning - Hierarchical problem - Help needed

I'm actually on a problem i don't manage to resolve. I want to implement a thing like this in a table :

              Albert           John
            /        \          /
          /            \       /
    Bert                Chuck
                     /    |   \
                   /      |     \
                 /        |       \
               /          |         \
          Donna        Eddie       Fred
                           \        /
                            \      /
                             \    /
                            Gilbert

All these links are work relationship between employees... So for example, Bert superior is Albert. And Chuck has two superiors : Albert and John

What's in ur point the best method to organize this in a table and do simple queries on it ?

I tried a modified preorder tree traversal algorithm but since it's not hierarchical anymore, i don't manage to get it to work... (some item have two superiors)

Any help welcome... (here or by direct email contact) philippe.lecomte_at_step.fr

Thnks in advance,
Philippe Received on Mon Nov 29 2004 - 12:47:29 CET