Draw a query tree for the following Sql query

0

19kviews

Draw a query tree for the following Sql query

written 8.0 years ago by

meghalikalyankar • 2.2k

modified 2.5 years ago by

binitamayekar ★ 6.4k

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’

database management systems advanced database management systems

ADD COMMENT EDIT

1 Answer

1

3.0kviews

written 8.0 years ago by

meghalikalyankar • 2.2k

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

Create a free account to keep reading this post.

and 4 others joined a min ago.

ADD COMMENT EDIT

Please log in to add an answer.