Answer question 2,3

Question1: Write a PL/SQL program Person Table 901 PNumber PName Address DOB BasicSalary DeptID Abdullah Bisha 10-Feb-1998 10000 101 902 Dafer Abha 01-Oct-1999 5000 903 Saad Alaya 10-Dec-1994 8000 101 904 Saeed Riyadh 10-Dec-1990 4000 103 102 DeptID Dname 001 Management 002 Production 003 Supply Department Table 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