I am looking for suggestions on a db design for hierarchial data like an organization
chart or a chart for a large company showing the top organization and all
the subsidiaries. I need to account for an unknown number of levels. I
need to find the top level parent from any place in the tree. And I need
to be able to navigate up or down the hierarchy. Anyone have a design that
does that they like?