Database Setup

[SITCFanTN]

I need to create a database to document employees performance. I need to
list the employee, their department and then their job functions that they
are responsible for. Each employee in the unit share the same job functions.
I need to list about 15 different criteria for each job function and this is
where I'm struggling. Would it be best to have a table for each job function
and have the criteria part of that table, if I did that I'd end up with about
30 tables. I'm thinking there has to be an easier way, I just don't know
what that would be. Any help you can give is appreciated.

 

[Roger Carlson]

You need to spend some time learning Relational database design. First of
all, read "Database Design for Mere Mortals" by Michael Hernandez. After
that, take a look at some tutorials I designed to help cement these
principles. You can find them here:
http://www.rogersaccesslibrary.com/Tutorials.html Click on the Database
Design link.

 

[Arvin Meyer [MVP]]

One table for all JobFunctions and another table for EmployeeJobFunctions
with EmployeeID from the Employees table, and JobFunctionID from the
JobFunctions table.