Project $14$ Description $($Query Read$/$Write Cost & Relational Algebra Trees$)$

Complete Pblm$.23\mathrm{.}16,$ pg$.733$ with the following modifications

Staff $15000$ tuples

$$ Branch $750$ tuples

$750$ Managers

$25$ London Branches

Generate Relational Algebra Trees $($R$.$A$.$T$)$ as described in the analysis Phase $$of $$Query Decomposition$$ for Pblm$.23\mathrm{.}18($a$),$ pg$.733.$ Create the tree and then show & explain $1$ improvement for efficiency using section $23\mathrm{.}3\mathrm{.}2.$ There will be a total of two R$.$A$.$T $($i$.$e$.$ initial tree & improved tree$).$

$$

Submit all solutions in MS Word document, Project$14.$doc. $$The RAT solutions can be hand drawn with the images pasted into the Word document