Question 1. Relational Algebra (10 marks)

Given the following set of relations, which represent an online holiday rental system where guests book properties owned by hosts. Note that a particular property can only be rented by a single guest at a particular time:

GUEST (guest_id, guest_name, guest_address, guest_mobile)

BOOKING (guest_id, prop_id, booking_startdate, booking_enddate, booking_totalguest)

PROPERTY (prop_id, prop_streetaddress, prop_city, prop_state, prop_capacity, prop_pricepernight, prop_cleaningfee, host_id)

HOST (host_id, host_name, host_mobile, host_email)

Write the relational algebra for the following queries (your answer must show an understanding of query efficiency).

project: π  select: σ  join: ⨝  intersect ⋂ union ⋃  minus -

 (a) List the street address, city, and state of all properties which were booked by a guest named ‘Jack Kaniva’. You may assume that there is only one guest who has such a name [4 marks]