Answered You can hire a professional tutor to get the answer.

QUESTION

Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all...

Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all hotels of Star Inn. The following is a description of the conceptual model of the hotel reservation database at Star Inn.

The database contains information about hotels, hotel rooms, customers, and reservation. A hotel can be identified by its identification number (hotel_id). It is also described by hotel_name, address and phone_no. Rooms are identified by room_no which is unique for a hotel. The same room_no may exist in different hotels of Star Inn. Rooms are also described by type and rate.

Customers are identified by customer_id and are described by name (customer_name), address (customer_address), and phone number (customer_phone). When a customer makes a reservation, he/she is asked to specify the hotel, the room type, the arrival date (arrival_date) and duration of stay (duration). A specific room is then booked for the customer. A customer can book the same room more than once. Therefore, a reservation is identified by a reservation number (reservation_no).

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question