I have been tasked to create an Employee Training Database. We are a manufacturing firm and have approximately 91 Job Descriptions. All personnel are required to complete the common courses, however in each field of work there are unique courses related to that job in addition to the common courses. My question is do I build 91 tables of courses that are applicable to each job description or build 2. 1 with the common courses and the other that lists all of the unique courses. I would relate the common and unique courses to the employee table to bring in just those courses that are applicable to the job description.
Here is my issue. I am not sure how to set up the employee table in addition to the common course and unique course tables such that it will pull in the total of common courses and unique courses for that individual in that job description. We need to track the employees compliance with completion dates and also an alert that will create an early warning report that indicates training is required to be completed by a certain date or employee will be out of compliance.
Thanks for any help
Regards
Gene