for each of the following queries use heuristic query optimization *draw the optimal query tree* showing the steps along with

description of the reduction starting from the initial query tree

Query 7. List the names of managers who have at least one dependent. MGRS(Ssn) \( \leftarrow \pi_{\text {Mgr_ssn }} \) (DEPARTMENT) EMPS_WITH_DEPS(Ssn) Essn (DEPENDENT) MGRS_WITH_DEPS (MGRS EMPS_WITH_DEPS) RESULT Lname,Fname (MGRS_WITH_DEPS * EMPLOYEE) Query 7. List the names of managers who have at least one dependent. MGRS(Ssn) \( \leftarrow \pi_{\text {Mgr_ssn }} \) (DEPARTMENT) EMPS_WITH_DEPS(Ssn) Essn (DEPENDENT) MGRS_WITH_DEPS (MGRS EMPS_WITH_DEPS) RESULT Lname,Fname (MGRS_WITH_DEPS * EMPLOYEE)