1)a) Create a procedure raise_amount to adjust the salaries. This procedure will take in the employee ID and the raise amount (expressed as a percentage, such as .06). Based on the raise amount, the salary value in the EMPLOYEES table will be updated to the new salary. Execute the procedure to see the changes in salary column.

b) Create a stored procedure to insert a new record into DEPARTMENTS table with the given department number and name.

Department Number: 300

Department Name: Computer Science

oracie SGL Developer : lable CRACLE-MIN.EMPLOYEESSOCHALORACLE Eile Edit Yiew Nevigate Eun Team Iocls Window Help Wiekcome Page Columns Data IModel IConstraints IGrants IStatstics Triggers IFlashback IDependendies Details Partitions Indexes Isqu EMPLOYEES 1 EMPLOYEE_ID NUMBER ,0) l (null) 2 (nuil) 3 (nuii) 4(null) FIRSI NAME VARCHAR2 (20 BYTE) Yea na1l) (naii) LAST NAME VARCHAR2 (25 BITE) No VARCHAR2 (25 BYTE) No EMAIL 5 PHONE MUMBER VARCHAR2 (30 BYTE) Yea 6 BIRE DAIE 7 JOB ID 8 SALARY 9 CONMISSION PCT UMEER (20,2) 10 MANNGER ID NUMBER (6,0) 11 DEPARTMENT_ID NUMBER(4,0) na1l) (naii) 6 (nuii) (null) 8 (null) 9 (nail) 10 (null) 11 (null) VARCHAR2 (10 BYTE) No UMEER(,2) na1l) (naii) na1l) Messages-Log Messages Statements 000S 01/12/2018 3 orade SQL Developer : lable CRACLE-MIN.EMPLOYEESSOCHALORACLE Eile Edit yiew Navigate Bun Team locs yndow Help Wiekcome Page Columns Data Model lConstraints Grants Statistics Triggers IFlashback IDependendes Details Partitions Indexes Isqu JOB D Abel EABEL 011.44.1644.429267 11-HAY-96 SA REP TAYLOR 011.44.164.129265 24-MAR-98 SA REP KERANT 011.44.1644.429263 24-MAY-99 SA REP na1l 200 Jennifer alen 205 Sheiley 1ggina SHIGGIN 515.123.8080 iotkey EZLOTHEY 011.44.1344-429018 29-AN-00 SA MAN Messages -Log Messages Statements 01/12/2018 3