Draw a query tree

Draw a query tree for the following Sql query

Select P.Pnumber, P.Dnum ,E.Lname,E.Address,E.Bdate

From Project as P Department as D Employee as E

Where P.Dnum=D.Dnumber

And D.Mgr_ssn=E.ssn

And P.Plocation=’chennai’

Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2013

1 Answer

Step 1: Converting Sql query to Relational algebra expression

enter image description here

Step 2: Converting this Relation algebra expression to query tree

enter image description here

Please log in to add an answer.