Online Hotel Management System

This is a presentation of Online Hotel Management System.

1. Welcome to our presentation Topic: Online Hotel Management System Dhaka International University (DIU) Batch: E-56 The rolls of our group: 21, 30, 38, 41, 52

2. INTRODUCTION The theme of our project is Hotel Management System. The main aim of this project gives customer view of hotel. This system is made in such a way that a minimum educated and simple computer knowledge person can use this system without any option of error. There are basically two types of user who can use this system. One is online users who are the customers who can see the hotel updates and can book rooms and second one is administrator who is responsible for updating the hotel details on system.

3. EXISTING SYSTEM The existed system is in that hotel is manual working. Using this many problems can occur, for this system they used some bill books. That time any customer came for inquiry or reservation they need to check every reservation in the book, that is surly time wasting process. Also the man who is searching also important, sometimes he may do some problems in the process. Some drawbacks of this existed system are: Manual record keeping is not consistent as some errors can creep in while writing manually. It is difficult to keep record of room availability and large number of customers. More labor and time is required in this current system. Managing room availability in order is bit difficult, so it’s not possible for executive to search the particular room. Collecting payment is difficult. Inaccuracy of records. No central database can be created. So the information is not available in database. More funds and paper is wasted to keep the manual record of available rooms and customers.

4. Scope There are several motivations to order new computer-based Hotel Management System: The proposed system will remove the hectic task of customers and executive for searching and booking rooms in hotel. The system will help the administrative staff i.e. executive of the hotel to keep the daily and the history record details of the customers in proper Database. Will generate proper reports for customers at the time of check-out. Every novice user can easily interact with the system. The HMS will allow remote access to hotel database only for customer after the authorization procedures. The customer could search, book rooms and give feedback.

5. Objectives To provide a fully functional automated Hotel Management System that will be an offline system but some work can be done online also. To provide a complete organizational and reliable system with least possibility of any errors. To taking the feedback from the customer so that the hotel can be proved to be useful for their customers. Customer can easily register at any point of time sitting in their homes and login for their purpose. To view the information regarding room’s availability, executive should login with their unique ID. A central database has been designed which will help in removing the issues/flaws Associated with the existing manual system and also will keep the records safely.

6. Proposed Solution The aim of this project is to develop a system that can handle and manage the activities involved in a hotel in an efficient and reliable way. It will help the executive to do their work in simple way without any trouble. Following are the proposed solutions that are listed below as: 1.Computerizing the system: The basic problem of existing system was that the system was not computerized. In the newly made system we have removed this problem and we are providing a fully automated system in which the users will be having lots of advantages. Better management of data. Highly accessible for customers. No funds or money is wasted in paper works. we have not to use so much man power because it is a web-based application where all the data goes directly to database and we can retrieve data according to our choice.

7. Security All details will be available at one click To avoid chaos in registration of a new customer can directly get their login details on to their e-mail id. 2. 24*7 accessible: The computerized system will accessible from anywhere and at any time. So the customers can reach the system very easily . 3. Records of available rooms and customer report: The customer’s and room’s details will be managed through the computerized based system thus making it highly reliable for the hotel. 4. Collection of payment: Payment will be collected from online while booking rooms, but if some due is there then it can be collected either by cash or card at the time of check-out of customer and also invoice is provided. 5. Proper controlling system: Executive can view each and every report of the customers just by going through the system which will save in the database. 6.Centralized database: The computer database maintains customers and rooms records which will be highly beneficial for the executive. If executive updates any particular field it would notify at other places that is fetched through a centralized server only. This will add to the reliability and access of the data.

8. Selection of Methodology The method being used in developing the system is the System Development Life Cycle (SDLC). SDLC: Software Development Life Cycle is a process used by software industry to design, develop and test high quality software. The SDLC aims to produce a high quality software that meets or exceeds customer expectations, reaches completion within times and cost estimate.

9. Planning: It is the very first phase of the system, in which we decide what the task is for and what all things we have to do for completion of the project in an easier and healthy way. Analysis: It is second and also considered as an important phase of the life cycle model. In this phase, the existing system is studied by collecting the information through the Internet and analyzed the information to get alternatives for the use of proposed system. Design: This is where the details on how the system will work are produced. Architecture, including hardware and software, communication are all part of the deliverable of a design phase. Implementation: This is the longest phase of the software development life cycle. The code is produced from the deliverable of the design phase during implementation. Testing: During testing of the system, the implementation code is tested to make sure that the product is actually solving the needs addressed and gathering the other information. Unit testing and system testing are done during this phase.

10. Work Break Down Structure (WBS)

11. Data Flow Diagram (DFD)

12. Entity Relationship Diagram There are basically 4 things which we consider while making ER Diagram. ENTITY: An entity is something, real or abstract, about which we store information. For our system there are basically these three entities: 1. Admin 2. Executive 3. Customer RELATIONSHIP: A relationship is an association that exists among entities. For our system we have following relationships among 3 specified entities: One Admin can register many Executive (0:N) One Admin can add many Rooms (0:N) One Admin can view many Reports of Executive, Customer & Rooms (0:N) One Admin can delete many Executive (0:N) One Admin can edit information of many Executive (0:N)

13. One Executive can check payment of Customer(1:N) One Executive can view many Reports of Rooms (1:N) One Executive can edit information of many booked Rooms (1:N) One Customer can search many rooms (2:N) One Customer can book many rooms (2:N) ATTRIBUTES: Attributes is a property of an entity or a relationship type. For our system we have following attributes of 3 specified entities: Customer: - Id of Customer, Name of Customer, Room Type, No. of Room booked, Check-in date, Check-out date and payment Admin/Executive/Customer: - Username and password. Room: - Room no, Room type, No of rooms, room status, room price.

14. Entity Life History Diagram

15. Customer ID Name Room Type No. of Room booked Check-out date Payment Username Password Executive User name Password Admin Username Password Room Room No Room type No of rooms room status room price Register N 1 Manage N 1 Manage Booking 1 N 1 N ER Diagram

16. Interactive Screen Design

17. Have you any question