Hotel Managament System

(1)

Title of the

Project

(2)



Introduction

Grand continental is the leading hotel of my city. It has provided best facility to our customer. It has number of permanent and many temporary customers. It has number of deluxe, AC, NON-A/C rooms and suites. Hotel is situated in heart of the city area called civil lines. It has number of employees, which provide own service to hotel.

Hotel has restaurant facilities for all customers. Here a banquet hall, baradari, and bar are also for customer. In banquet and baradari have large no of choice showing in menu card. In menu card veg, nonveg, fast food, snack, sweet dishes, ice cream’s, cold drinks and hot drinks.

When customer comes to the hotel for lodging purpose first he/they go to the reception counter where he/they gives information about him/themselves. Reception manager gives information about rooms and its charge’s then customer choose room with its need. Reception manager takes advance deposit for room rent, allotted room and give key to customer. One room service man go with the customer for showing the room.

(3)

The main objectives behind the development of this project are as follows: 1. To make entry of rooms with detail.

2. To make entry of vehicle. 3. To make entry of foods. 4. To allot room to customers.

5. To make enquiry of room availability. 6. To make enquiry of customer.

7. To book vehicle.

(4)



Input to the

project

In this project fallowing inputs are

given:- It provide output about food

 It provide output about room

 It provide output abut customer

 It provide output about reserved room

 It provide output about staff

 It provide output about fair of Room & food

 It provide output about hotel

(5)



Output to the

Project

In this project fallowing inputs are

given:- It provide output about food

 It provide output about room

 It provide output abut customer

 It provide output about reserved room

 It provide output about staff

 It provide output about fair of Room

 It provide output about hotel

 It provides the information about available room & food

(6)



Project Category

“RDBMS PROJECT”

The project is application software that satisfies the application area of hotel. The project comes under RDBMS category. The project handles the huge data in hostel subjected to customers their rooms, food and rent and other charges. The RDBMS is capable of creating storage, keeping date, manipulating data and retrieving data in desired manner.



Tools/Language to

(7)

a) Front End:

Microsoft Visual Basic 6.0

b) Back End :

(8)



Hardware and

Software Requirement

i) Hardware

Requirement:-1 PC at least Pentium II (recommended) 128 MB RAM (recommended)

20 GB Hard Disk (recommended) 1 Printer and

Other related peripherals.

ii) Software

Requirement:-Operating System : Windows XP Database : SQL Server 2000 Language : Visual Basic 6.0

(9)



Visual Basic 6.0 –

A brief note about the Front End

Visual Basic’s user interface programming is all about responding to events and user actions. The users’ actions drive the event response in the application. Based on the event response, you can choose the code in your application that is appropriate to respond to the event. In this scenario, the users’ actions initiate an event in your application. This is called event driven programming because the code that is executed is driven by the event that happens to your program.

In formal sense, an event is an action recognized by a form or control in your application. Forms and controls are the basic elements in the user interface of any Windows application. In Visual Basic these elements are called objects. Objects have properties and methods, Objects have methods too, which are the actions they can carry out like hide, load, unload etc.

Visual Basic provides a wealth of tools for creating and accessing databases on both individual machines and networks. The major tools are:

 The Data Control

 The Data Access object



SQL Server 2000 –

(10)

SQL Server, a Relational Database Management System (RDBMS), works to efficiently manage its resource, a database of information, among the multiple clients requesting and sending data in the network. SQL has many important features that make it not only an exceptional database management system but also an excellent database server choice for client/server database computing. Here are some of these features:

Supports all major operating systems for both clients and servers, including MS-DOS, NETWARE, WINDOWS, NT MATCH OS/2 and most flavors of Unix.

It has client/server features developers can use to minimize the network traffic between client and server. Therefore, application based on SQL Server can deliver the performance that users require to the productive in their jobs.

It maintains database security using a system of access controls. This simply means that at an administrator's discretion, the administrator create registered database user and then grants them the privileges to perform specific database operation and use specific data.



Data Flow

(11)

“0” LEVEL DFD

Request for Food

HOTEL

USER _MANAGEMHOTEL

EN SYSTEM DISP ROOM DISP VEHICLE DISP FOOD Vehicle Enquiry Room Detail Vehicle Detail Food report Request for Room

(12)

Check

Food

Details

CUSTOMER REJECTED FOOD Customer Info REQUEST PROCESSING Access Update Customer Info

Check

Veg-Food

Details

FOOD REPORT

Check

Non- VegFood

Details

Check

Desert-Food

Details

Food Info Food Info Food Info

Veg-Food Info Non-Veg Food Info Desert-Food Info

FOOD FOOD Access Access Access Processing Information

(13)

‘1’ LEVEL DFD FOR ROOM REQUEST

Check

Room

Details

CUSTOMER REJECTED ROOM Room Inquiry ROOM DETAILS Access Update Room Info

Check

AC-Room

Details

AC Room REPORT

Check

Non- AC Room

Details

Check

General Room

Details

Room Info Room Info Room Info

AC Room Info Non-AC Room Info General Room Info

ROOM ROOM Access Access Access Room Information Non AC Room REPORT General Room REPORT

(14)



E-R Diagram

F_name F_type F_a_date F_Status EMPLOYEE HOTEL ROOM CUSTOMER FOOD BED Work Visit Provide

AC ROOM NON-AC ROOM

GENERAL ROOM Is a Is a Is a Order Book E_add E_elibility E_post E_contact E_salary E_name #E_ID #H_id H_name H_contact h_city Recome R_no R_rent Amt Cd_date Place Period NOP C_name #C_id #F_id Room_no Floor_no Bed_charge Bed_type #Bed_no R_envi _{R_style} R_type #R_id R_date R_charge R_status

(15)



Database Design

TABLES

The Proposed System include following table:

1) food_menu 2) h_room 3) h_booking 4) h_Employee 5) Bed 6) Login 7) Hotel

(16)

2) Table – h_room

Field Name Data Type Key Description

f_id int Primary Key Primary Key

f_name VarChar - Name of food

f_type VarChar - Food type

f_charge float - Food cost

F_a_date Date/time - Entry date

status int - Status of availability

Field Name Data Type Key Description

r_id int Primary Key Primary Key

r_type VarChar - Room type

r_env VarChar - Room environment

r_bstyle VarChar - Bed style

r_charge int - charge

r_date Date/time - Entry date

(17)

3) Table – h_booking

C_id int Primary Key Primary Key

C_name VarChar - Customer name

C_add VarChar - Customer address

Nop int - Number of people

placecome VarChar - Place from

rcome VarChar - reason

Priod int - Stay period

r_no int - Room number

r_rent int - Room rent

Amt int - Amount deposited

cd_date Date/time - Coming date cd_time Date/time - Coming time gd_date Date/time - Going date gd_time Date/time - Going time

v_id int - Vehicle id

v_b_date Date/time - Vehicle date

v_nod int - Vehicle number of days

V_charge int - Vehicle charge

f_charge int - Food charge

r_charge int - Room charge

t_charge int - Tea charge

(18)

4) Table – Login

5) Table- Bed

6) Table-Employee

User_name Varchar Primary Key It store username User_pwd Varchar - It store password

Bed_no Number Primary Key It store bed number Room_no Number - It store room number Floor_no Number - It store floor number Bed_type Number - It store bed type Bed_charge Number - It store Bed charge

E_id Number Primary Key It store the employee id E_name Varchar - It store name of employee E_add Varchar - It store address of Employee E_ Elilibility Varchar - It store employee Elibility E_post Varchar - It store employee post E_contact Number It store contact number E_salary Number It store Salary of employee

(19)

7) Table-Hotel

H_id Number Primary Key It store the employee id H_name Varchar - It store name of hotel H_address Varchar - It store address of hotel H_contact Number - It store contact no of hotel H_city Varchar - It store city of hotel

(20)



Process Logic

Login process can be performed in following manner:

 User Activates the software package

 Login Form pops up

 User makes the required entries and submits

 The submitted data is tested by VALIDATION module.

 If(all correct entries )returned (

(

 Open the Login table in database  Check for username and password If (found )returned

( (

 Current form is closed

 Main Menu form is displayed as by default is the next step I the software

Else-Otherwise

 Error message for in correct entry is displayed  The software prompts for new user name entry )

(21)

else-otherwise

 Error message for is displayed for incomplete submission of form

 Software prompts for re submission of data )

)

Add new room

To fill the form in following manner:

 User goes of Add_New_Room option in main form

(

 Open the H-ROOM table in database  Enter data in the database

 Update database else-otherwise

)

(22)

 User goes of Add_New_Food option in main form

(

 Open the H-FOOD table in database  Enter data in the database

)

Add new vehicle

 User goes of Add_New_Vehilce option in main form

(23)

(

 Open the H-VEHILCE table in database  Enter data in the database

)

New customer Entry

 User goes of Add_New_Customer option in main form

(

 Open the H-ROOM and H_BOOKING table in database  Enter data in the database

(24)

)

Billing

 User goes of BILL option in main form

(

 Open the H_BOOKING table in database  Enter data in the database

 Update database Else-otherwise

(25)



Report Generation

The proposed system generates the following report…

1) Report of available rooms

2) Report of allotted rooms

3) Report of food available

4) Report customer

(26)



Limitation of the

System

Though the software presents a broad range of options to its users some intricate options could not be covered into it; partly because of logistic and partly due to lack of sophistication. Paucity of time is also major constraint, thus it is not possible to make the software full proof and dynamic. Lack of time also compelled me to ignore some part such as storing old result of the candidate etc.

The limitations of the project…

The system has not facility for staff management.

The system does not provide accounting facility to restaurant.

The System can not be used for all types of hotel; it can be used to satisfy the requirement of a specific hotel only.

(27)



Future Scope of

the Project

There are many additional features, which can be planned to be incorporated during the future enhancements of this project.

The Future version of System can handle the accounting in hotel.

The Future version can be improved to provide functionality of working as in a general purpose hotel too.