Describe the relations that would be produced by the following tuple relational calculus expressions: (a) {H.hotelName |
Question:
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.hotel No R.price >50)}
(c) {H.hotelName | Hotel (H) ($B) ($G) (Booking(B) Guest(G) H.hotelNo = B.hotelNo B.guest No = 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}
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg
Question Posted: