Course Mandatory to Department / Jobs - Mapping

Content

We have a requirement as below:

Each course is required for a combination of Department and Job. This need to be mapped and stored in the system, such that we can have complaince report for each required course. The complaince report will be based on Number of employee enrolled for Madatory course etc.

 

I am looking for various methods this can be mapped into system, considering glitch free reports at Reporting Level.