Life Hacks


      

Front Office of Hotel



INTRODUCTION

Cognition Front Office Management system is general purpose software that can be used at hospitality sectors like, hotels, motels, inns, resorts, Clubs, lodges, hostels, suites, Service Apartments etc.

It is a comprehensive software suite consisting of integrated modules for various aspects of hospitality management. The important modules Front Office Management System Includes Reservation (Billing), Reception . In our lodging software all modules are tightly integrated and all programs. Our Front Office Management System is developed for Microsoft Windows operating system.

There are various operations which are performed in the font office management. Theses are:-

Login

 

Reservation

 

In House Guest Messages

 

Settlements

Advances

Change Room Status, etc etc.

Project Description

Luxury hotels offer several types of rooms and a wide range of services to its guests – including routine room service and laundry services as well as specialized services such as a travel desk, business centre, rental of a laptop/mobile phone, etc. This system must allow the front-office to handle all these operations and must provide all necessary support to serve the guest, from the time he makes a reservation to the time he checks out.

OBJECTIVE

During the past several decades personnel function has been transformed from a relatively obscure record keeping staff to central and top level management function.There are many factors that have influenced this transformation like technological advances, professionalism, and general recognition of human beings as most important resources.

v 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.

v This project intends to introduce more user friendliness in the various activities such as record updation, maintenance, and searching.

v 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.

v Similarly, record maintenance and updation 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.

v 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.

v 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 customer’s demand,

4. Checkout of a computer and releasing the room

5. Finally compute the bill etc.

6. Packages available.

7. Advance online bookings.

8. Online Cancellation.

9. List of Regular customers.

10. Email facility.

11. Feedbacks

 

ER-DIAGRAM

clip_image002

TABLE DESIGN

Table : cust_details

Name

Varchar

Address

Varchar

Cust_id

Number

Mail_id

Number

Phone_no

Number

Table : room_detail

Room_no

Number

Room_cost

Number

Floor_no

Number

Room_type

Varchar

Ac or non ac room

Varchar

Table : bill

Date

Date

Bill no.

Number

Discount

Number

Subtotal

Number

Tax

Number

Total

Number

Table : duration

Field name

Data type

Check-in

Time /date

Check-out

Time /date

Table : extra charges

Field name

Data type

Restaurant charge

Number

Laundry charges

Number

Games charges

Number

Service charges

Number

Table : staff

Field name

Data type

Staff name

Varchar

Staff id

Number

Staff position

Number

Hotel Management system using SQL:

In SQL a database is used to manage hotels various tasks. It is obvious that we are using a database then we also have to use tables which consist of various columns and rows regarding the hotels data or record.

The main table can be considered as master table. The master table consist of quest information. Its columns may contain values like quest serial no, guest name, address, phone no, company, nationality etc.

Entries can be added, altered, updated and deleted using several SQL statements.

SQL COMMAND:

Create table cust_details(name varchar(20),address varchar(20),mail_id number(10),cust_id number(10),phone no number(10));

Create table room details(room_no number(10),room cost number(10),floor no. number(10),room type varchar(20));

Create table bil_payment(bill no number(20),date date time(10),discount number(20),subtotal number(20),tax number(20),total number(20));

Create table duration(check-in datetime(10),check-out datetime(10));

Create table extra charges(restaurant charges number(20),laundry charges number(20),games charges number(20),service charges number(20));

Create table staff_details(staff_name varchar(10), staff_id number(20),staff_position number(20));

Scope of Future Application

This project can be used in the hotel after adding some more useful modules in the project for which large luxury 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.

Scope of Improvement

Now a days large luxury 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.

CONCLUSION

This project is designed to meet the requirements of large luxury hotel Management. For interface we can use any language like html, JavaScript,php, asp etc. For designing the system we have used simple data flow diagrams.

Overall the project teaches us the essential skills like:

· Using system analysis and design techniques like data flow diagram in designing the system.

· Understanding the database handling and query processing.

Leave a Reply