db design

M

mnature

Just as a suggestion, make the following tables. This would assume that you
can come up with unique names for your departments, groups, teams, and
subteams. I suppose that similar names could just include the name of the
section above them, to distinguish (for instance, you could have Acct group
in two departments, but distinguish them by ShippingAcct and
ReceivablesAcct). But by including all of them with each employee, you can
have a team and subteam that are just place-holders, and could filter those
out for reports.

TblEmployee
EmployeeID
EmployeeName
DeptID
GroupID
TeamID
SubteamID

TblDept
DeptID
DeptName

TblGroup
GroupID
GroupName

TblTeam
TeamID
TeamName

TblSubteam
SubteamID
SubteamName
 

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

Similar Threads

Database Design and Relationships 2
Database Design and Relationships 2
Table Design: Tests required for some but not all. Where to tell thedifference. 2
Employee Time Tracker 2
ADH paired listbox formatting 5
Design change prevents data update 1
Help - Hockey Pool Database 0
Can't return all records 0

Top