b

Consider the following schema: Employee (SSN, FName, LName, Address, Dno, Mgrssn, Sal) Department(Dnumber, Dname, Location, Dmgrssn) SELECT Fname, Lname, Address FROM Employee, Department WHERE Dname='Finance' AND Salary> 100000 AND Dnumber=Dno; Consider the above query. Find out the best evaluation plan for the query using heuristic optimization. Show the initial query tree, all intermediate query trees and the optimal query tree