Database Systems

The initial query plan generated by the SQL query parser of the DBMS is show below

Query:

SELECT Lname

FROM EMPLOYEE, WORKS_ON, PROJECT

WHERE Pname=Aquarius AND Pnumber=Pno AND Essn=Ssn

AND Bdate > 1957-12-31;

Show how the query plan shown above is optimized by the DBMS based on query optimization using heuristics

i? Lname ?Pname-Aquarius, AND Phumber-Pho AND Essn-Ssn AND Bdate>'1957-12-31' PROJECT EMPLOYEE WORKSON