Hotel-Management-System

Minor Project on Hotel Management System. Developed in Java and MySQL Database or JDBC API used for backend.

Introduction

In today’s era computers have become a vital component of any enterprise for giving it proper directions and extensive control of the various activities to attain business objectives. Computer applications have affected scientific & commercial knowledge.

The information system of the old times totally differs from the todays. It is automation system of a hotel management or any information system. In the previous ages the process of maintaining data and record seemed very difficult. Now days, computer is very essential component. The implementation of computer based Information system can be depicted as the ease in handling and maintaining the data bank of any size.

Our project is on Hotel Management System which deals with almost all the functionalities of a Hotel. It keeps the database of customer records and other hotel relater records like, rooms, driver, etc. It also keeps the employees list, room charges and other services list.

The business of Hotels is spread all over the world. A large record should be maintained in a proper manner for running of hotels. The proposed system is a window based menu driven system. It reduces the paper works, time needed for doing various tasks etc. Our project upholds the accuracy of data.   Project Objective:- The main objective of this work is to reduce the difficulties that are found in the present system. The present system requires a lot of paper works, manual works etc. The accuracy is less in the present system. The details must have to be stored manually in the present system.

In the present system, the details of all particular hotel admins are stored hotel related data in different registers by different persons this to data isolation and inconsistency.

There is always an objective behind every innovation and behind every work. We did have many objectives for our project which are described as follows

• To search records of rooms, customers, employees etc. efficiently. • Processing a large amount of data effectively and efficiently. • To provide better service. • It keeps database of employees details, rooms price and Customers record. • In such a huge project where the amount of data to handle was tremendous, there was strong demand for greater accuracy and consistency. • Since the system is subjected to be accessed by number users, the system must safe guard sensitive and important data in a form that is accessible only to the authorized person. • Input validation features to make sure that only correct information has been provided. • It is easiest way to maintain data of all records. • It can generate knowledge about hotel system.

It helps to keep the entire information of the hotel in a systematic way so that it becomes easier to know about the employees, customers and other services of hotel.   Software and Hardware Specification

Hardware Requirements:

1. System: INTEL Core i3 Processor
2. Hard Disk Space: 1024 GB
3. RAM: 8 GB
4. Hardware Devices: Monitor, Keyboard, Mouse, etc.

Software Requirements:

1. Operating System: Window 7/8/10/11
2. Front-End Tool: Core Java
3. Editor: Intellij Idea
4. Back-End Tool: DBMS using MySQL, JDBC   CFD (Contract for difference)

  DFD 0’ LEVEL (Data flow Diagram)

DFD 1’ LEVEL (Data flow Diagram)

 Login details

 

 Reception Handle

 

 Customer Details

 

 Rooms Details

 

 Employee details

 

E-R Diagram

DBMS Structure

 Structure of Admin Login Details S. No Field Name Datatype Size Constraints

1. User Name Varchar 50 Not Null
2. User ID Varchar 50 Primary Key
3. Password Varchar 20 Not Null

 Structure of Customer’s Details

S. No Field Name Datatype Size Constraints

1. ID Card Varchar 100 Not Null
2. ID Number Varchar 100 Primary Key
3. Name Varchar 200 Not Null
4. Gender Varchar 50 Not Null
5. Country Varchar 100 Not Null
6. Room No Varchar 100 Not Null
7. Check In Time Varchar 200 Not Null
8. Deposit varchar 100 Not Null

 Structure of Room Details S. No Field name Datatype Size Constraints

1. Room Number Varchar 25 Primary Key
2. Availability Varchar 20 Not Null
3. Cleaning Status Varchar 30 Not Null
4. Bed Type Varchar 35 Not Null
5. Price varchIntroduction

In today’s era computers have become a vital component of any enterprise for giving it proper directions and extensive control of the various activities to attain business objectives. Computer applications have affected scientific & commercial knowledge.

The information system of the old times totally differs from the todays. It is automation system of a hotel management or any information system. In the previous ages the process of maintaining data and record seemed very difficult. Now days, computer is very essential component. The implementation of computer based Information system can be depicted as the ease in handling and maintaining the data bank of any size.

Our project is on Hotel Management System which deals with almost all the functionalities of a Hotel. It keeps the database of customer records and other hotel relater records like, rooms, driver, etc. It also keeps the employees list, room charges and other services list.

The business of Hotels is spread all over the world. A large record should be maintained in a proper manner for running of hotels. The proposed system is a window based menu driven system. It reduces the paper works, time needed for doing various tasks etc. Our project upholds the accuracy of data.   Project Objective:- The main objective of this work is to reduce the difficulties that are found in the present system. The present system requires a lot of paper works, manual works etc. The accuracy is less in the present system. The details must have to be stored manually in the present system.

In the present system, the details of all particular hotel admins are stored hotel related data in different registers by different persons this to data isolation and inconsistency.

There is always an objective behind every innovation and behind every work. We did have many objectives for our project which are described as follows

• To search records of rooms, customers, employees etc. efficiently. • Processing a large amount of data effectively and efficiently. • To provide better service. • It keeps database of employees details, rooms price and Customers record. • In such a huge project where the amount of data to handle was tremendous, there was strong demand for greater accuracy and consistency. • Since the system is subjected to be accessed by number users, the system must safe guard sensitive and important data in a form that is accessible only to the authorized person. • Input validation features to make sure that only correct information has been provided. • It is easiest way to maintain data of all records. • It can generate knowledge about hotel system.

It helps to keep the entire information of the hotel in a systematic way so that it becomes easier to know about the employees, customers and other services of hotel.   Software and Hardware Specification

Hardware Requirements:

1. System: INTEL Core i3 Processor
2. Hard Disk Space: 1024 GB
3. RAM: 8 GB
4. Hardware Devices: Monitor, Keyboard, Mouse, etc.

Software Requirements:

1. Operating System: Window 7/8/10/11
2. Front-End Tool: Core Java
3. Editor: Intellij Idea
4. Back-End Tool: DBMS using MySQL, JDBC   CFD (Contract for difference)

  DFD 0’ LEVEL (Data flow Diagram)

DFD 1’ LEVEL (Data flow Diagram)

 Login details

 

 Reception Handle

 

 Customer Details

 

 Rooms Details

 

 Employee details

 

E-R Diagram

DBMS Structure

 Structure of Admin Login Details S. No Field Name Datatype Size Constraints

1. User Name Varchar 50 Not Null
2. User ID Varchar 50 Primary Key
3. Password Varchar 20 Not Null

 Structure of Customer’s Details

S. No Field Name Datatype Size Constraints

1. ID Card Varchar 100 Not Null
2. ID Number Varchar 100 Primary Key
3. Name Varchar 200 Not Null
4. Gender Varchar 50 Not Null
5. Country Varchar 100 Not Null
6. Room No Varchar 100 Not Null
7. Check In Time Varchar 200 Not Null
8. Deposit varchar 100 Not Null

 Structure of Room Details S. No Field name Datatype Size Constraints

1. Room Number Varchar 25 Primary Key
2. Availability Varchar 20 Not Null
3. Cleaning Status Varchar 30 Not Null
4. Bed Type Varchar 35 Not Null
5. Price varchar 30 Not Null

 Structure of Employees Details S. No Field name Datatype Size Constraints

1. Name Varchar 30 Not Null
2. Aadhar Number Varchar 20 Primary Key
3. Age Varchar 20 Not Null
4. Gender Varchar 25 Not Null
5. Job Role Varchar 30 Not Null
6. Salary Varchar 10 Not Null
7. Phone Number Varchar 15 Not Null
8. Email ID varchar 40 Not Null

• Structure of Drivers Details S.No Field name Datatype Size Constraints

1. Name Varchar 30 Not Null
2. Age Varchar 10 Not null
3. Gender Varchar 15 Not null
4. Car Brand Name Varchar 30 Not null
5. Car Model Varchar 30 Not null
6. Phone Number Varchar 15 Not null
7. Licence Number Varchar 25 Primary Key ar 30 Not Null

 Structure of Employees Details S. No Field name Datatype Size Constraints

1. Name Varchar 30 Not Null
2. Aadhar Number Varchar 20 Primary Key
3. Age Varchar 20 Not Null
4. Gender Varchar 25 Not Null
5. Job Role Varchar 30 Not Null
6. Salary Varchar 10 Not Null
7. Phone Number Varchar 15 Not Null
8. Email ID varchar 40 Not Null

• Structure of Drivers Details S.No Field name Datatype Size Constraints

1. Name Varchar 30 Not Null
2. Age Varchar 10 Not null
3. Gender Varchar 15 Not null
4. Car Brand Name Varchar 30 Not null
5. Car Model Varchar 30 Not null
6. Phone Number Varchar 15 Not null
7. Licence Number Varchar 25 Primary Key

Limitations of Projects • This is a desktop application only run in computer or laptop. • This application is not for booking hotel online. • Only Hotel’s Admin can work on this application because this is designed or developed for admin use only. • No central database can be created as information is not present in database.  Future Application of the Project

The different areas where we can use this application are:  Any hotel administration can make use of it for providing information about rooms, customers, employees, managers and drivers.  Modification can be easily done according to requirements as and when necessary.  For the admin dashboard, you will be able to all the basic access in the whole system. Such as employees details, rooms details, customers details, drivers details and other details.  The admin has access to the hotel management information system. It add, update, and delete the employees, customers, rooms, drivers and other information.  By default one of the security features of this system is the secure login and logout system.

This software can be easily Implemented under various situations. Any hotel can make use of it for their administration work like add new customer, new room, new employee, new driver etc. It can be used in any type of HOTEL for managing all the employee, Customers and other information which is related to the particular hotel.

Bibliography • Google for problem solving • Mr. Neeraj Gupta Sir guides