'SYS08 Employee Details'.Region


I'm having a little difficulty in the exam on activity 6.  I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08.  Am I going down the wrong path or how should I think about updating this region in the module?



Best Answer

  • JaredDolich


    So close! Just to add to @einas.ibrahim query. In the SYS08 module you were asked to add a line item called Region. Since you already know the country of the employee then you can easily determine the region using the function PARENT(). Parent(Country) .

    The system module is used like a lookup table. In this way, you don't need to add the Region to your module that has all the data in it because it would just repeat the region unnecessarily and take up space.

    Give it another try. I think you've got this.