Table design


B

Ben

Hi all -

I have a list of employees and I wanted to know if you can share with me how
best to design the table so that it implicitly reflects the hierarchy.

The list of employees contains employees from multiple division.
1.Each division has a division head
2.Below the division head, is a department head, there can be multiple
departments within each division.
3.Within each department, there can be multiple groups.
4.Each group have its own manager
5.Below each group are the individual employees belonging to each of the
groups.

I would like to design a table that would reflect this hierarchy:

.........................Corportate Division head
........................./ \
......................../ \
......................./ \
..................Division Head1 Division Head2
................./ | \ / \
............... / | \ / \
............Dept1 Dept2 Dept3 Dept1 Dept2
.........../ | \ | / | \ / \ / \
........../ | \ | / | \ / \ / \
.......Grp1 Grp2 Grp3 Grp1 Grp1 Grp2 Grp3 Grp1 Grp2 Grp1 Grp2


The Grp numbers in each department are not related to the same Grp number in
other Departments..

Thanks for sharing your thoughts,

Ben

--
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top