The Problem Statement is given below for your reference :
Create the following tables with proper integrity constraints:
Employee (id, name, sal, dname)
Department (dname, loc)
Every employee id must begin with ‘EMP’, the minimum salary of an employee should be 12000 and all departments are located in one of the following locations: Kolkata, Bangalore and Chennai.
Write a PL/SQL code using cursor to increase the salary of all the employees from Kolkata by 10% and decrease the salary of all the employees from Bangalore by 5%. Ensure that the updating is properly done.
