Course: Database Management Systems

Consider the following SQL Query:

SELECT FNAME, DNAME

FROM EMP ASN E, DEPT AS D

WHERE E.DNO = D.DNUMBER AND D.DNAME =CCI AND SALARY > 15000;

Draw the initial query tree for the above SQL query, and then show how

the query tree is optimized by applying the Heuristic Rules. (You need to show the tree after applying a rule).