Imagine you have been asked to develop a booking system for the
Colombo Marriot
Hotel, a new hotel proposed to be built in the Colombo Port City.
Your specific task
is to design the “make advance reservation” scenario. When making
an advance
booking, the scenario of events is as follows.
To book a room, the customer requests to view room types and is
provided three
types of room: Single, Double or Family. The customer then selects
a room type and
is then supplied with details of each room type, including En-suite
bathroom, minibar, internet connection and/or TV, etc. The customer
then needs to enter the start date
and number of nights of stay. If a room is available, the system
displays the cost of
the stay. If the customer is happy with the cost, the customer
enters a name and email
address. The system will then make the reservation and provides a
reservation
number. The customer is then asked to supply payment card details,
including card
number, issue date, and expiry date. The system will then transact
the payment and
provides confirmation of reservation.
An existing payment transaction system is already in place at the
Heritance. There is
no requirement to replace the existing payment transaction system
which works
perfectly well at the moment. The new hotel reservation is required
therefore to
integrate with the existing payment transaction system.
1. Draw use-case diagrams for the make advance reservation
scenario.
2. Draw a class diagram for the Hotel Room Booking System. You may
assume
that an external system exists for payment card
validation.
Imagine you have been asked to develop a booking system for the Colombo Marriot Hotel, a...
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...
Use Case Modeling APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online reservation system (HORSE) for his new hotel located in Antalya. The hotel has two types of rooms: regular and suit. In order to make a reservation or cancel any other, the clients (persons or travel agency) must logon the system. The clients should register to the system through their names, e-mail and telephone information. Clients will be able to query the availability of the...
Database
Exercise I (50 pts): This exercise deals with a database that stores information about Hotel Management System. Customer (C email, name, country) Payment (Invoice id, C email, payment method, date) invoice (Invoice id, starus, invoice description) Has (Bill id. Invoice id) 9a Bill (Invoice id, Bill id, amount, Bname, type, date, reservation id) Reservation (Hotel id, room id, C email, date, period, reservation id) Rooms(Hotel id. room id, price, category) Hotel (Hotel id. H name. country) Own (room id,...
Objective: To implement the programming languages features discussed in class and to develop a program that uses Graphical User Interfaces (GUI) that provides a friendly environment for users. Project Assignment Design and implement a Hotel Reservation System. The hotel has two types of rooms. One is regular room that has two beds. Another is deluxe room that has two beds and a safe. The regular room price is $120 per night. The deluxe room is $130 per night. A safe...
making a file You are tasked with creating a text-based program for storing data on Hotel Room Bookings - however, as this is a comparative languages course, you will be creating the same application in the following three programming languages: • Java, • Python, and • Lisp As you implement the application in each language you should keep notes on: - The features of the languages used, - Which features you found useful, and - Any issues or complications which...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
Systems Analysis Read the following scenario and answer the questions below. A company hires out property renovation equipment (for example floor sanders, polishing machines, paint sprayers, sandblasters, scaffolding, etc.) to customers. Traditionally, they have used paper based records, but now they want customers to be able to rent out equipment online, or in person from the reception desk. When dealing with a booking, or allocating an available item to a customer, the new system needs to check whether the customer...
Systems Analysis Read the following scenario and answer the questions below. A company hires out property renovation equipment (for example floor sanders, polishing machines, paint sprayers, sandblasters, scaffolding, etc.) to customers. Traditionally, they have used paper based records, but now they want customers to be able to rent out equipment online, or in person from the reception desk. When dealing with a booking, or allocating an available item to a customer, the new system needs to check whether the customer...
. Spring Breaks ‘R’ Us (SBRU) is an online travel service that books spring break trips to resorts for college students. The basic idea is to get a group of students to book a room at a resort for one of the traditional spring break weeks. SBRU contracts with dozens of resorts in key spring break destinations in Florida, Texas, the Caribbean, and Mexico. Its Web site shows information on each resort and includes prices, available rooms, and special features....
Smart Driving School (SDS) was established recently. SDS has five branches in Canberra. SDS requires your team to design a database system to enable more smooth operation of the centre. The details of the branches of SDS are: Branch nameAddressSDS Dickson150 Camilla Way, Dickson, 2662, ACTSDS Page12 Page St, Page, 2614, Page, ACTSDS Franklin12 Franklin St, Franklin, 2912, Franklin, ACTSDS City12 Bunda St, 2601, City, ACTSDS Bruce12 Norman Fisher Crt, 2617, Bruce, ACT SDS database will record and store the data about...