1. This question is based on the relations shown below:

PROPERTY

Property	No, City
P1 P2 P3	Perth Melbourne Sydney

LEASE

RenterNo	PropertyNo	LeaseStart	LeaseEnd
R100 R200 R300	P1 P3 P1	1-Jan-15 1-Oct-15 1-Feb-16	1-Jan-16 1-Oct-16 1-Aug-16

(a) Write a relational algebra expression that lists the property number, city, lease start and lease end dates for all the properties located in the city of Perth. Show the relations (structure and data) that would result from the following relational algebra expressions on the relations below:

(b) PROPERTY LEFT JOIN Property.PropertyNo=Lease.PropertyNo LEASE

(c) PropertyNo (PROPERTY) MINUS PropertyNo (LEASE)