Mid Term [PDF]

Zitiervorschau

Balkumari College TRIBHUVAN UNIVERSITY INSTITUTE OF SCIENCE AND TECHNOLOGY Picture of Balkumari college

Mid- Term Project Report (Seventh Semester) Base Information of Team Dhiraj Dhakal

(11704/073)

Sujan Subedi

(11723/073)

AnilThapa Magar

(11715/073)

puran Thapa

(11708/073)

Title (Preliminary): “Hotel Management for Customer Services”

Start Date: 27/10/2076 End Date: Project Work type:

Submitted to Lumbini ICT Campus Department of Computer Science and Information Technology Gaindakot-2, Nawalparasi

“Hotel Management for Customer Services” A Major Project Report submitted in partial fulfillment of the requirements for the degree of Bachelor of Science in Computer Science and Information Technology awarded by Tribhuvan University.

Submitted by: Pooja Dhakal

(073/1704)\

Pratima Thapa

(073/1708)

Sangita Thapa

(073/1715)

Vanessa Subedi

(073/1723)

ABSTRACT Hotel management is useful software for managing the hotel online. In todays world, online booking is very wide trend. With the help of this software customer can book online rooms as they require. This software which is mainly made for the customer service has been designed with front-end asp.net and backend as C#. This project manages and maintain the record of customers and rooms of the hotel.

Customers can book the room through this software. The room has different categories such as single, double, deluxe with different amenities. So, their charge and record will be maintained by this software. This software made in a user-friendly interface so everyone can understand and use easily. Through this project administration can manage their programs in a effective way.

Table of Contents CHAPTER ONE: INTRODUCTION........................................................................................2 1.1 Background...................................................................................................................... 2 1.2. Aims:...............................................................................................................................3 1.3. Objectives........................................................................................................................3 1.4. Questionnaires.................................................................................................................3 CHAPTER TWO: METHODOLOGY...................................................................................... 4 Phase I:...............................................................................................................................5 Phase II:..............................................................................................................................5 Phase III:............................................................................................................................ 5 Phase IV:............................................................................................................................ 5 CHAPTER THREE: STRUCTURE OF THE PROJECT......................................................... 6 CHAPTER FOUR: SYSTEM DESIGN.................................................................................... 8 CHAPTER FIVE: RISK FACTOR AND ITS MITIGATING STRATEGY..........................15 3.1. Introduction:..................................................................................................................15 CHAPTER SIX: TIME FRAMEWORK................................................................................. 22 6.1. Project Gantt Chart........................................................................................................26 EXPECTED OUTPUT.............................................................................................................27 References:...............................................................................................................................28

1

CHAPTER ONE: INTRODUCTION 1.1 Background Many hotels in Nepal is using the manual system for the reservation. When the guest makes a reservation all the reservation including the guest details are recorded in a file and those files are stored in cabinet. As the current system is based on file, and management of the hotel has put much effort on securing those file. They can easily damage by a fire, insects and natural disaster. Keeping files takes much time and wastes a precious man hours. If we want to check for previous room record and reservation details then management will be in great problem. It’s a tough and time taking process to search for record in a file. In this Era of technology, not having a computerized system, not only wastes time but also burdens the clients of the organization unnecessarily. By using an on-line hotel reservation system. Hotel reservation system has been implement will be covering all the basic process of reservation for the customer services and designed to simplify the task of on-line booking and to enable hotel businesses to compete in today’s demanding and competitive market. The system provides the customers and clients a unique, innovative and easy to use interface that improves the way people use the web today. Online users can compare prices and facilities of the different room and packages. Online hotel reservations systems are becoming a very popular method for booking hotel rooms. Travelers can bookrooms from home by using an online security to protect their privacy and finance information. We provide online food services to the room. We even provide the services of currency transfer so that every customer pays equally. We provide mailing system so that customer will be updated every time about new services or any offers and even about their count points they get each time they book room. When the customer reaches the certain points they will get some extra service according to the hotels. All above information and details are stored in the system database it will save time while retrieving data from database. Interfaces will be designed user friendly and the function will be display in simple manner. The web page we are going to developed will give remedies for the problems that are currently facing by our client. Shifting to our web can acquire advantages such as saving of time, man hours, and space wastage. This will increase the efficiency in hotel reservation system. This website helps the normal user to get the information about our hotel reservation as well as different services and facilities.

2

1.2. Aims: The aims of our system is to provide a user-friendly interface for customers for easy booking process. It saves a lot of time and effort for customers as they can conveniently book hotel rooms from their homes. It is for the customer services. It is mainly used for the development of hotel and customer services.

1.3. Objectives •

Objectives of this project is develop a hotel information with online reservation and billing system.

•

To develop a system that will generate reports and to create the backup files of successful transaction.

•

To notify the customer about their bookings and to improve customer care and services at the hotel.

•

To save client user time.

•

To provide money conversion.

1.4. Questionnaires •

What information are required to provide in order to list your accommodation on the Booking Websites?

•

How do you provide this information to the Booking Websites?

•

How does it help the foreigner to transfer the currency?

•

How it provided the notification to verify the notification?

•

How does the currency will be exchange for the foreign?

3

CHAPTER TWO: METHODOLOGY Since, every project has its own aims and objectives that need to be fulfilled which motivated and lead us to fulfill our aim of carrying out the project. For achieving the goals, we use the mixed qualitative and quantitative method. For our minor project, lots of work has to be done regarding the web pages. Webpage are an important part of the any organization because it is the main source to view the information of the hotel for the customer service. Since it is been using the manual process for the reservation which is not effective for any organization to achieve the goal for the smooth development of the hotel based on customer service by realizing that websites for hotel. So, we try to develop it as a part of our minor project. For this we will perform, a review from which we will generate the ideas. •

How the best websites should be look like i.e. Outlook?

•

What sort of user should we focus?

•

What are the content that should be in the webpage?

Moreover, the reviews will help in finding the contents that are necessary for the web pages. After the successful completion of reviewing the webpage we perform the interview. There are different type of interview but we follow the semi-structured interview because this type of interview helps the interviewee to share their ideas and provide us guidance about the basic and important content of the websites and enhancing the web range of the information. So, secondary we perform this interview in order to gather data and information for the webpage. These information or data will be collected from review and by interviewing staff, possible user, and the public people for the informative, attractive and user friendly web pages.

The identified data and information will then be analyzed by the project coordinator in order to bring the required and important data and information. The methodology we have mention is better on as it help in finding the data and information required for website. We divide the project into four phase. Each phase produce specific operation that will be used for analysis and conclusion. Each phase is described below along the specific operation produced by it.

4

Phase I: In this phase, relevant data and information about webpage will be collected by reviewing the existing web-page. As well as we viewed other webpages to gain the basic information for our webpages.

Phase II: This phase is two folded: •

First to validate the finding of reviews or we can say the validate the finding of phaseI. And determining the importance of those review of the websites.

•

Secondly to identify additional information that are missed in phase-I. For this we will conduct interview with the organization staff and possible user of webpage.

This phase provides the project team the detail idea how the websites will be and what content are essential for the websites.

Phase III: This is the main phase where we analyze the finding of the phase-I and phase-II. Here, team members and team coordinator will actively act on chosen the required information for the web-page.

Phase IV: In this phase all the information that has been gathered required for the web-page will be implemented in real application. Then the team co-ordinate along with project team will decide the tools for developing the web-page scripting language to make the page dynamic. Here we decide to use Bootstrap to develop the dynamic webpage for the customer services. Table 1: Summary of methodology Phase Methodology Phase-I

Review

Phase-II

Semi-structured interview

Phase-III

Gathering and analyzing the requirement

Phase-IV

Determining tools and scripting language to make page dynamic

5

CHAPTER THREE: STRUCTURE OF THE PROJECT Software engineering is an engineering discipline that is concerned with all aspects of software production from the early stages of system specification through to maintaining the system after it has gone into use. Software engineering is the discipline whose aim are: a. Production of quality software b. Software that is delivered on time c. Cost within the budget d. Satisfies all requirements

A software process model is an abstract representation of a software process. Each process model (sometimes called process paradigms) represents a process from a particular perspective, and thus provides only partial information about that process. These generic software process models are not definitive descriptions of software processes. Rather, they are abstractions of the process that can be used to explain different approaches to software development. The process models are: a. The waterfall model b. Incremental development c. Component-based software engineering In the project, we followed Incremental development model.

6

Fig.3.1. Incremental development model Incremental development has three important benefits compared to the waterfall model: • • •

The cost of accommodating changing customer requirements is reduced It is easier to get customer feedback on the development work that has been done. More rapid delivery and deployment of useful software to the customer is possible, even if all of the functionality has not been included.

Some other advantages are: •

Results are obtained early and periodically.

•

Parallel development can be planned.

•

Progress can be measured.

•

Risks are identified and resolved during iteration; and each iteration is an easily managed milestone.

Disadvantages: • It is difficult to map requirements directly to different increments. •

An overhead in the model is rapid context switching between various activities.

•

Each iteration is followed by an evaluation ensuring that user requirements have been met. This evaluation after each iteration is time consuming.

7

CHAPTER FOUR: SYSTEM DESIGN In this phase the software’s overall structures are defined. In terms of client server, technology the number of tiers needed for the package architecture, database design, data structure design etc. are defined in this phase. The following are the essential approach taken during web portal designing: •

DFD

•

Database designing



Context Diagram

8

Guests

Guest

External Reservation System

guest Booking request Booking Confirmation

Booking confirmation

Booking request

Book Room booking

Rooms Rooms

Bookings

Payment validation

Payment validation request

Current Time

Time/ Schedule

Bank

Fig.3.2: Context Diagram

9



Flowchart: Page Sign up

Sign In

Login

No Rooms

No

Is Roo m

Yes Select Room

Payment Option

Cash

Other

Card Payment

Card Number

Invalid

No

V al

yes Vali

Payment Success

Room Booked

Fig.3.3: Flowchart

10

o Zero Level DFD Diagram:

Customer Management Booking Management

Hotel Management

Hotel Room Booking System Room category Management

Login Management

Fig.3.4: Zero Level DFD

11

System User Management

o 1 Level DFD Diagram:

Hotel Management

Generate

Hotel

Report Room Management

Generate

Booking Management

Generate

Customer Management

Room

Report

Booking

Report

Hotel Room Booking System

Login Management

Generate Customer Report Check user Login details Generate

User Report

System user Management

Fig.3.5: First Level DFD

12

System

o 2 Level DFD Diagram

Admin

Login to

Check

Manage Hotel Details

Hotel System

Roles of Access

Manage Room Facility Details

Forget Password

Manage Customer Details Check credentials Manage Payment Details Manage Module

Manage Room Category Details

Send Email to User Manage Booking Details Manage System Admin

Manage Role of User

Manageuser Permission

Fig.3.6: Second Level DFD

13

Manage Report



ER Diagram:

BOOKINGINFO

RESORTINFO

ROOMINFO

BOOKINGID

RESORTID

ROOMID

ROOMID

LOCATIONNAME

RESORTID

LOCATIONNAME

RESORTIMAGE

ROOMTYPE

USERID

NOOFROOMS

NOOFBED

MEMBERTYPE

NOOFROOMSAVAILABLE

TELEPHONE

ROOMCHARGES

RESTAURANT

ROOMCHARGES

BFROM

SWIMMINGPOOL

LOCATIONID

BTO

SPA

BOOKINGSTATUS

LOCATIONID

LOCATIONID

N

N

INVITES

ACCOMODATION N

LOCATIONID

SNO IFROM

LOCATIONNAME

ITO

LOCATIONIMAGE

STATUS

LOCATIONDESC

LOCATIONID

N

N

FEEDBACK

USERPROFILE

LOGIN

FID

REGID

USERID

USERID

USERID

PASSWORD

FEEDBACK

FIRSTNAME

AUTHOR

DATESUBMITTED

LASTNAME

LOCATIONID

EMAIL ADDRESS CONTACTNO

Fig3.6: ER Diagram

14

N

LOCATIONID

N

CHAPTER FIVE: RISK FACTOR AND ITS MITIGATING STRATEGY 3.1. Introduction: During leading our project completion, we may go through various risk factor which we describing below as well as we make some strategy to avoid these risks. Some of them are:

•

[Risk1] A low rate that is too low: When a reservation is done through the online some time due to the fake website online booking agency and my manager refused the reservation. [Strategy 1] They get confirmation notification from the hotel after the reservation.

•

[Risk 2] A lack of amenities: A discount by booking hotels online often discover upon arrival they aren't eligible for certain amenities — free parking, for example, or any parking at all. Trip Advisor is rife with posts from travelers who have sticker shock from unexpected charges for parking or are furious they have to park half a mile away from the hotel. If you book a hotel online, call to find out its policies on parking and other amenities ahead of time. [Strategy 2] All the information are in the websites of the hotel reservation are true.

•

[Risk 3] This might lack the active participation of the team members which leads the project towards Failure. Since, we will be usable to meet the milestone. [Strategy 3] Should enhance the active participation of all the team members to reach the milestone in actual time limit.

•

Up and Down of currency: As the currency value is changeable so that sometime value of currency increases and decreases. During the decreases value of currency, the both buyer and seller have to face loss.

15

DESIGN SCREENSHOT HOME PAGE

16

17

LOGIN PAGE

18

ROOM DETAILS:

19

20

BOOKING FORM:

21

ADMIN HOME-PAGE

22

23

24

25

CHAPTER SIX: TIME FRAMEWORK 6.1. Project Gantt Chart A Gantt Chart is one of the most popular and useful ways of showing tasks (activities or events)

displayed against time. The Gantt chart of our project is given below: Table 2: Gantt chart

26

EXPECTED OUTPUT After the completion of our project, we have expected the web-page of our hotel will be more responsive, contains all the requirements and user friendly. We can have the all the required information about the hotel reservation and details about the reservation or booked offered by the hotel which can be the guideline for career development for new hotel management system. We are also expecting to enhance and promote the hotel by providing information about the facilities and events organized by the hotel. Customer can make advance booking using this system. User friendly and attractive interface for the user. Hotel Manager can add information about their hotel. Security for pre-booking of hotel rooms. Customer can view information about extra hotel facilities.

27

References: [1] e. a. Ahmad T., 2012. [2] J. F. a. K. A. Jiqin Yang, "online hotel reservation system," 2005. [3] Stuart, "International Reservation System," UK, 1995. [4]http://www.liacs.nl/assests/Bachelor Scripties/2006-08 Glincher .pdf [5]D.Wardell,”online hotel reservation” 2012.

28

29