Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID 901 Abdullah Bisha 10-Feb-1998...

 

Transcribed Image Text:

Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID 901 Abdullah Bisha 10-Feb-1998 10000 101 902 Dafer Abha 01-Oct-1999 5000 102 903 Saad Alaya 10-Dec-1994 8000 101 904 Saeed Riyadh 10-Dec-1990 4000 103 DeptID Dname 001 Management 002 Production 003 Supply Department Table 1. Calculate the net salary if DA is 15% of basic,HRA is 10% of basic and PF 10% if basic salary is less than 6000 „pf is 10% if basic salary between 8000 to 160000. 2. Write a procedure that display department id for a particular person. 3. Write a procedure to display the total number of person of a department 101. 4. Write a function that returns the total number of employee of a particular department. Accept department ID as input parameter. 5. Write a function to find the maximum Salary. Write a PL/SQL program Person Table PNumber PName Address DOB BasicSalary DeptID 901 Abdullah Bisha 10-Feb-1998 10000 101 902 Dafer Abha 01-Oct-1999 5000 102 903 Saad Alaya 10-Dec-1994 8000 101 904 Saeed Riyadh 10-Dec-1990 4000 103 DeptID Dname 001 Management 002 Production 003 Supply Department Table 1. Calculate the net salary if DA is 15% of basic,HRA is 10% of basic and PF 10% if basic salary is less than 6000 „pf is 10% if basic salary between 8000 to 160000. 2. Write a procedure that display department id for a particular person. 3. Write a procedure to display the total number of person of a department 101. 4. Write a function that returns the total number of employee of a particular department. Accept department ID as input parameter. 5. Write a function to find the maximum Salary.

Answer rating: 100% (QA)

declare ename varchar 215 basic number da ... View the full answer