Consider the following view defined on the Hotel schema:

CREATE VIEW HotelBookingCount (hotelNo, bookingCount)

AS SELECT h.hotelNo, COUNT(*)

FROM Hotel h, Room r, Booking b

WHERE h.hotelNo = r.hotelNo AND r.roomNo = b.roomNo

GROUP BY h.hotelNo;

For each of the following queries, state whether the query is valid and for the valid ones show how each of the queries would be mapped on to a query on the underlying base tables. (a) SELECT *

FROM HotelBookingCount;

(b) SELECT hotelNo

FROM HotelBookingCount

WHERE hotelNo = ‘H001’;

(c) SELECT MIN(bookingCount)

FROM HotelBookingCount;

(d) SELECT COUNT(*)

FROM HotelBookingCount;

(e) SELECT hotelNo

FROM HotelBookingCount

WHERE bookingCount > 1000;

(f) SELECT hotelNo

FROM HotelBookingCount

ORDER BY bookingCount;