0

20kviews

Draw a query tree for the following Sql query

written 8.5 years ago by meghalikalyankar • 2.3k

modified 3.0 years ago by binitamayekar ★ 6.6k

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 FOLLOW SHARE EDIT

1 Answer

1

3.1kviews

written 8.5 years ago by meghalikalyankar • 2.3k

Step 1: Converting Sql query to Relational algebra expression

Step 2: Converting this Relation algebra expression to query tree

ADD COMMENT SHARE EDIT