EMPLOYEE Employeekey EmployeeID E101 E202 E303 EmployeeName Ava Sidney Lena EmployeeTitle Project Manager Business Analyst Senior Business Analyst Assume Sidney's title changes from Business Analyst to Senior Business Analyst. i. Show the dimension EMPLOYEE (with all of its records) if the Type 1 option for handling slowly changing dimensions is applied. ii. Show the dimension EMPLOYEE (with all of its records) if the Type 2 option for handling slowly changing dimensions is applied (do not use time stamps and row indicators). iii. Show the dimension EMPLOYEE (with all of its records) if the Type 3 option for handling slowly changing dimensions is applied (do not use time stamps). Consider the scenario involving the slowly changing dimension EMPLOYEE as shown in the figure 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.

Please convert this use case diagram to activity diagram

None

ALO (Anderson - left - overs.) Enterprises is an organization that provides a wide variety of service offerings for clients. Service types available include bookkeeping, computer installation, computer repair, software installation, taxes, advertising, market surveys, etc. Each service engagement may involve multiple types of service and may include multiple employees. Each type of service has a standard hourly billing rate and can not be entered into the database unless at least one of ALQ's employees is capable of performing that type of service. Employees are trained to perform multiple types of services and can work on multiple service engagements. Employees earn a contracted annual salary based on their credentials, regardless of what services they actually end up performing. Clients are required to pay for a given service engagement in full ( with just one check) within two weeks of the completion date. It is possible for a client to pay for more than one service engagement with…