SQL

Part 05 In this part we create a small procedure with a cursor: 1. Write a procedure that has as input the department_id. Then the procedure should search through all the employees of this department and if their commission percentage is empty or is 0.15 or less, then update it to either 1/10000*employee salary (if originally empty) or to 0.1 + 1/10000*employee salary if it was originally 0.15 or less. 2. Give an example of execution. 3. What will happen if you ROLLBACK; Part 06 1. Use the metadata tables for users to count how many tables, how many indexes and how many views you have created in your database. 2. Write an anonymous block with dynamic SQL to drop all the NON-Unique indexes in your database