ADC HOTEL BOOKING SYSTEM BSc (Hons) Information Systems
TABLE OF CONTENTS:
Introduction------------------------------------------------------3
Entity Relationship Diagram----------------------------------4
Database Design------------------------------------------------4
Implementation Of Indexes------------------------------------5
Descriptions Of Functions ------------------------------------5
Use Of Appropriate Triggers---------------------------------7
Error Handling Measures------------------------------------7
Individual Contribution---------------------------------------7
2
I NTRODUCT I ON: The ADC hotel management system will focus mainly on the booking act ivities pertaining to the hotel. The administrator will be able to add new bookings, modifying existing boo king, delete bookings, search for bookings and view all bookings. In the context of adding new booking, the system shall be able to record bookingID, custo merID, roomID, roomPrice, no_of_people, checkIn, checkOut and shall be able to calculate the total based on these information. In the context of modifying information about existing booking, the system shall allow the user to input a bookingID and the display all the information pertaining to t hat specific booking and then shall allow the user to modify the data and it shall save it to dat abase. In the case of deleting existing booking,
In the case of searching for bookings, the user shall be able to choose between either search by bookingID or search by customerID. The user shall then input the bookingID or customerID and then all the information pertaining to these shall be visible. In the context of view a ll bookings, the user shall be able to view all information about a specific booking by inputting only the bookingID. The programming language for the interface for ADC hotel booking system will be JSP and t he database will be POSTGRES.
3
ENT IT Y RELAT IO NSH IP DI AGRAM
customer
Booking Has
DATABASE DES IG N admin: username password
Varchar(10) ,PRIMARY KEY Varchar (10)
customer: customerID firstName lastName address phoneNumber
Varchar(10),PRIMARY KEY Varchar(25) Varchar(25) Varchar(25) integer
4
booking: bookingID customerID roomID roomPrice noOfPeople checkIn checkOut total
Varchar(10),PRIMARY KEY Varchar(10), Foreign Key Varchar(10) Varchar(10) integer date date integer
Implementation Of Indexes
Indexes would be used to find rows with specific column values quickly pertaining to the searching functionality of the application to search for any specific customer or booking details.
Description of functions implemented The basic objective of ADC Hotel Booking System is to generalize and simplify the booking process and to provide a efficient, fast, reliable and user-friendly system.
Different functions handling the structure and data files are: 1 Function Password()
Assuming we have multiple users, if a user enters a password and the application checks its validity
5
2.Function AddCustomer()
This is the function used to insert new customer details in the database.
3.Function AddBooking()
This function is used to create a new booking for an existing customer.
4.Function DeleteRow()
This function is used to delete a row from customer and booking table after the customer checks out .
6.Function GenerateBill ()
When a customer checks, his/her bill is in generat ed automatically by calculated check-out date minus check-in date and getting multiplied it by daily room charge plus number of people and the bill is saved in the booking table .
7.Function ModifyCustomer()
This is the function used to update customer details in the database.
8.Function ModifyBooking()
This function is used to create update booking details in the database.
9.Function ViewAll()
This function is used to view the details of all the customers who have a booking .
10. Function Searching()
In this function users can search details from the dat abase according to their authentications
6
U se of appropriate triggers Triggers would be used in booking insertion process so that it: 1. rejects checkin and checkout which is not of Date type 2. rejects room price which is not of type integer
E rror H andling measures taken The validity of data entered by the user during the various processes is checked t hrough various validation checks. For example, there should not be any characters entered in the numeric fields, likewise if there is any error occurs than It should handle that particular error and give t he required messages.
Individ ual contribution
7