Modify tables organizational structure

[snoopy2003]

Hello,

I wish to model organizational structure into tables.
I have department -> groups -> teams
each department can have 1 to many groups
each group can have 1 to many teams
each group can have 1 to many members that are not in a team


Each department, group & team has name and manager name

Would you advice to store all the data in one table in order to build organizational structure from the data:

tblGROUPS

groupID
groupName
GroupType
GroupManager

or only the teams:


tblTEAMS

teamID
teamName
teamMangerName
GroupMangerNames
DeprtmentManagerName

or model team and group in separate table:
tblTEAMS

teamID
TeamName
Team Manager

tblGroup
groupID
groupName
groupManger

tblTeamInGroups
teamID
groupID

tblEmployePos
empID
teamID
groupID


Thank you for your help

[orange]

I would start with at least these 4 tables.
Dept
Group
Team
Employee

see http://www.databaseanswers.org/data_models/index.htm
for possible data model

Check business rules on the models to see how relationships are used to link tables

once you get a model, use test data to "stump the model". Adjust model as necessary until it meets your
requirements.

[snoopy2003]

Thank you for your help.
I will look in the link above for possible model examples
(and add it to my access bookmarks)

Thank you