Note: You have to draw the initial query tree.
Consider the following SQL queries of the Company database. Draw the initial query tree for each of these queries and show how the query tree is optimized by heuristic optimization algorithm.
i) Retrieve the Fname, Lname, and address of all the employees who work for the "Computer Science" department.
ii) Retrieve Name, address, salary, and Dlocation of the employees whose department is located in Delhi and salary > 50000.
iii) Retrieve all project numbers for projects that involve an employee whose last name is "Smith" as a manager of the department that controls the project.