1.Consider the scenario involving the slowly changing dimension EMPLOYEE shown in the exercise E8.5 above. Assume that Employee table contains the data since the date XXXXXXXXXXAlso, assume Sidney’s...

1.Consider the scenario involving the slowly changing dimension EMPLOYEE shown in the exercise E8.5 above. Assume that Employee table contains the data since the date 1.1.2010. Also, assume Sidney’s title changed from Business Analyst to Senior Business Analyst on 1.1.2015.

a Show the dimension EMPLOYEE (with all of its records) if the Type 2 option for handling slowly changing dimensions is applied, and time stamps and row indicators are used.

b Show the dimension EMPLOYEE (with all of its records) if the Type 3 option for handling slowly changing dimensions is applied, and time stamps are used.