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)

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}

Step by Step Solution

3.34 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a This will produce a relation containing the names of all hotels in London b This will produc... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

672-CS-DB (1231).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!