Derive the optimized tree for the below query using heuristic approach SELECT Dname, COUNT (*) FROM DEPARTMENT, EMPLOYEE, DEPENDENT WHERE Dnumber=Dno AND SSN=ESSN and Salary>40000 GROUP BY Dname...

Please do this correctly..

Extracted text: Derive the optimized tree for the below query using heuristic approach SELECT Dname, COUNT (*) FROM DEPARTMENT, EMPLOYEE, DEPENDENT WHERE Dnumber=Dno AND SSN=ESSN and Salary>40000 GROUP BY Dname HAVING COUNT (*) > 5;