Q1 (C) 

Q2 (A) 

Q3>>>> IT HAS TO BE LIKE THIS 

i))  Show the initial query tree which is a direct translation of the given relational algebra ex-

pression. Please note that your tree should be similar to the tree in Figure 19.4 (a)

ii Show the nal, more ecient query tree you will get after you have applied the dierent

transformations. Please note that you just have to show the nal tree and not the inter-

mediate steps i.e. you only have to show a nal tree similar to Elmasri Figure 19.5 (e)

u have the book u can see those fiugres 19.5 (e) and Figure 19.4 (a) to do the same 

thank u