Create an Oracle sequence named CUST_NUM_SEQ to generate values for customer numbers. The sequence should start with the value 2000. Create an Oracle sequence named INV_NUM_SEQ to generate values for invoice numbers. The sequence should start with the value 9000. Create a trigger named trg_updatecustbalance to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is entered. (Assume that the sale is a credit sale.) Whatever value appears in the INV_AMOUNT column of the new invoice should be added to the customer’s balance. Test the trigger using the following new INVOICE record, which would add 225.40 to the balance of customer 1001: 8005, 1001, '27-APR-18', 225.40

Q1. Create a stored procedure that will list all customers (name and number) represented by rep 15. (SQL)

Please use sql to answer the follwoing question (an erd has also been add) Task 2: Task: UPDATE all employees salary in department 40 or 60 depending on their current salary range. Create a cursor and load all the records belongs to employees who works in department either in 40 or 60 a) Include employee_id, last_name, department_id and salary in Cursor SELECT Cursor cur_emp1 IS SELECT employee_id, last_name, department_id, salary FROM EMPLOYEES WHERE department_id IN (40,60); b) Now inside BEGIN and END block create CURSOR FOR LOOP with k keyword. FOR k IN cur_emp1     LOOP END LOOP; now inside above for loop check each records salary IF If employee salary is less than 5000 then add 20% of their salary and update actual phsyical table                       update employees SET salary= salary*1.20                       WHERE employee_id = k.salary;             Else if if employee salary is less then 8000 add 15%                             update employees SET salary=…