Hotel Management System
Hotel Management System
With Online Environment For
With Online Environment For
Hotel Riviera
Hotel Riviera
FHA.SHIBLY FHA.SHIBLY SEU/IS/03/MG/031 SEU/IS/03/MG/031Outline
Outline
•• Background of The CompanyBackground of The Company
•• Introduction to Hotel Management SystemIntroduction to Hotel Management System
•• Technology Used in the HMSTechnology Used in the HMS
•• System Analysis and My Approach to theSystem Analysis and My Approach to the
System System
•• DesignDesign
•• ImplementationImplementation
•• Testing and EvaluationTesting and Evaluation
Outline
Outline
•• Background of The CompanyBackground of The Company
•• Introduction to Hotel Management SystemIntroduction to Hotel Management System
•• Technology Used in the HMSTechnology Used in the HMS
•• System Analysis and My Approach to theSystem Analysis and My Approach to the
System System
•• DesignDesign
•• ImplementationImplementation
•• Testing and EvaluationTesting and Evaluation
Background
Background of
of the
the hotel
hotel Riviera
Riviera
•• The Riviera resort is a Tourist Resort. It isThe Riviera resort is a Tourist Resort. It is located in the charming fishing town of
located in the charming fishing town of Batticaloa, in the eastern coastal
Batticaloa, in the eastern coastal district of district of Sri Lanka. This resort was established in
Sri Lanka. This resort was established in 2000.
•• This resort has 38 rooms with all theThis resort has 38 rooms with all the Facilities.
Facilities.
•• There are double single and family roomsThere are double single and family rooms with attached bathrooms. There are in
with attached bathrooms. There are in door and out door games
door and out door games facilities withfacilities with
swimming pool. Air-conditioned rooms too swimming pool. Air-conditioned rooms too are available.
Introduction of current system
• Guest registration • Room reservation • Food order
Problems identified
• It takes more time to reserve the room. So
performance of the current system is slow.
• Now the current system is running
manually. So they are facing the following problems.
• Difficult to handle data accurately and
security because of the data lost, viewing by unauthorized people, can’t collect the data at the time.
• Day to day current system is very costly
• So security wise is not guarantee to all information and data’s.
• If customer wants search their details it very difficult • Processing delay
• Not easy to handle room details • Storage problems
• Unable to analyze past data
• (Update, Search, Delete, Edit), these types of
methods are not accessible and not carry with the manual method
Introduction to Online Hotel
Management System (OHMS)
• To resolve the current problems the Hotel decided to do in Fashionable way so that they no their situation. So Hotel agreed to do in computerized method to resolve the reservations problems. The Hotel believes that advantages of doing in a computerized system.
• The system will help the Hotel Riviera to operate efficiently by eliminating all the
time consuming procedures and provide a better service to their customers as well as for the employees in the company.
• Two Main Parts
– Web Based Reservation System (Customer’s Perspective)
– Hotel Reservation System (Administration Perspective)
Features of the New System
• Handling Customer Details• Reservations • Cancellations
• Handling Rooms Details • Making Payments
• Features like Update, Searching, Deleting, Editing Record etc...
• Generating different kinds of report.
• Customers can view videos of hotel rooms with audio explanations.
• Customers Make reservations, enquiries and cancellations via online.
Waterfall Development-based
Methodology
Method of Analysis
• E-R Diagrams
• Relations/Tables
• Data Flow Diagram
– Context Diagram (0 Level DFD) – Level 1 DFD
– Level 1 DFD
Data Flow Diagram (DFD)
• Data Flow diagrams are a network representation of a system.
• Four entities that must be represented are:
– Data flows: movement of data in the system
– Data stores: data repositories for data that is not moving
– Processes: transforms of incoming data flows to out going data flows
– External entities: sources or destinations outside the specified system boundary
Context Level for Proposed System R e q f o r G u e s t D e t a i l s R e q f o r R o o m D e t a i l s G u e s t D e t a i l s C o n f i r m t h e R o o m R e q f o r P a y m e n t P a y m e n t R e s e r v a t i o n F o r m C u s t o m e r s Hotel Reservation System G u e s t R o o m D e t a i l s R e c e p t i o n i s t C o n f i r m t h e R e s r v a t i o n R e q f o r R e s e r v a t i o n D e t a i l s R e s e r v a t i o n D e t a i l s R e q f o r P a y m e n t D e t a i l s G u e s t D e t a i l s P a y m e n t D e t a i l s R e q f o r G u e s t D e t a i l s M a n a g e m e n t R e q f o r F a c
i l i t y P a y m e n t Y e a r l y R e s e r v a t i o n R e p o r t M o n t h l y R e s e r v a t i o n R e p o r t R e q f o r a v a i l a b l e F a c i l i t y R e q f o r R e s e r v a t i o n F o r m R e q f o r C a n c e l l a t i o n C o n f i r m o r R e j e c t C a n c e l l a t i o n F a c i l i t y D e t a i l s F a c i l i t y P a y m e n t R e c e i p t C o n f i r m t h e F a c i l i t i e s F a c i l i t y P a y m e n t R e q f o r F a c
i l i t y
P a y m e n t d e t a i l s C a n c e l l a t i o n R e p o r t R e q f o r C a n c e l l a t i o n R e p o r t C o n f i r m t h e R o o m
`
1 Reservation Process 2 Payment Process 4 Report Process G u e s t M a n a g e m e n t R e c e p t i o n i s t R e s e r v a ti o n D e t a il s R e q f o r R o o m D e t a i l s G u e s t D e t a i l s C o n f i r m t h e R o o m R e q f o r P a y m e n t P a y m e n t R o o m D e t a i l s R e c e i p t C o n f i r m t h e P a y m e n t R e q f o r G u e s tD e t a i l s C o n f i r m t
h e R e s e r v a t io n R e q f o r P a y m e n t D e t a i l s G u e s t D e t a i l s P a y m e n t D e t a i l s R e q f o r G u e s t D e t a i l s Y e a r l y R e s e r v a t i o n R e p o r t M o n t h l y R e s e r v a t i o n R e p o r t 3 Facility Process 5 Cancellation Process R e q f o r R e s e r v a t i o n F o r m R e s e r v a t i o n F o r m G u e s t R e q f o r F
a c i l i t y P a y m e n t R e q f o r a v a i l a b l e F a
c i l t i e s
R e q f o r C a n c e l l a ti o n F a c i l i t y D e t a i l s F a c i l i t y P a y m e n t C o n f i r m t h e F a c i l i t i e s C o n f i r m
o r R e j e c t C a n c e l l a t i o
n
R e q f o r R e s e r v a t i o n
D e t a i l s F a c i l i t y P a y m e n t R e q f o r F a c i l i t y P a y m e n t d e t a i l s C a n c e l l a t i o n R e p o r t R e q f o r C a n c e l l a t i o n R e p o r t 2 Reservation 5 Payment 1 Guest 4 Facility Payment 7 Cancellation 6 Facility details 3 Room R e s e r v a t i o n D e t a i l s F a c i li t y D e t a i l s R e q f o r C a n c e l l a t i o n d e t a i l s C a n c e l l a t i o n d e t a i l s
Req for available Facility
Facility Details R e q f o r R e s e r v a t i o n D e t a i l s R e s e r v a t i o n D e t a i l s R e q f o r G u e s t D e t a i l s G u e s t D e t a i l s R e q f o r F
a c i l i t y P a
y m e n t d
e t a i l s F
a c i l i t y P a y m e n t d e t a i l s Update Update Update Update Update Update Room Details
Req for Room Details
P a y m e n t D e t a i l s C o n f ir m t h e R o o m R e s e r v a t i o n D e t a i l s
Second Level for Proposed System 1.1 Reservation Process 1 Guest G u e s t 2 Reservation Update 3 Receptionist
C o n f i r m t h e R
e s e r v a ti o n R e q fo r R
e s e r v a t io n
2 Payment Process 1.2 Inquiry Process R e q f o r R o o m D e t a i l s G u e s t D e t a i l s C o n f i r m t h e R o o m R o o m D e t a i l s R e q f o r G u e s t D e t a i l s Update Room Room Details
Req for Room Details
R e s e r v a t i o n D e t a i l s R e q f o r R e s e r v a t i o n F o r m R e s e r v a t i o n F o r m R e s e r v a t i o n D e t a i l s C o n f i r m t h e R o o m 5 Cancellation Process R e s e r v a t i o n D e t a i l s
Mapping ER Diagram for Reservation System Room M M Customer Payment M 1 Customer Banquet M M Customer Pool 1 M Customer Restaurant 1 M Customer Booking M 1 Customer Bar 1 M Customer
Room : room_ID , room_No, room_Date, reser vation_Date
Customer: cu st_ID, cust_name, cus t_address, cus t_tpno, cus t_email
Customer: cu st_ID, cust_name, cus t_address, cus t_tpno, cus t_email
Customer: cus t_ID, cust_name, cus t_address, cust_tpno, cust_email , pool_No
Customer: cus t_ID, cust_name, cus t_address, cust_tpno, cust_email , rest_ID Roomcustomer : room_ID, cu st_ID
Payment : Pay_ID, amount, d ate, cust_ID
Customer: cu st_ID, cust_name, cus t_address, cus t_tpno, cus t_email Customer: cu st_ID, cust_name, cus t_address, cus t_tpno, cus t_email
Banquet : banq_ ID, date_reser ved, time_start, time_end, time_served, function
BanquetCustomer : b anq_ID, cust_ID
Pool : pool_ No, descrip tion, p rice
Restaurant : rest_ID, food_ ID, descri ption, pric e, total_ Amount
Booking : booking_ID, date, cust_ID
Flow Charts
Start Startup Screen Main Screen Log In To the System Data Process Guest update Make room reservation T T T F F F Room Reservation Procedure Guest update Procedure Room selection Room selction ProcedureLog Off From the System
Stop Food order Report Selection T F F F F T Report Procedure Food order Procedure Bar order F Bar order Procedure T
Technology Used in the SOSM System
• The technologies that should be taken into consideration when implementing the
system are as
follows:- – Re-usability
Tools to be used in developing the system
• Graphic Editor Software
• Adobe Photoshop will be used as a graphic editor. Since it is not complex to work and it has more sophisticated features.
• Web Development Tool
• Macromedia Dreamweaver version 8 will be used for web development tool.
Development Language Requirements
• Familiarity
• Web Support
• Rapid Development
• Database Software
SQL Server 2000 and MS Access were
selected as the database software for this project out of the available software in the market.
• Operating System
– Windows is selected as the operating system software since it works well or run well PHP and VB.
• Programming Language
– PHP – Hypertext Pre-processor:-PHP is a server-side scripting language. Although it was originally designed to run under
Linux using the Apache Web server. – VB (Visual Basic) language for
Administrators perspective reservation system.
• Apache as the Web Server
The Apache Web Server, maintain by the
Apache Software foundation, is currently the most popular Web server because its
stability, efficiency, portability, security and small size and mainly it is Open Source.
Design
• Software Architecture,
• Input and Output Design, • Interface Design and
Menu and screen Form designs.
Login
User name
Pass word
Create a login by administrator for
administrator and user
Admin user Add Date Save Time User name Update Delete Pass word Main Exit
Guest Guest Id Last name Address Age Tel no Company
First name Mid init
Sex Nationality
Ok Cancel
Show all
Banquet reservation form
Banquet reservation Date reserved Client Address Contact no Time start Time served Function Time end Setup Backdrop Location Fax Engineering Meal type Description Price Quantity Amount Time end Cancel SaveThis form shows Room reservation
Room reservation
Checkout date Guest id
Room no Room type Room rate
Back Save
Show all
Reservation date Reservation no
Room and banquet confirmation
form design
Reservation no Date reserved Room no Reservation dateGuest ID Lengthof stay Status
view
confirmation date
view expire reservation
view confirmed Show all close Room Banquet
Web page designs
• Main web page description
Footer Client
Access
Description on particular links. Welcome part
Page Links
Links
• Further Information's About Srilanka Pool FeedbacksFoods and Beverages Our Services Banquet reservation Online Room reservation Rooms Video Clips Introduction
Manager’s link LINKS
Implementation
Implementation Plan
This plan describes how the developed system will be deployed. It contains an overview of the system,
• The system to be implemented is an Online Hotel Management for Hotel Reveira.
• It is a web-base and a Visual Basic developed to run on a PHP/MySQL/Apache server and in
Visual Basic.
• This is developed to assist the company in
providing a better reservation service to their manages,and to the Customers also.
Major task required for the implementation of the system
• Providing overall planning and co-ordination for the implementation. • Providing appropriate training for
personnel
• Ensuring that the user manual is available for the implementation effort
• Ensuring that all prerequisites are met.
• Performing data conversion before loading the data into the developed system.
Description of the implementation
• Firstly, the web server software (Apache) and database software (Mysql) are
checked if they are present, if unavailable, they are installed.
• PHP and VB software is deployed • The System developed is then
• Also instead of using above first three steps you can use the Xampp, which is consider a open source package that comes with the Apache server mysql database as a configured one.
• Import a Database backup.
• The system implemented is tested in the client PC’s.
Implementation of Database
• The database tables were successfully created using My SQL and MS Access. • All the tables mentioned were designed
and implemented appropriately with the appropriate fields and their data types.
Testing and Evaluation
• Component Testing
The program deals with database and some ActiveX controls and references some
runtime libraries therefore it was essential to test if they are properly referenced or not.
• installed Visual Basic 6.0 and Crystal Reports on the target test machine and run the
system. All of them were successfully running without any problems
Integration Testing
• This test was mainly carried out to see the links between a forms and reports in the system. There are a number of different forms and reports linked together. So it
was necessary to check the operability of the links found on the multiple document interface (MDI) form.
• This testing mainly focused to check whether links between the forms and
reports in the system work correctly. There are two kinds of test within this testing
– Test links from the MDI form to other forms: when the user clicks on the menu, it will call respective form.
– For example: when the user clicks on
