Consider the following relations: Students(snum: string, sname:string, major:string, level:string, age:int); Enrolled(snum: string, cname: string) And Consider the following query SELCT s.sname, s.age FROM Student s, Enrolled e WHERE s.snum = e.snum and s.level = 'JR' and e.cname = 'Database Management'; Given the following info: T(student) = 10000 records t(Enrolled) = 20000 record D(Student) = 300 pages B(enrolled) = 200 pages V(Student, level) = 5 // (FR, SP, SR, GRAD) V(Enrolled, cname) = 500 //there are 500 different courses) a. please draw a query plan for the above query: join two tables first, then apply selection finaally apply projection. b. Please modify the query plan in (a) to apply push selection rule.
Consider the following relations:
Students(snum: string, sname:string, major:string, level:string, age:int);
Enrolled(snum: string, cname: string)
And Consider the following query
SELCT s.sname, s.age
FROM Student s, Enrolled e
WHERE s.snum = e.snum and s.level = 'JR' and e.cname = '
Given the following info:
T(student) = 10000 records
t(Enrolled) = 20000 record
D(Student) = 300 pages
B(enrolled) = 200 pages
V(Student, level) = 5 // (FR, SP, SR, GRAD)
V(Enrolled, cname) = 500 //there are 500 different courses)
a. please draw a query plan for the above query: join two tables first, then apply selection finaally apply projection.
b. Please modify the query plan in (a) to apply push selection rule.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)