Database Query Tree Question. Does not even have to be 100% correct, you just ne

Question

Database Query Tree Question. Does not even have to be 100% correct, you just need to make a decent attempt so that I can see how the process works. You can draw it out or type it out. Thanks. (see image) (here is a direct link if you cannot see the image: http://i.imgur.com/Z9l8jRw.jpg)

Consider the following query that finds the names and salaries of employees working on the 'ProductX' project: Assume: nemployee= 100; nworks_on= 100; nproject= 10; Query: pi fname, lname, salary (sigma ssn=essn & pno=pnumber & pname= 'ProductX' ((employee times works on) times project) ) Give the initial query tree. Show the successive query trees generated during the query optimization process. Give a brief justification at each step.

Explanation / Answer

Query tree generated during optimization process

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.