Title of the project:

Hotel Management SystemIntroduction:

This is a Project work undertaken in context of partial fulfillment of MCA. I have tried my best to make the complicated process of Online Hotel Management System as simple as possible using Structured & Modular technique & Menu oriented interface. It is a simple small system illustrated by using the most common features of Visual Basic.net. This project covers almost every aspect of the management system of a hotel. With this project it is the system that can manage the things easily with a less time.The basic language used in this project is Microsoft Visual Basic.net and the database of the whole project is created used Microsoft SQL Server 2008 Express Edition.Today, computerized processing of transaction data is an activity of almost any organization. In this generation, every bodys life becomes in computerized. They go ahead with the computer. The areas of computer applications are literally too numerous to mention. Computers have become an integral part of mans every day. They dominate every sphere of life be it entertainment, education, banking, insurance, medicine, design or manufacturing. Actually this generation is the era of rapid growth of Information Technology. IT has change the working process in all fields of human being. So they continue grow and the open new horizons of discovery and application. One of the primary reasons for the immense popularly of computers is the speed with which they can accomplish specific tasks. However computer applications are not always easy to use.

Objective of the Project:The major objective of the proposed computerized system is to overcome the drawback of the existing manual system to provide a paperless office environment. There is possibility of data entered incorrectly in the manual system and searching for old data can be a cumbersome process. There is always a chance of loss of data in the manual system which can lead the management into a lot of troubles. The other objective of this system includes providing an information sources, increasing efficiency, productivity and build greater user satisfaction and eliminating duplication of records. So one can found the required information quickly which will improve data processing. The proposed system is important for the store of data with minimum redundancy. It is also important for further use. This will maintain the data integrity. During the designing of the software my main objective will be make it a user friendly one.

Primary Objectives can be notified as listed below:

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 cant 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:

1. Room activities,

2. Admission of a New Customer,

3. Assign a room according to customers demand,

4. Checkout of a computer and releasing the room

5. Finally compute the bill etc.

6. Packages available.

This project has some more features:

a. No data duplicationb. No Paper Work Required

c. Time Efficient and Cost Efficient

d. Automatic data validation

e. User friendly environment

f. Data security and reliability

Project Category:Windows based application with Microsoft Visual Basic.net and RDMS package MS Sql Server.Tools to be used: Operating System: Windows 7

Platform: Microsoft Visual Studio with .net framework 4.0

Software Tools to be used:

Front End: Microsoft Visual Basic

Back End: MS SQL Server 2008 Express Edition

Hardware Tools to be used:

Processor: Intel Core2Duo HDD: 500GB

Display: 17 inch LCD Monitor

RAM: 2GB

Data Flow Diagram:

SHAPE \* MERGEFORMAT

SHAPE \* MERGEFORMAT

DATABASE DESIGNRoom

Sl. No.Field NameData TypeSizeKey

1.Roomno int4Primary

2. CapacityVarChar50

3.OccupiedVarChar50

4.RoomtypeVarChar50

5.Rate float8

6.Floor VarChar50

Facility

Sl. No.Field NameData TypeSizeKey

1.Srnoint4Primary

2.FacilityVarChar50

3.Ratefloat8

Service

Sl. No. Field NameData TypeSizeKey

1.Srnoint4Primary

2.ServiceVarChar50

3.Ratefloat8

Checkin

Sl. No.Field NameData TypeSizeKey

1.CustomeridVarChar30Primary

2.CustomernameVarChar50

3.AddressVarChar50

4.PhonenoVarChar20

5.GenderVarChar50

6. AgeVarChar50

7.CityVarChar50

8.StateVarChar50

9.OccupationVarChar50

10.PurposeofvistVarChar50

11.CustomertypeVarChar50

12.EmailVarchar50

13RoomInt

14CindateDatetime

15CoutdateDatetime

16IdproofVarChar20

17PhotoVarChar50

Booking

Sl. No.Field NameData TypeSizeKey

1.BookingIDVarChar 50Primary

2.CustomerIDVarChar50Foreign

3.Expectedarrivaldatedatetime8

4.BookingDaysint4

5.Roomtypenvarchar50

6.Roomnoallocated int4Foreign

7.Bookingdaysint4

8.NoofPersonsint4

9. BookedbyVarChar50

10. RemarksVarChar50

Check-Out

Sl. NoField NameData TypeSizeKey

1.BillnoVarChar50Primary

2.CheckInIdVarChar50Foreign

3.Roomchargefloat8

4.Servicechargefloat8

5.facilitychargefloat8

6. Otherchargefloat8

7.VATfloat8

8.Netamountfloat8

9.Advancepaidfloat8

10.Balancefloat8

11.RemarksVarChar50

Payment

Sl. NoField NameData TypeSizeKey

1.BillnoVarChar50Primary

2.PreviousBalancefloat8

3.Paidamountfloat8

4.PaymodeVarChar50

5.BankVarChar50

6.ChequenoVarChar50

7.Currentbalancefloat8

8.Pdatedatetime8

9.Ptimedatetime8

Future Application:Software development is never ending process and continues the life of the software as per the changing needs of the user from time to time. The project is no doubt has been developed keeping in mind easy modification and enhancement that may be required from time to time.

However, there are many scopes to modify this software. As because due to shortage of time, we here become unable to include many things. We are trying to cover all the existing system for customer record management and all official information details but due to shortage of time we become unable to include many things.

This project has many future applications like it can be used in any hotel.This project was build keeping in mind all the requirements of an educational institutes and it can be implemented in any such type of organization with very few modification. With modifications it can be possible use this system in a network. But incorporating all these features needs more time. It is not possible to develop such a huge extensive project within this limited time. So the project is designed in such a way that it can be modified in future easily. The tables are given in such a way to make understanding of the system easy.

Customer Detail

Bill Details

Checkin details

Fetch Data

Store Data

Enter details

admin

HOTEL MANAGEMENT SYSTEM

DATABASE

Customer

Bill Details

CheckIn

Bill

Context Diagram

Customer

VERIFY REQUEST 1.0

CUSTOMER_INFO

ROOM_INFO

SERVICE_INFO

REQUEST FOR ROOM

ROOM ALLOTMENT 2.0

BOOKING_INFO

BILL ESTIMATION 3.0

BOOKING_INFO

CHECKIN_INFO

BILL_INFO

PAYMENT RECEIVE

4.0

PAYMENT_INFO

CHECKOUT

PAYMENT_INFO

CHECKOUT

PAYMENT_INFO

BILL_INFO

CUSTOMER

STORE

REPORT GENERATION

REPORT GENERATION

REPORT GENERATION

1st Level DFD for the Proposed System

REPORT GENERATION

Customer

REQUEST FOR ROOM

CUSTOMER_INFO

SERVICE_INFO

VERIFY REQUEST

1.1

ROOM ALLOTMENT

1.2

ROOM_INFO

SERVICE_INFO

BILL ESTIMATION

2.1

BOOKING_INFO

CHECKIN_INFO

BILL PREPARATION

2.2

BILL_INFO

REPORT GENERATION

CUSTOMER

BILL

RECEIVE PAYMENT

3.1

PAY

PAYMENT_INFO

PAYMENT RECEIPT 3..2

REPORT GENERATION

RECEIPT

EXTERNAL

SOURCE

REPORT

CUSTOMER_INFO

ROOM_INFO

BILL_INFO

2nd Level DFD for the Proposed System