SQL

Specify the following queries on the database schema shown in the following figure, using the operations of the relational algebra.

EMPLOYEE PRONE FNAME MAHTUNE MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO BONTE | scores | 3 | SARV SUPERSN | ONO Macesen MGRSTARTDATE DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATIONS DNUMBER DLOCATION PROJECT e PNAME r mange PNUMBER PLOCATION nocnion DNUM WORKS_ON ESSNPN HOURS DEPENDENT ESSN | ESSN DEPENDENT NAME DEPENDENT_NAME SEX SEX BDATE RELATIONSHIP (1) Retrieve the names (fname,lname) of employees in department 4 who work more than 34 hours per week on the 'ENG' project. (ENG is project name.) (2) List the name (dependent name) of female dependents, if the dependents depend on the employees who work for the ME department. (ME is department name). (3) Retrieve the names (fname,lname) of all employees who do not work on any project. (4) Find the names (fname,lname) of employees that are directly supervised by 'Susan Yao