Question: Map the object-oriented design for the Hotel case study produced in Exercise 27.22 to the ODMG ODL. (a). List all hotels. (b). List all single

Map the object-oriented design for the Hotel case study produced in Exercise 27.22 to the ODMG ODL.
(a). List all hotels.
(b). List all single rooms with a price below £20.00 per night.
(c). List the names and addresses of all guests.
(d). List the price and type of all rooms at the Grosvenor Hotel.
(e). List all guests currently staying at the Grosvenor Hotel.
(f). List the details of all rooms at the Grosvenor Hotel, including the name of the guest Staying in the room, if the room is occupied.
(g). List the guest details (guestNo, name and address) of all guests staying at the Grosvenor Hotel.

Step by Step Solution

3.45 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Class Hotel Extent hotels key hotelNo Attribute string hotelNo Attribute string hotelName Attribute string city Relationship set Contains inverse Room... 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 (1483).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!