INTRODUCTION Hotel Management System is an extensive-ranging software suite comprehends of unified modules of various featured hotel management. Hotel hospitality software has all the powerful & accomplished features required to control your hotel, motel, guest house, and property rent business. Hotel management system presents an operational integration of reservations, bookings, checkin, checkout, guest history, reception/ front desk, Sales Ledger, Accounting and Reporting modules. Hotel Reservation software is a system composed to simplify the booking & checkin process and allow you to organize & standardize your hotel business. You can analyze the new & standard trends of booking, reservation, checkin & checkout operations and work towards your forthcoming business requirements. Managing replication of customer records and record their comments on hospitality and make your customers feel unique and special by recording personal notes. Make food allergy notes, record special events and birth dates. Hotel & motel Reservation software is a software composed to manage daily booking or check-in, checkouts of guesthouse or hotel rooms. Hotel Management System uses a MS Access database on backend database. Reservations can be assigned to user defined rooms or sweets. Main Features: Customize
Hotel rooms with features & prices. Save the client's information into the database before the Booking or Checkin for any future use. Booking for the customer for specified date with pre or advanced payment insertions. Check-in for the specified duration & room will appear engaged for that duration. Checkout operation can be occurred after complete payment insertion. Operational Advantages: Every single instance you make a reservation, the room status is modified and the customer details are added to your hotel database. Use the once entered records for life time for the repeated customers. Better option for expensive CRM. Hotel Management System has the features required to control your hotel, motel, guest house, and property rent business. It has integrated into it the features of. HM Software includes, Hotel Management System, Hotel Booking Software (Billing System), Hotel Reception & Front desk Software and Hotel accounting software. Operations integrated include reservations, bookings, check-in, checkout, guest history, reception/ front desk, Sales Ledger, Accounting and Reporting modules. You can avoid duplication of 1
customer records. For each customer you can record his preferences as to the room and food & beverages, any allergies or special dates meaningful to him. Keep track of these notes and you have the opportunity to present your customers a memorable experience easily. A MS Access database holds all the important data centrally. As far as day to day management is concerned you get a comprehensive view of reservations, check-ins and checkouts. When checking-in guests can be given their preferred rooms, which they had indicated on some earlier visit. On every instance of a booking the room status is updated and customer details get added to the database. The database records will help you manage customer relationships quite well rather than obtaining an expensive CRM solution. The system is built to seamlessly integrate Reservations, Front Desk, food management, POS`s and booking system to enhance performance greatly from increased efficiency, improved client relations and streamlined operations. 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 tooperate 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)
2
OBJECTIVE During the past several decades personnel function has been transformed from arelatively obscure record keeping staff to central and top level management function. There are many factors that have influenced this transformation like technologicaladvances, professionalism, and general recognition of human beings as most important resources. A computer based management system is designed to handle all the primary information required to calculate monthly statements. Separate database is maintained to handle all the details required for the correct statement calculation and generation. This project intends to introduce more user friendliness in the various activities such as record updating, maintenance, and searching. The searching of record has been made quite simple as all the details of the customer can be obtained by simply keying in the identification of that customer. Similarly, record maintenance and updating can also be accomplished by using the identification of the customer with all the details being automatically generated. These details are also being promptly automatically updated in the master file thus keeping the record absolutely up-to-date. The entire information has maintained in the database or Files and whoever wants to retrieve can¶t retrieve, only authorization user can retrieve the necessary information which can be easily be accessible from the file. The main objective of the entire activity is to automate the process of day to day activities of Hotel like: Room activities, Admission of a New Customer, Assign a room according to customer¶s demand, Checkout of a computer and releasing the room Finally compute the bill etc.
3
Packages available. Advance online bookings. Online Cancellation. List of Regular customers. Email facility. Feedbacks
This project have some more features: System Connectivity No data duplication No Paper Work Required Time Efficient Cost
Efficient
Automatic data validation User friendly environment Data security and reliability Fast data insertion & retrieval
Easy performance check
4
FEATURES
Handling Customer Details-: Reservations
Cancellations
Handling Rooms Details
Making Payments
Features like Update, Searching, Deleting, EditingRecord etc.
Generating different kinds of report.
Customers can view videos of hotel rooms with audio explanations.
Customers Make reservations, enquiries and cancellations via online.
Hotel Reservation System is well equipped to cater to a numerous properties with
innumerable rooms.
5
Its enhanced features will transform your website into a completely serviceable
and secure Online Reservation System with systematic reporting and sales analysis. OHRS can be integrated into an existing or a new web site. OHRS is highly user friendly and you can grasp it the first time with no prior
software knowledge.
MODULES Reservation module Front Desk module Cashier and Night Auditor module Room Management module Accounts Receivable module
6
IMPLEMENTATION Implementation Plan This plan describes how the developedsystem will be deployed. It contains anoverview of the system. 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.
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 Ensuringthat
all
prerequisites
are
met.
Performing data conversion before loadingthe 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 implemented
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.
7
USES Hotel Management System is an extensive-ranging software suite comprehends of unified modules of various featured hotel management. Hotel hospitality software has all the powerful & accomplished features required to control your hotel, motel, guest house, and property rent business. Hotel management system presents an operational integration of reservations, bookings, check-in, checkout, guest history, reception/ front desk, Sales Ledger, Accounting and Reporting modules. Hotel Reservation software is a system composed to simplify the booking & check-in process and allow you to organize & standardize your hotel business. You can analyze the new & standard trends of booking, reservation, check-in & checkout operations and work towards your forthcoming business requirements. Managing replication of customer records and record their comments on hospitality and make your customers feel unique and special by recording personal notes. Make food allergy notes, record special events and birth dates. Hotel & motel Reservation software is a software composed to manage daily booking or check-ins, checkouts of guesthouse or hotel rooms. Hotel Management System uses a MS Access database on backend database. Reservations can be assigned to user defined rooms or sweets. Main Features: Customize Hotel rooms with features & prices. Save the client's information into the database before the Booking or Check-in for any future use. Booking for the customer for specified date with pre or advanced payment insertions. Check-in for the specified duration & room will appear engaged for that duration. Checkout operation can be occurred after complete payment insertion. Operational Advantages: Every single instance you make a reservation, the room status is modified and the customer details are added to your hotel database. Use the once entered records for life time for the repeated customers. Better option for expensive CRM.
8
ADVANTAGES AND DISADVANTAGES ADVANTAGES This project is useful for the authorities which keep track of all the users registered in a particular state .The authority can add hotel packages, room details, availability of rooms, online booking etc.The following steps that give the detailed information of the need of proposed system are: Performance: During past several decades, the records are supposed to be manually handled for all activities. The manual handling of the record is time consuming and highly prone to error. To improve the performance of the Hotel Management System, the computerized system is to be undertaken. This project is fully computerized and user friendly even that any of the members can see the report and status of the company. Efficiency: The basic need of this website is efficiency. The website should be efficient so that whenever a new user submits his/her details the website is updated automatically. This record will be useful for other users instantly.
Control: The complete control of the project is under the hands of authorized person who has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator and the other members have the rights to just see the records not to change any transaction or entry. Security: Security is the main criteria for the proposed system. Since illegal access may corrupt the database. So security has to be given in this project.
DISADVANTAGE It takes more time to reserve the room. Soperformance of the current system is
slow. Now the current system is running manually. So they are facing problems. Difficult to handle data accurately and securely because of the data lost, viewing
by unauthorized people, can¶t collect the data at the time.
9
IMPROVEMENTS This project can be used in the hotel after adding some more useful modules in the project for which hotel are providing services. Utmost care and back-up procedures must be established to ensure 100% successful implementation of the computerized hotel system. In case of system failure, the organization should be in a position to process the transaction with another organization or if the worst comes to the worst, it should be in a position to complete it manually. Now a day¶s hotel are providing many other facilities, this project can also be improved with the improvement in the Hotels. Utmost care and back-up procedures must be established to ensure 100% successful implementation of the computerized banking system. In case of system failure, the organization should be in a position to process the transaction with another organization or if the worst comes to the worst, it should be in a position to complete it manually. Improvements shall be made to add features like: Mobile Reservations Virtual Reality Adding ERP and BPR
10
ENTITY RELATIONSHIP DIAGRAM (ERD)
Entity ± Relationship Diagram:
This depicts relationship between data objects. The attribute of each data objects noted in the entity- relationship diagram can be described using a data object description. Data flow diagram serves two purposes: To provide an indication of how data are transformed as they move through the system. To depict the functions that transformation the data flow. Data Objects:
A data object is a representation of almost any composite information that must be understood by the software. By composite information, we mean something that has a number of different properties or attributes. A data object encapsulates data only there is no reference within a data object to operations that act on the data. Attributes:
Attributes define the properties of a data object and take on one of three different characteristics. They can be used to: Name an instance of data object. Describe the instance. Make reference to another instance in other table. Relationships:
Data objects are connected to one another in a variety of different ways. We can define a set of object relationship pairs that define the relevant relationships.
11
E-R DIAGRAM
HOTEL
CUSTOMER
Room information
Check -in Room
Hotel
Customer
Customer
Room record
Checkout
Bill generation
Room
Hotel
12
CONTEXT LEVEL DFDHOTEL MANAGEMENT SYSTEM
ROOM ROOM
CUSTOMER
HOTEL
MANAGEMENT SYSTEM
CUSTOMER CHECKOUT
PRINT DEVICE
13
0
LEVEL DATA FLOW DIAGR AM
14
1
LEVEL DATA FLOW DIAGR AM
15
ROOM R ESERVATION FORM
16
BANQUET RESERVATION FORM
17
SOFTWAR E R EQUIR EMENT Adobe Photoshop will be used as a graphiceditor. Since it is not complex to work and it has more sophisticated features.
Tools to be used in developing the system G
raphic Editor Software
Web Development Tool Macromedia Dreamweaver version 8 will beused for web development tool.
Operating System Windows is selected as the operating system software since it works well or run well PHP and VB.
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.
18
R EFER ENCES http://www.resortdata.com/RDPWin/Screens/IRMNet/IRMNetScreens.htm http://www.scribd.com/doc/19244137/Online-Hotel-Management-System www.ignoujugaad.com www.itwebblade.com J AVA
Programming E.Balagurusamy
JAVA Projects Tony Martin,Dominic Selly JAVA Professional Projects KuljitKaur,PoojaBembey MY SQL The Complete Reference George Koch
19
20