1. This question is based on the relations shown below: PROPERTY Property No, City P1 P2 P3...

Fantastic news! We've Found the answer you've been seeking!

Question:

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

PROPERTY

Property

No, City

Perth

Melbourne

Sydney

LEASE

RenterNo

PropertyNo

LeaseStart

LeaseEnd

R100

R200

R300

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