B
BURL ives
Situation:
(1) a company has 100 employees
(2) employees have various job titles (director/chemist/VP/technician
etc)
(3) there are 200 procedures in this company and each employee has a
subset of these procedures which they need to be trained on; their
title determines which procedures they are associated with and what
level of training they receive
(4) occasionally the procedures are updated; the updated procedure
creates a need to update the training. The suggested training for the
updated procedure is based on the magnitude of the change and is not
job title dependent
Problem
Want to query the database twice monthly; find procedures that have
changed since the last query, find who is affected by the changes and
ideally email those people all automatically....however to manually
trigger a list of those people affected by the updates would also be
fine.
Here is what I am thinking so far.......
a table of EMPLOYEE NAME and JOB TITLE
a table of JOB TITLE, PROCEDURE NAME,
a table of PROCEDURE NAME, REVISION, DATE and TRAINING TYPE
I am not sure I am on the right track with the Tables and I can't seem
to figure out what the relationships are between tables.
ANY HELP WOULD BE APPRECIATED..........
thank you
(1) a company has 100 employees
(2) employees have various job titles (director/chemist/VP/technician
etc)
(3) there are 200 procedures in this company and each employee has a
subset of these procedures which they need to be trained on; their
title determines which procedures they are associated with and what
level of training they receive
(4) occasionally the procedures are updated; the updated procedure
creates a need to update the training. The suggested training for the
updated procedure is based on the magnitude of the change and is not
job title dependent
Problem
Want to query the database twice monthly; find procedures that have
changed since the last query, find who is affected by the changes and
ideally email those people all automatically....however to manually
trigger a list of those people affected by the updates would also be
fine.
Here is what I am thinking so far.......
a table of EMPLOYEE NAME and JOB TITLE
a table of JOB TITLE, PROCEDURE NAME,
a table of PROCEDURE NAME, REVISION, DATE and TRAINING TYPE
I am not sure I am on the right track with the Tables and I can't seem
to figure out what the relationships are between tables.
ANY HELP WOULD BE APPRECIATED..........
thank you