Table design Ben 12/26/2008 8:58:00 PM 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 --

Re: Table design "Pete D." <pduffy211AT[ at ]coxDOT.net> 12/26/2008 10:00:55 PM You might find this interesting http://allenbrowne.com/AppHuman.html "Ben" <Ben[ at ]discussions.microsoft.com> wrote in message news:6DE8549A-CF10-4968-8D26-5C3A8BD8B1D2[ at ]microsoft.com... [Quoted Text] > 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 > > -- >

Re: Table design "Steve" <nonsense[ at ]nomsense.com> 12/26/2008 11:39:26 PM 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" <Ben[ at ]discussions.microsoft.com> wrote in message news:6DE8549A-CF10-4968-8D26-5C3A8BD8B1D2[ at ]microsoft.com... [Quoted Text] > 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 > > -- >

Re: Table design Ben 12/29/2008 7:50:00 PM Thanks Pete. Ben -- "Pete D." wrote: [Quoted Text] > You might find this interesting > http://allenbrowne.com/AppHuman.html > > "Ben" <Ben[ at ]discussions.microsoft.com> wrote in message > news:6DE8549A-CF10-4968-8D26-5C3A8BD8B1D2[ at ]microsoft.com... > > 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 > > > > -- > > > > >

Re: Table design Ben 12/29/2008 7:52:01 PM Steve, I am finally able to see the post. Thanks for tip. Thanks, Ben -- "Steve" wrote: [Quoted Text] > 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" <Ben[ at ]discussions.microsoft.com> wrote in message > news:6DE8549A-CF10-4968-8D26-5C3A8BD8B1D2[ at ]microsoft.com... > > 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 > > > > -- > > > > >