Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Neo4j

Authors: Gregory Jordan

1st Edition

ISBN: 1484200225, 9781484200223

More Books

Students also viewed these Databases questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago