For each of these queries based on the Elmasri company database, do the following

ii Show the final, more efficient query tree you will get after you have applied the different transformations. Please note that you just have to show the final tree and not the intermediate steps i.e. you only have to show a final tree similar to Elmasri Figure 19.2 (e), You should try and get the most efficient tree you can

((SIMILAR TREE AS ELMASRI FIGURE 19.2(e)...................

elmasri company database.......

Lname Essn Ssn, Lname Pnumber-Pno Bdate 1957-12-31 Pnumber EssnPno EMPLOYEE Pname-Aquarius WORKS ON PROJECT Lname Essn Ssn, Lname Pnumber-Pno Bdate 1957-12-31 Pnumber EssnPno EMPLOYEE Pname-Aquarius WORKS ON PROJECT