Please help on these questions that we are facing difficulty. Thank you.

1. Write a PL/SQL program to check whether specified employee is present in EMP table or not. Accept emp no from user. If employee does not exist display message using exception handling. 2. Consider the following COMPANY database. EMP (Name, SSN, Salary, SuperSSN, Dno) DEPT (DNum, Dname, Mgr SSN, Dno) DEPT_LOC (Dnum, Dlocation) DEPENDENT (ESSN, Dep name, Sex) WORKS_ON (ESSN, Pno, Hours) PROJECT (Pname, Pnumber, Plocation, Dnum) Write the SQL queries for the following. 3. Consider the following COMPANY database. EMP (Name, SSN, Salary, SuperSSN, Dno) DEPT (DNum, Dname, Mgr SSN, Dno) DEPT_LOC (Dnum, Dlocation) DEPENDENT (ESSN, Dep name, Sex) WORKS_ON (ESSN, Pno, Hours) PROJECT (Pname, Pnumber, Plocation, Dnum) Write the SQL queries for the following i) Retrieve the name of the employee who works with same department as "Nick" ii) Retrieve the number of dependents for an employee Alex iii) Retrieve the name of the managers working in location "Dubai" who has no female dependents iv) List female employees from Dno=20 earning more than 3000$ v) List "IT" department details