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 )
Hi there! Click one of our representatives below and we will get back to you as soon as possible.