Level 1 Model Exam Activity 5

jed14
jed14
in Modeling

In Activity 5 of the model building exam, it asks to adjust formulas for EMP02 Employee Expenses module for the Bonus, Car Costs, and medical expenses to reference driver data in EMP03 Employee Drivers by Role module. I have no idea what that means, can you help me?

Tagged:

Answers

  • jasonblinn
    jasonblinn

    Hi @jed14 -

    The EMP03 module should be a driver module that holds the data about the bonus, car costs, medical expenses etc all by Country and Department. So to bring these into your EMP02 Module, you should be able to reference this to the drivers in EMP03, by looking up the Employee Department, and the Employee Country. These details (Department and Country) about the employee can be found in the SYS08 Employee Details Module. 

     

    Hope this helps to clarify. 

    Jason

Categories