Question

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).

Please use Visible Analyst or any other CASE tool to draw the ERD.

Answer 1

Answer:

Max guests type id Room Type Has anaged room no usernamepassword) (user d Room ld email Administrator By user leV Guest Books Pays Chance Reservation Payment usernameP3ssword no guest Hotel yment id room no yment id rriv Hotel typ Hotel ty pe Booking d partute