>I'd like to represent our organization's chain of command (i.e. who is
whose
>boss) in a database.
For some ideas see
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
David T. Ashley wrote:
I'd like to represent our organization's chain of command (i.e. who is
whose
boss) in a database.
The reason is that in some contexts, my database application needs to
know
who can view whose time and project records (and the rule is that anyone
above in the chain of command can, anyone at the same level or below
cannot).
Conceptually, this is of course a tree.
What is the best representation?
My notion would be just a single table with a collection of
"boss-subordinate" records. To find person X's boss, query by where X
appears as the subordinate. To find person X's first-level subordinates,
query by where X appears as boss.
Is there a better way to represent a tree?
Thanks, Dave.
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 6/19/2007 1:12 PM
