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
(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
Class Hotel Extent hotels key hotelNo Attribute string hotelNo Attribute string hotelName Attribute string city Relationship set Contains inverse Room... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
672-CS-DB (1483).docx
120 KBs Word File
