Describe the relations that would be produced by the following tuple relational calculus expressions:
(a) {H.hotelName | Hotel(H) ? H.city = ‘London’}
(b) {H.hotelName | Hotel(H) ? (?R) (Room(R) ? H.hotelNo ? R.hotelNo?? R.price ? 50)}
(c) {H.hotelName | Hotel(H) ? (?B) (?G) (Booking(B) ? Guest(G) ? H.hotelNo ?
B.hotelNo?? B.guestNo = G.guestNo ?? G.guestName = ‘John Smith’)}
(d) {H.hotelName, G.guestName, B1.dateFrom, B2.dateFrom | Hotel(H) ? Guest(G) ?
Booking(B1) ? Booking(B2) ? H.hotelNo ? B1.hotelNo??
G.guestNo = B1.guestNo ?? B2.hotelNo = B1.hotelNo ?
B2.guestNo = B1.guestNo ?? B2.dateFrom ? B1.dateFrom}
(a) This will produce a relation containing the names of all hotels in London.
(b) This will produce a relation containing the names of all hotels that have a room price above £50.
(c) This will produce a relation containing the names of all hotels that have a booking for a guest called John Smith.
(d) This will produce a relation containing the names of guests who have more than one booking at the same hotel, along with the hotel number and the dates of the bookings.
You might also like to view...
When a method returns a value, you usually want to use it in the ____ method.
A. working B. current C. return D. calling
The appointment area displays ____-minute time slots by default when viewing the Calendar in Day, Work, or Week view.
A. 10 B. 15 C. 30 D. 60
When searching for clip art, Word searches the clip art folders on your hard drive and displays the search results as small pictures called thumbnails.
Answer the following statement true (T) or false (F)
In Excel worksheets, you can create hyperlinks to information on the web.
Answer the following statement true (T) or false (F)