assaiment 1

name FROM Student S, Book B, Checkout C WHERE S.sid = C.sid AND = AND = ’Olden Fames’ AND S.age > 12 AND S.age < 20
Write relational algebra query for the above SQL query.
Using a drawing tool such as Visio or others (ex: is a free one) to draw initial relational algebra query trees for the query generated in question 1.
Transform the initial query trees created above into a more efficient form (use the heuristic rules and show your steps (.