Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Branch(branchno,street,city,postcode) Staff(staffno,fname,lname,position,sex,dob,salary,branchno) PrivateOwner(ownerno,fname,lname,address,telno,email,password) PropertyForRent(propertyno,street,city,postcode,type,rooms,rent,ownerno,staffno,branchno) please draw 3 query plans (trees) for select s.fname, b.city, p.rent, po.telno from Starr s, Branch b, PropertyForRent p, PrivateOwner po
Branch(branchno,street,city,postcode)
Staff(staffno,fname,lname,position,sex,dob,salary,branchno)
PrivateOwner(ownerno,fname,lname,address,telno,email,password)
PropertyForRent(propertyno,street,city,postcode,type,rooms,rent,ownerno,staffno,branchno)
please draw 3 query plans (trees) for
select s.fname, b.city, p.rent, po.telno
from Starr s, Branch b, PropertyForRent p, PrivateOwner po
where s.branchno=b.branchno and p.branchno=b.branchno and
po.ownerno=p.ownerno and b.city='London';
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started