Adam Machanic (1/31/2011)
...Next, a unique constraint on the employee column, so that the same employee can't appear in the hierarchy twice under different managers...
This is correct for tree-like hierarchy only, which is not the case with AD adjacency model.
AD is rather network-like.