CONVERT TO RELATIONAL ALGEBRA EXPRESSION (data base management system) 1.

CONVERT TO RELATIONAL ALGEBRA EXPRESSION (data base management system)

1.SELECT LNAME, FNAME

FROM EMPLOYEE, WORKS_ON, PROJECT

WHERE DNO=5 AND SSN=ESSN AND PNO=PNUMBER AND PNAME='ProductX' AND HOURS>10

2.SELECT E.LNAME, E.FNAME

FROM EMPLOYEE E, EMPLOYEE S

WHERE S.FNAME='Franklin' AND S.LNAME='Wong' AND E.SUPERSSN=S.SSN

3.SELECT PNAME, SUM (HOURS)

FROM PROJECT, WORKS_ON

WHERE PNUMBER=PNO

GROUP BYPNAME

4.SELECT LNAME, FNAME

FROM EMPLOYEE

WHERE NOT EXISTS

( SELECT *

FROM WORKS_ON

WHERE ESSN=SSN )

5.SELECT DNAME, AVG (SALARY)

FROM DEPARTMENT, EMPLOYEE

WHERE DNUMBER=DNO

GROUP BYDNAME

6.SELECT AVG (SALARY)

FROM EMPLOYEE

WHERE SEX='F'

7.SELECT LNAME, FNAME, ADDRESS

FROM EMPLOYEE

WHEREEXISTS

( SELECT *

FROM WORKS_ON, PROJECT

WHERE SSN=ESSN AND PNO=PNUMBER AND LOCATION='Houston' )

AND NOT EXISTS

( SELECT *

FROM DEPT_LOCATIONS

WHERE DNO=DNUMBER AND DLOCATION='Houston' )

8.SELECT LNAME, FNAME

FROM EMPLOYEE

WHEREEXISTS

( SELECT *

FROM DEPARTMENT

WHERESSN=MGRSSN )

AND NOT EXISTS

( SELECT *

FROM DEPENDENT

WHERE SSN=ESSN )