If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table design
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 -- |
#2
|
|||
|
|||
Table design
You might find this interesting
http://allenbrowne.com/AppHuman.html "Ben" wrote in message ... 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 -- |
#3
|
|||
|
|||
Table design
TblEmployee
EmployeeID FirstName MI LastName etc TblPosition PositionID Position Where Position can be: Corporate Division Head Division Head Department Manager Employee TblCorp CorpID Corpname other needed corp fields TblDivision DivisionID CorpID Division TblDept DeptID DivisionID Division TblGroup GroupID DeptID Group TblGroupEmployee GroupEmployeeID EmployeeID GroupID PositionID By associating every employee of the corporation with a group, defines the employee belonging to the corporation, a specific division, a specific department and a specific group. By specifying each employee's position, you define whether he is just a member of a group (employee), a department manager, division head or the boss of the whole shebang. Steve "Ben" wrote in message ... 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 -- |
#4
|
|||
|
|||
Table design
Thanks Pete.
Ben -- "Pete D." wrote: You might find this interesting http://allenbrowne.com/AppHuman.html "Ben" wrote in message ... 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 -- |
#5
|
|||
|
|||
Table design
Steve,
I am finally able to see the post. Thanks for tip. Thanks, Ben -- "Steve" wrote: TblEmployee EmployeeID FirstName MI LastName etc TblPosition PositionID Position Where Position can be: Corporate Division Head Division Head Department Manager Employee TblCorp CorpID Corpname other needed corp fields TblDivision DivisionID CorpID Division TblDept DeptID DivisionID Division TblGroup GroupID DeptID Group TblGroupEmployee GroupEmployeeID EmployeeID GroupID PositionID By associating every employee of the corporation with a group, defines the employee belonging to the corporation, a specific division, a specific department and a specific group. By specifying each employee's position, you define whether he is just a member of a group (employee), a department manager, division head or the boss of the whole shebang. Steve "Ben" wrote in message ... 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 -- |
Thread Tools | |
Display Modes | |
|
|