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 - 13:07:47 CST
