Hotel Room Booking System Project

Abstract

Resme.com is an online travel agency website designed using ASP.NET and Microsoft SQL Server Management Studio. Resme.com is an online platform that helps the user reserve the hotel room of his/her choice online.

This website facilitates the end user to view the hotel and hotel rooms based on the various categories and sorting preferences they select. It also lets the users register to the website so that his/her individual profile can be maintained. He/she can access and modify his/her profile by signing in. New users are given sign up option.

The user account maintains the personal details of the customer, both billing and room preference of the customer. Also, the reservation he/she has made can be viewed in the profile module. The user can cancel reservation prior to cancelation date of particular motel.

If the user is business owner, than he/she can add business to the Resme.com and manage business profile so customer can view services provided by them. Also, hotel owner can add and update business information along with amenities provided and picture of service. Price can be managed by the hotel owner based on their business models and services provided by them.

The system admin can add and manage the configurations of the website. She/he can add and modify the products, offers and manufacturers related to all the products. She/he can also create users for the system and assign them access rights based on the requirements and their job duty. System admin can also view various reports to fulfill certain job duty and reports help them to take decision and make business plans.

INTRODUCTION

Business Concept

With the ever expanding use of the internet and online travel booking sites for vacation planning, opportunities may exist for niche travel reservation offerings in the Online Travel Agency industry.  Resme.com is a new start-up company looking to capitalize on these opportunities by offering an online travel reservation service, specialized in Hotel room reservation services.  The company plans to offer hotel accommodation product distribution for many types of hotel properties, from small independent hotels to five star luxury residences worldwide.

Resme.com intends to offer an efficient, informative, and user-friendly website for leisure travelers to book reservations for their Resme.com holiday vacations.  Travelers will be able to easily make accommodation reservations, for a vast range of hotel rooms, condos, and vacation home properties worldwide, at very competitive rates.  The service will also provide a more competitive distribution channel for hotels and resorts to make their accommodation products available to a targeted customer base. With the help of a strong customer service, Resme.com will greatly simplify the process of finding the most suitable accommodations for this more specialized traveler group, while providing hotels and other accommodation suppliers with a more cost effective distribution channel for their product.

Problem Background

The current manual reservation system uses paper and direct human interaction to book the hotel room and manage reservations. This makes delays exchanging of information in the hotel.

Reservation is done via phone calls or by visit in person to the hotel reservation office. The guest’s personal details such as Name, gender, Age and Duration of visit or stay, are entered during booking made. Then the booking officer asks to prepare room for guest before his/ her check in date. The data and documents are transferred manually to the appropriate office for compilation of the guest’s file. On the day of check in date the file is transferred to the reception. On the day of checking in the guest is given the key to his room, she/ he also specify if room service is needed.

The Front desk hands over the customers file to the account department where guest pays for accommodation and other fee. The customers file is updated on daily basis of his expenditure costs. The financial department generates the bills on and delivered to the customer in their rooms. The guest pays at the accounts department.

A day before their check out day, their expenditure are generated. The guests receive their expenditure at the accounts office as they check out, where they pay for remaining balance if any.

After analyzed various traditional hotel room booking system, we had noticed the below problems in their system.

•  Manual system for storing records is not consistent as some inaccuracy can creep in while writing records manually.
• Guest or visitors may face hard time to getting place to stay in area.
• It is difficult to store record of availability of room and huge number of customer’s records.
• More manpower is required and the current system consumes too much time to making reservation and storing data.
• Maintaining of up to date availability of inventory is bit difficult, thus, it is making hard for executive to search the particular records and room.
• Payment processing and collection is difficult.
• Inaccurate of records or data.
• There is no centralized database can be created as information not at one place.
• More money and paper and other resources are wasted to store the record of available rooms and customers.

THE STRUCTURE MANUAL SYSTEM

ADVANTAGES OF THE MANUAL SYSTEM

1. Employee with the no computer skill or any special skill is required.
2. No need to rely on any device to access or use data.
3. Human interaction is required to create booking, thus one can better identify customer.

DISADVANTAGES OF THE MANUAL SYSTEM

1. There is maximum possibility of losing customers record and files or mix up customer’s record.
2. As we are not sure and we can to re use past records, unwanted duplication of information and data is possible.
3. As the actual file is available, there are chances that one can use the files and information whiteout permission or right.
4. Maintaining file security and standard is difficult
5. As very easy access to guest information by unintended users, guest information is extremely unconfident.
6. Reusing or retrieves of guest records is extremely difficult.
7. Human are required to fill forms and enter data, manual data entry leas to errors.

Proposed Solution

Main aim of designing this project is to design a system that can manage and handle the activities that are involved in a hotel reservation in an organized, cost-effective and reliable way. It will help the administrative to do their work in very simple manner without causing any trouble and Visitors or customer to reserve their room according to needs before they come to hotel. Customer can use any electronic device like laptop, computers, smart phones or tablet etc to book and confirm their stay with motel. Based on the limitation and shortcomings identified in the existing Hotel Room reservation system, the solutions have been provided for the better management to the organization and ease of access to the customer.

The proposed solution will have ability to manage customer’s account where they can save their preferences and personal information. Customer will have many options to compare rates and services based on their requirement. Efficient searching, sorting and filtering offered to the customer.  Traveler or any other customer can book and secure their place to stay before or without actually visiting the hotel. Executives and business owner can easily manage the inventory and rates of their hotel rooms. With the new system business owner are capable to market their product on resme.com and also they can create some packages and deals based to offer to the customer. The proposed system will be able to handle payment and transactions.

Here is the basic flow of Resme.com service:

As per the above diagram, we can conclude that resme.com will offer various products like airline ticket, Hotel room reservation, holiday package etc. to the user to be compared and book based on their requirements. User can use the Resme.com website, call us or contact sub agents to use service and to create booking or for any other help. With the help of various algorithms, proposed system will provide wide range of option to user line booking facility, hotel room search engine, online payment processing etc.

Below are solutions of the proposed system that are listed below as:

S. No.	SOLUTIONS	DESCRIPTION
1	Computerizing the system	The core drawback of existing system was that the system was not computer based. In the proposed system we have overcome this problem and we are providing a fully automated system with the reach functionality as below:    Efficient data management and reusability.  Highly accessible for users.  No resource like time or money and papers is wasted in paper works neither we have to use so much human resources though it is a web-based application, all the data stores to database and we can retrieve data based on requirements. Security of User information and other can maintain. On a figure tip, we can access any information with proper authority. Customer can create and manage their account to save preferences, personal information and payment information.
2	24*7 accessible	The proposed system will available and function 24*7 and accessible for worldwide. Thus, the customers can use the system very easily.
3	Records of available rooms and customer report	Computer based system will be used to manage guest and hotel information thus, the information is highly reliable for to the hotel.
4	Collection of Payment	This system provides two ways for payment: 1. Customer can pay online and system will take care of payment processing. 2. Customer is allowed to pay at hotel and hotel will be responsible for payment.
5	Proper controlling system	Executive can view many report of the customer, inventory, reservation, collected payments and many more through the system which will helps him to take decision and make strategy.
6	Centralized Database	The core advantage of this system is computer will used to manage and store data in database which will be highly beneficial for the administrative. If any changes to particular data or field would notify at other places and data is accessed by a centralized server only. This will add to the reliability and access of the data.

The Designing of this system has following activities, which help to automate the entire reservation process keeping in the view of database integration approach.

• This system maintains user’s personal detail such as name, address, room preferences, payment information and contact details.
• With the help of reach user interface, user can easily navigate and use the new system to reserve or searching of rooms.
• This system makes the overall reservation system and reservation management much easier and flexible than before.
• Various classes are used to maintain the user details of inventory.
• Security is maintained with various way including username, password must be needed to login in to user account.  Various rights can be assigning to the employee based on their roles to limit the access.
• Report generation feature is provided user to generate different kind of reports based on their needs.
• This system has reach user interface and support multi devices and easy to access for all types of user.
• This system is providing accessibility control to data with respect to users.
• This system has online payment processing option.
• This system needs adopts and implements verity of algorithms and techniques to maintain integrity and confidentiality of users and their data.
• New system is able to handle more users at same time and should be capable to handle millions of user at a time.
• Verity of automation task including sending email to groups, sending email and fax to customer and hotel owners and sending SMS and email of promotions to the users.

Purpose

The purpose of this project is to create a functional website for users to reserve the hotel room across the world. Users of this website will be able use an easy to use interface in order to search, sort, reserve room and services across the world. Create an account option will secure their data and allow easy access to various services and facilities. One of the main purposes of this project is to allow customer to have online booking of room and other services with registered business partner. The basic requirements state that the users will be able to search for room based on and able to make instant online payment. They will also be able to navigate through available other options by category, or by using a well executed search function. The website will be maintained and managed by administrator. They will have the authority to manage the products and offers.

Scope

This system is aimed at developing an online application for hotel reservation. This system can be used by end users (Customer and Hotelier) and administrator to perform extensible tasks, to reserve and sale hotel room in an easy and secure manner. The following facilities have been implemented by us:

• Secure registration and profile management facilities for customers.
• Adequate searching mechanisms for easy and quick access to particular products and services.
• Reserving the product and payment.

In addition to the above mentioned basic functional requirements for the project, Resme.com has made the following supplementary requirements as well. We have created web pages navigation so that the customers can search for rooms and reserve or save to their account to reserve it later. A sorting mechanism for products in each category such as: by city, by pin code, by location, by state, by country, most viewed, price from low to high, and high to low, based on rating. Module for a feedback mechanism for the products from the customers has also been implemented.

Objective

The Hotel industry like any other business opens up socioeconomic opportunities for both owner and customer. It has the function of providing hospitality services to customers. These customers can be travelers, foreigners, businessmen, tourists, visitors, etc. Customers are mostly constrained in trying to get a room to pass the night, as the usual practice is to look for a hotel when you have arrived in the particular location, walk in and find out whether there is a vacant room. In the case that there is no vacant room, you have to move to next closest hotel to enquire once more. So what happens if you move around sometimes very late in the night in search of a room and all close by hotels are fully booked? Other times you may be lucky to have the contact number of the hotel to reach them to book for a room. But do the hotel attendants really ensure to keep a room for you? You would be lucky to go and get a room booked for you. They are quick to serve those who walk in rather than those who may get access to them on phone to book a room. On other times too, if you have friends or family members in the area you want a room booked, they have to go and do the checking for you. There is no system in place that bonds the hotel and the customer that the customer has actually booked a room and for that matter he is guaranteed a room. This can make customers really stranded especially if it is getting late in the night.

Main objective of the online travel agency System is to maintain the robustness of the system and also the safety of customers and administrators, the following in the project is ensured:

• Overall system quality should be good and it should be a smooth experience for both customers and administrators.
• The system should be easy to maintain and navigate. Object oriented programming techniques are used in the project.
• Customer’s details are secured in the profile module.
• The security checks are done as and when it is necessary.
• The system will remain up at all times. The hardware and software should be robust and will be tested extensively.

Technology and Literature Review

Microsoft Visual Studio 2010 was used throughout for developing different data-entry forms, data-viewing pages and reports. ASP.NET 4.0 is used as a front end tool for creating the web pages required in the system, C# language is used as code behind and SQL server 2008 is used as a back end tool for the sake of data manipulation and stored procedures. Bootstrap framework is used to get CSS classes for good designing purposes. Web services will be used to use to share data among the application. Unit testing, Integration Testing and all other required testing is perform to validate user input and check the security of the web site.

Abbreviations

The documentation includes explanation of following abbreviations used in project:

• OS:   Operating System
• SRS:   Software Requirement Specification
• RAM:   Random Access Memory
• SQL:   Structured Query Language
• Credential:  Combination of username and Password issued to user for login
• AJAX :  Asynchronous JavaScript and XML
• CSS:   Cascading Style Sheets

User Modules

The system after careful analysis has been identified to be presented with the following modules:

1. Authentication and Security Module
2. Administrative Module
3. Employee/Support Module.
4. Hotel and Rooms Management Module.
5. Service and Amenities Management Module.
6. Reports Module.
7. User module.

Authentication and Security Module

The main aim of this module is to maintain confidentiality, authenticity and integrity of stored information. In this module user information should be verified with the user information stored in the database tables and if it is information matches, they should be able to access system. Once entered in the account or system, based on the user type and access rights they can use system functionality.

Administrative Module

This module has the following sub modules:

Users Management Module

In this module main administrative member can access any user information and if required, he can add or delete a user. With this module, they can assign rights; revoke rights and control for individual user of group of users to limit their access to the website. This module helps to maintain the security of data by limiting the access based on the requirements.

Reports

This module will mainly used to generate various reports for analysis and making new strategy for developing and growing the business and providing a better service to the user.

Other

At this time almost all the system functionality is accessible by the administrative user for various purposes.

Employee/Support Module

This module has functionality for employee. Employee can send email to the group of motel owners, customer administrative user or any other user. This module allow access of motel/hotel information with some privileges and customer information like their reservation history, payment, due payments, upcoming reservations. In short this module is more for the routine used module which manage data and bridge between customer, hotel owner and company.

Hotel and Rooms Management Module

 

This module will mostly used by the hotel owner to add and manage their property. They can add as many as they want property in their account and also they can add, edit and maintain their room inventory and prices of their motels, policies, content. This module is reach in functions which allow user to set pricing various ways like range or day by day and also it allows creating and posting great value deals and offers for the customer. This is one of the main user modules which will come with huge number of reports. Reports are design in the way that covers majority of searching requirements that are needed in order to make business strategy and take further decisions.

Service Module

It consists of the following sub modules:

Hotel room search Service Module

These modules facilitate user with variety searching criteria to search for their motel rooms. Easy to navigate while searching, auto suggestions for search and many more features provided by this module. This module also helps to search and manage packages and special deals for the customers.

This module also comes with the My Account facility where guest can create their personal account or linked account with their family members and friends. In My Account user can save his/her personal preferences for hotel type of hotel, liked hotel, quick reservation etc. Payment information, previous reservation, upcoming reservation, password change can also be managed in user account. User can control email notification or other notification from his/her account.

This module also facilitates the review management, where user can write review for their past stay, can manage review for the hotel they stayed or the service he/she used. This module also allows user to contact resme.com team by contact us link or file complaints if any or they can contact for any other help.

 

Review and rating Module

Now a day’s, whenever its come to buy any product or services, review plays an important role and helps to take decision. Review helps and encourage people to improve their service and also show the complete view of how the business is serving to its customer. Here, this module comes up with the facility to write or read reviews and experience of the guest or previous customer who used the service before. They can write what they likes and what the where and how the service provider can improve. Any customer who reserved the room and stay at hotel can write the review and let the world know whether the expected service are provided or not. This module is one of the most useful to determine the service provided by the business owner.

Reports Module

A report helps to determine business stage and state. Based on the reports one can build, rebuild the business. This is one the main and large module of the system. This module has ability to print hundreds of reports based on the demand to see how the business, how many reservations is so far, how many active hotels available, commission payable and much more. Reports are generated based on requirement, timely manner and many more criteria.

User Module

This is one the mostly used and important module of the system. This module will provide service to the customer where they can book their room; also they can make the group reservation. This module also comes up with some sorting feature that allow user to filter result based on their choice and the data or result populate to the web page is completely dynamic and based on the user criteria. User or the customer can also register or create their profile from this module.  They can also some shortcuts of our service like contact us, top destination, city guide, attraction near area etc.

PROJECT MANAGEMENT

Project Management is an important part of project development. It deals with all the important areas for project development like Feasibility, Requirement analysis, Project Schedule, Project Plan etc. It was achieved by proper selection of Software Life Cycle Model.

Feasibility Study

An imperative result of preparatory examination is the assurance that the framework is achievable. Feasibility study aim to objectively and rationally uncover the strengths and weaknesses of the exiting project, opportunities and dangers as displayed by the earth, the assets required to help through, and eventually the prospects for progress.

Technical Feasibility

To develop this project, .NET Technology was used, which has many features worldwide to develop any type of web application. So technically it only takes web development technology to make this product. So it is feasible to make it and no major risk to make the product as it has worldwide support. Team Foundation Server is used during the implementation of this project.

Operational Feasibility

It shows how well the system solves the queries raised by the user. So, the system needs the proper management support i.e. the database must be well designed, efficient, normalized and have less redundancy.

Implementation Feasibility

For implementing this project, Microsoft Visual Studio 2010 is used throughout the development. ASP.NET 4.5 Framework is used as front end tool for creating the web pages, C# language for coding and SQL Server 2008 as a back end.

Project Scheduling

The System is developed using the ITERATIVE WATERFALL. This approach has the following development phases:

• Feasibility study
• Requirement analysis and specification
• Design
• Coding
• Unit, integration and system testing
• Maintenance

Online Travel Agency System is developed in four phases which includes analysis, design, coding and testing. The requirements may be fuzzy or it can be changed by the user which enforces us to choose a model that allows us to move back to the previous phase of the development life cycle. Thus it can be achieved using iterative waterfall model.

Figure 2.1 Iterative Waterfall Model

We have identified that we have approximately 3 years of development time in order to apply the Evolutionary prototyping model most effectively we have decided to carry out certain iterations. We have plan and divided that the iterations will last approximately eight weeks, this will give us an overall flexibility of four weeks allowing us to adapt to yet unforeseen problems that may occur during the project. The iteration will be started with a clear list of target requirements for the iteration. And will be concluded with a review of the iteration and an evaluation of its success against the initial requirements. As the planned iteration we are hoping to design the full fledge working website that fulfill all the business requirements.

Requirements analysis and specification Stage

This stage of SDLC involves research and analyzes the customer and business requirements for the project to develop. Also it involves specification and formal list of need and requirements for the project. It will involve research through internet, meeting several people, looking at several previous projects implementation to establish the key aspects of functionality that we wish to incorporate into our own project.

Analysis and Design Stage

After the requirements stage is complete the requirements will be analyzed and an initial design will be created. I n the early stages of the project the design will be rather flexible concentrating mainly on the simulation aspects of the project development. Later on we anticipate that design will become more detailed as iteration 1 is completed and giving us a stable framework for the extension to visualization in iteration 2.

Implementation Stage

Implementation is the stage where the physical design of the program is translated into code. Each specification developed during the last stage will be implemented into the overall program structure. I f any problems with the design are discovered the project will return to the design stage and create a revised design. The process will then continue checking that each of the previously implemented features can be satisfied within the new design framework

Testing Stage

During the testing stage each function implem ented in the implementation stage is checked against its specification to ensure that it performs the correct action. More detailed testing will also be carried out details of the testing procedures can be found our project Test plan.

Evaluation Stage

This stage will be used to examine whether the prototype that has been developed fulfils all the requirements of the project. I f the prototype doesn’t fulfil these requirements the process will continue with a further iteration. I f the prototype fulfils all the requirements then it will stop the cycle of iteration and continue onto the next stage. The evaluation stage also gives us the opportunity to gauge the progress over the past iteration to determine the amount of time taken and to adjust the time schedule accordingly. Also the evaluation process will also allow us to assess how well the iteration was executed and to identify any key areas of improvement.

Deployment Stage

Deployment is the process in which the program has reached completion and is ready for deployment into its prospective environment. Deployment will also involve the creation of a project review that will look at each aspect of the project determining how successful each part was and to suggest improvem ents for the future.

Project Plan

Effective management of a software project depends on thoroughly planning the progress of the project. A well planned strategy leads to the best and optimal use of available resources and hence project planning with proper scheduling also ensures completion of the project on time.

In the development of this project, first it is to be checked if the project is feasible functionally, technically and economically. Then the requirements from the end user have to be gathered and analyzed. Then after thoroughly understanding all the requirements from end user, the Graphical user interface (GUI) is developed.

After this, comes the coding part which involves handling database and creates forms. There are certain coding standards to be followed so that the flow of program is easily understood.

Testing will ensure that our system works efficiently under all valid inputs and does not give any errors. Testing is performed using various test cases. To test the system we need to perform unit testing, module testing and finally the system testing.

Table 2-1 Schedule of Project

ACTIVITY	START DATE	COMPLETION DATE
1.Analysis and Study of the system
2.Requirement Gathering
3.System Design
4.Database Creation
5.Coding
6.Testing & Documentation

SYSTEM REQUIREMENT STUDY

User Characteristics

Analyzing user characteristics is an important aspect of any project. It allows us to clearly define and focus on who the end users are for the project. Also, it allows us to check the progress of the project to ensure that we are still developing the system for the end users.

The end users for system are:

Administrator:

Administrator will manage entire system and behavior of the system. He has rights to access almost all the rights to access the system.

End User:

End user of the system will be Travelers, Businessman or any other person who willing to book hotel room and also business partner will be consider as end user as they will use this system to sell their service and products.

The users must have following characteristics:

• The user must have basic knowledge about Computer or any smart device.
• User should be comfortable in starting and stopping Web Based Applications.

Hardware and Software Requirements

Hardware Requirements

• Processor: Intel i3
• Disk space: 160 GB
• Memory: 8 GB
• Internet Connection

Software Requirements

• Windows 7 or Windows or higher versions of OS
• Any Latest Web Browser. (Preferably, Mozilla Firefox, Google chrome)
• For Server, IIS 7 or greater with .NET Framework 4 or above.
• HTML, CSS and Bootstrap for User Interface.
• JavaScript for client side scripting.
• Asp.net with C# as a programming language and Visual Studio as an IDE.
• MSSQL server 2008 for Database.

Constraints

Reliability Requirements

The system should be fully operational at any given time. The system will generate an appropriate error message if there are any problems occurred.

• The system will generate error messages when the user attempts to enter invalid data.
• The system will reject invalid user input without crashing.
• The system will display appropriate messages when the database is down.
• The system will be recoverable within a day if it is down.

Safety and Security Consideration

There is no specific requirement that the user or the admin need to log in to the system by using their unique ID. The back-up for all the data needs to be considered as if the system fails to operate or crash. There is a chance that all the data will be lost. The access to the potentially damaging commands should be limited as it can damage or destroy data and equipment.

Assumption and Dependencies

Assumptions and dependencies are described below:

If the central Database System changes to Distributed Database System, then system requirements affect and it should be changed accordingly.

• User has computer with Windows 7 or Above OS and Internet/Intranet Connection.
• Database transactions are assumed to be secure and reliable.
• This application depends on the server. So it is assumed that server is working correctly.
•  The user knows the basic functionalities of using a computer.

SYSTEM ANALYSIS

System Requirements Specification (SRS)

Functional Requirements

R1 Sign in

R1.1 Enter Username and Password.

Input: User enters username and password.

Output: System allows user to proceed if username and Password is correct.

Processing: System validates Username and Password.

R1.2 Sign Up the new user.

Input: User enters emailed and password.

Output: System registers the new user and creates his/her new profile.

Processing: System validates Password and Confirm Password.

R2 View Room

R2.1 Sort the Room

Input: User chooses one sorting option.

Output: All rooms are displayed in the sorting order based on user’s selection.

R2.2 Filter the room

Input:  User selects the filtering options.

Output: rooms matching the filtering criteria are displayed.

Processing: System checks which rooms matches the selection criteria.

R2.3 Review room

Input: The user provides the reviews and rating to the product.

Output: The review and ratings given by particular user is saved.

R3 Select Room

R3.1 Select Category

Input: User is given various options to navigate the different categories.

Output: products in the selected category are displayed.

R3.2 View Room details

Input:  User selects one product he/she is interested in.

Output: Full Specification of the room is displayed in detail.

R3.3 Reserve Room

Input: User selects the room to be reserve.

Output: The selected room is processed for reservation.

R4 Manage User Profile

R4.1 Maintain User information.

R4.1.1 Add User Information

Input: User provides his/her personal information.

Output: All the information is added successfully.

R4.1.2 Modify User Information

Input: User modifies his/her personal information.

Output: All the information is updated successfully.

R4.2 Manage Reservation

R4.2.1 View Reservation

Input: User selects to view the reservation.

Output: All the orders made by the users are shown to him/her.

R4.2.2 Cancel Reservation

Input: User selects the reservation to be canceled.

Output: The reservation selected by the users is canceled.

Processing: The system checks whether the reservation is eligible for cancel.

R4.2.3 Modify Reservation

Input: User requests to change the reservation.

Output: The modification request is approved or rejected.

Processing: The system approves the request if the reservation is prior date of modification otherwise it is rejected.

R4.3 View Wish List

Input: User selects the wish list option.

Output: The products in the saved list are displayed.

R5 Manage Reservation

R5.1 Make new Reservation

Input: User creates new reservation for the room s/he selects.

Output: The user is provided the details of the reservation.

R5.2 Verify reservation Details

Input: User selects the reservation to be verified.

Output: The user is provided the reservation number and other details.

R5.3 Pay Bill

Input: System calculates the total amount of bill to be paid.

Output: Customer pays the bill.

R6 Admin

R6.1 User Management

Input: The admin adds or updates the User and user information.

Output: The User list is modified.

R6.2 Offers Management

Input: The admin adds or updates the offers.

Output: The offers are modified accordingly.

R6.3 Configuration

Input: The admin modifies the configurations of the website.

Output: The configurations are updated accordingly.

R6.4 Hotel Management

Input: The admin modifies the status of the Hotel.

Output: The Status of the order is updated as approved or rejected.

Non-Functional Requirements

Reliability

The factors needed to establish the software expected reliability are

• The user inputs should be valid and within the given range.
• Normal Termination of program

Security

• One user cannot access the other user’s account.
• Only the authenticated user is allowed to log in.

Maintainability

• The system shall ensure that the data is protected from unauthorized access.
• The application uses minimum number of interactions with the server which results in overall high performance of the application.
• The Application is operational 24 hours a day, 7 days a week.
• Application code is easy to debug and extend for new features if needed.

4.2 Use Case Diagram

4.4 Sequence Diagram

4.5 Activity Diagram

Activity Diagram for Admin

Activity Diagram for Hotel Owner

HOTEL AGENT Activity Diagram

Support at Resme.com Activity Diagram

User Activity Diagram

Guest Activity Diagram

Registered User Activity Diagram

IMPLEMENTATION PLANNING

Implementation Environment

Single v/s Multi-user

Single-user applications are the application where only single user can use the application at a time. While in Multi-user given application is used by many users at the same time and thus web application are used by many users at the same time.

The present system is a multi-user system as we have more than one Students and Faculties using this system.

GUI v/s Non GUI

A Non-GUI application uses command Prompt for input and output while GUI applications has graphics form to interface and other graphics property for various I/O operation and are easy to use.

The present system is a GUI based and thus easy and effective to use therefore user can easily give input and take output.

Program/ Modules Specification

Some of the main modules in the system are:

• Insert/Update facility in master modules which are accessible in other modules.
• Some of main master modules at admin side are:
  • Reservation
  • Hotel Owner
  • Offers
  • Manage User
  • Registered User
  • Payment processing
  • Manage entire list of room for customers.
  • Add and manage hotels and its information.
  • Provide sorting and filtering facilities in product list.
  • Add users and assign them privileges.
  • Manage an individual profile for every registered customer.
  • Customer can pay online.

Security Features

The main security feature of the system is that not all users have permission to access entire system. Access of the system is given to each user as per his/her role in the system.

• Admin has all rights of the system.
• Other users have access to only those parts of the system that their user role allows them.
• The customer can access his/her profile and modify the information in it.
• The customer can cancel and return order provided it satisfies particular conditions.

Coding Standards

The front-end of the project is Microsoft Visual Studio 2010. The project “Online Travel Agency System” has fixed standard for designing the GUI so that all modules are found consistent as far as GUI is concerned.

The GUI standards includes following specifications:

• The sizes of components like buttons, textboxes, combo-boxes, list etc.
• In system login facilities are available.
• User can change password.
• All the authority is given to Administrator only.
• The coding standard provides the guideline for coding a module during development. When these standards are strictly followed the code becomes more readable and understandable making the process of debugging easy.
• Specifications for coding loops and other control structures.
• Specifications for defining the variables etc. and defining the functions.

TESTING

Test Cases

Purpose

Test case ensures that application work correctly as per customer requirement so it can use in real time environment. It is an action performed on the application with some input to test the functionality; it’s usually a step by step procedure. The main purpose of test case is note to miss testing of any functionality and requirement. As it is performed in a sequential way, one step by step the second step would be relevant to the previous one so there won’t be any chance for the tester to miss any requirement or functionality. Writing test case and executing test case give confidence to release software.

The main reason for the Test case falls into one of below categories. Each of the listed categories provides value to the company in different ways, but they all must function to reduce risk and qualify the testing effort. A good test covers all the functions and provides some measurable value to the corporation with the explicit purpose of:

• Verifying conformity to applicable standards and guidelines based on customer requirements.
• It must be test and validating customer expectations and needs.
• Increasing control flow coverage.
• Increasing logic flow coverage.
• Increasing data flow coverage.
• Simulating ‘real’ end user scenarios.
• Exposing errors or defects.

Test Cases of System

Table 7-1 Test Cases for Sign in

Test Object

Test Condition

Expected Result

Actual

Pass/Fail

Description

(Input)

Result

Click “Sign in”

Display wrong

As Expected

PASS

button without

Email ID or

email and/or

Password message.

password

Click “Sign in”

Display wrong

As Expected

PASS

Sign in

button with

Email ID or

incorrect email

Password message.

and/or password

Click “Sign in”

Redirect to List

As Expected

PASS

button with correct

Account Profile

email and/or

page of the user.

password

Table 7-2 Test cases for Add details in “My Account” section

Test Object

Test Condition

Expected Result

Actual Result

Description

(Input)

Click “Save” without

filling up necessary

Display Error message.

As Expected

information

Add Details in

Click “Save” with

“My Account” profile

filling up necessary

Record added

As Expected

section

information

successfully.

Modify the details and

Records are updated

successfully.

As Expected

click on “Save”

Table 7-3 Test cases for Sign up new user

Test Object	Test Condition	Expected Result	Actual Result
Description	(Input)
		Not allow to enter
	Enter same Email Id	same email Id and	As Expected
		display error message
Sign up new user
	Enter incorrect	Display error
		“Password and
	confirmation password
		Confirmation Password	As Expected
	which is different from
		not match”
	password
	Enter same password
	and confirmation	Successfully register	As Expected
	password	the new customer

Table 7-4 Test cases for Delete Record

Test Object	Test Condition	Expected Result	Actual Result
Description	(Input)
	Click Reserve without   Providing room and personal  information	Display error
		prompt	As Expected
		Display error
		prompt
	Click Reserve without		As Expected
Reserve room	Payment  information
		Room will be reserve, make necessary changes to the database, confirmation email will be sent to the customer and hotel owner
	Click Reserve with   All required  information
			As Expected

 Table 7-5 Test cases for Edit Record

Test Object	Test Condition	Expected Result	Actual Result
Description	(Input)
		Old details of records
		are successfully
	Click on edit button.	fetched from the	As Expected
		database so that they
Edit Record		can be easily modified.
	After Edit click on	Data will be updated
	“Save” button.		As Expected
		successfully.

Table 7-6 Test cases for Change Password

Test Object	Test Condition	Expected Result	Actual Result
Description	(Input)
	Enter new password	Display error “New
		password same as
	same as current		As Expected
		current password”
	password
	Enter new password	Display error “Confirm
Change Password	different than current
		password is not same	As Expected
	password
		as current password”
	Enter new password	Password successfully
	correctly		As Expected
		Updated.