Re: Ordering dependency problem

There is another problem with the adjacency list model: it models a tree but not a heirarchy. Delete an employee in the middle of the tree, and you have multiple disjoint trees. But with the nested sets model, delete an employee in the middle of the tree, and the deleted employee's subordinates report to his former boss. A herarchy has to have inheritance, a tree does not.

I can update all the salaries to make them less than any of each employee's superiors, but I need a formula. Without a rule, I simply give everyone (owner's salary - (level in the organizational chart)) or something and I am done. Received on Fri Jan 18 2002 - 20:07:47 CET