Is this Relational Algebra, Expression Operator Tree already optimized?
What changes would you make to better optimize this Query?
Use Transformation Rules for the Relational Algebra Operations.
By applying transformation rules, the optimizer can transform one relational algebra expression into an equivalent expression that is known to be more efficient.

Database Schema:
PrivateOwner (ownerNo, fName, lName, address, telNo)
PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo)

 

Project 14 - Query G. Identify the name and telephone number of an owner of a given property. Assuming the 'given property' is 'PA14'. fName, IName, telNo (o propertyNo= 'PA14' (private Owner X ownerNo) Property For Rent TfName, IName, telNo o propertyNo= 'PA14' IX ownerNO private Owner PropertyForRent