QUESTION $4$

The following tables form part of a database held in a relational DBMS:

Hotel $($hotelNo$,$ hotelName, city$)$

Room $($roomNo$,$ hotelNo, type, price$)$

Booking $($hotelNo$,$ guestNo, dateFrom, dateTo, roomNo$)$

Guest $($guestNo$,$ guestName, guestAddress$)$

where Hotel contains hotel details and hotelNo is the primary key;

Room contains room details for each hotel and $($roomNo$,$ hotelNo$)$ forms the primary key;

Booking contains details of the bookings and $($hotelNo$,$ guestNo, dateFrom$)$ forms the primary key;

and Guest contains guest details and guestNo is the primary key.

Using the above information which RA statement will select a list of all single rooms with a price below $$20$ per night?

sigma space p r i c e less than $20$ space left parenthesis R o o m right parenthesis

none

sigma space t y p e equals apostrophe S apostrophe logical and p r i c e equals $20$ space left parenthesis H o t e l right parenthesis

sigma space t y p e equals apostrophe S apostrophe logical and p r i c e less than $20$ space left parenthesis R o o m right parenthesis