MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION

VIDYAVARDHINI’S BHAUSAHEB VARTAK

POLYTECHNIC ,VASAI ROAD WEST

MICRO PROJECT
Academic year:

Hospital Management System

Program/Code: Computer Engineering (CO) Semester: 5th

Course/Code : Software Testing (22518)

Name: Akshay Dinesh Raul Roll No: 1951

Enrolment No.: 2200930320

Name of Faculty: Mrs. Seema Kaimal

MAHARASHTRA STATE BOARD OF TECHNICAL
EDUCATION

Certificate

This is to certify that Mr. /Ms. Akshay Dinesh Raul

Roll No:1951 of 5th Semester of Diploma in of Computer Engineering

Institute, B.V. POLYTECHNIC (Code: 0093) has completed the Micro Project
satisfactorily in Subject – Software Testing (22518)

for the academic year 2023- 2024 as prescribed in the curriculum.

Place: Vasai Enrolment No: ……………………………………

Date: ……………………… Exam. Seat No: …………………………………….

Subject Teacher Head of the Department Principal

Annexure - I

Part A: Micro Project Proposal

1.1 Aim/Benefits of the Micro-Project:

The aim is to communicate effectively and skillfully at work place
2.1 Course Outcomes integrated:
1. Communicating effectively by avoiding barriers in formal and informal situations
2. communicate skillfully using non-verbal methods
3. Give presentations by using audio visual aids
4. Write reports using correct guidelines
5.compose e-mail and formal business letters
3.1 Proposed Methodology:
1. Literature survey.
2. Collect information through different sources
3. Analysis of data.
4. Compilation of collected data.

4.0 Action Plan

Sr. Planned Planned Name of

Details of the activity
No. Start Finish Members
date date
1 Formation of Group & Topic Selection All members
2 Submission of Proposed Plan All members
3 Preparation of Report All members
4 Final valuation of a working Report All members
5 Presentation of Report All members
6 Submission of Final Report All members

5.0 Resource Required:

Sr.
Name of resources/Material Specifications Q Remark
No
ty s
.
Processor: i3
1. Computer 1
RAM : 4.00
GB
2. Microsoft Word Word -2016
3. Printer Hp Laser Jet 1

4. Book/ website name

6.0 Name of Team Members with Roll No:

Roll No. Individual Total (10)

Sr. Process and
Name of Presentation
No. Product
Students (04)
assessment
(06)
01 1951 Akshay Raul

02

03

04

Name & Signature of Faculty:

Annexure- II

Final Micro Project Report

Title: Hotel Management System

Rationale: The aim is to communicate effectively and skillfully at work place
2. 0 Course Outcomes Integrated:
1. Communicating effectively by avoiding barriers in formal and informal situations
2. communicate skillfully using non-verbal methods
3. Give presentations by using audio visual aids
4. Write reports using correct guidelines
5. compose e-mail and formal business letters
3.0 Actual Procedure Followed.
1 Discussion about topic with guide and among group members
2 Literature survey
3 Information collection
4 Compilation of content
5 Editing and revising content
6 Report Preparation
4.0: Actual Resources Required:

Sr.
Name of resources/Material Specifications Q Remark
No
ty s
.
Processor: i3
1. Computer 1
RAM : 4.00
GB
2. Microsoft Word Word -2016
3. Printer Hp Laser Jet 1
4. Book/Site name

7.0 Skill Developed/Learning outcomes of this Micro-Project

The following skills were developed:

1. Teamwork: Learned to work in a team and boost individual confidence.
2. Problem-Solving: Developed good problem solving habits.
3. Technical Writing: Preparing the report of proposed plan and the final report.
Annexure - III

Rubrics for
Assessment of
Micro-Project

Title: Hotel Management System

Institute Code: 0093 Academic year: 2023-2024
Program: Computer Engineering Course & Code: Software Testing (22518)
Name of Candidate: Akshay Raul Roll No: 1951
Semester: Fifth Name of Faculty: Mrs. Seema Kaimal

S Poor Average Good Excellent

Characteristic to be Assessed
r (Marks 1- (Marks 4- (Marks 6- (Marks 9-10)
. 3) 5) 8)
N
o.
1 Relevance to the Course
.
Literature
2
Survey/Information
.
Collection
3 Project Proposal
.
Completion of the Target as per
4
Project Proposal
.
5 Analysis of Data and
. Representation
6 Quality of Prototype/Model
.
7 Report Preparation
.
8 Presentation
.
Annexure- IV

Micro-Project Evaluation Sheet

Title:
Institute Code: 0093 Academic year: 2023-24
Program: Computer Engineering Course & Code: Software Testing (22518)
Name of Candidate: Akshay Raul Roll No: 1951
Semester: 5th Name of Faculty: Mrs. Seema Kaimal
Course Outcomes Achieved:
1.Communicating effectively by avoiding barriers in formal and informal situations
2 communicate skillfully using non-verbal methods
3. Give presentations by using audiovisual aids
4 Write reports using correct guidelines
5 compose e-mail and formal business letters
Evaluation as per Suggested Rubric for Assessment of Micro Project:
S Characteristic to Po Average Good Excellen Sub
r. be assessed or Marks Mark t Marks Tota
N Ma 4-5 s 6-8 9-10 l
o. rk s
1-3
(A) Process and product assessment Out Of 6

1 Relevance to the
course
2 Literature Survey .
Information
Collection
3 Completion of the
Target as per
project proposal
4 Analysis of Data
and representation
5 Quality of
Prototype/Model/Co
nte nt
6 Report Preparation
(B) Individual Presentation/Viva Out of 4
7 Presentation .
8 Viva
Weekly Activity Sheet
Topic:
Institute Code: 0093 Academic year: 2023-24
Program: Computer Engineering Course & Code: Software Testing
Name of Candidate: Akshay Raul Roll No: 1951
Semester: 5th Name of Faculty: Mrs. Seema Kaimal

SR. WEEK ACTIVITY PERFORMED

NO
1. 1st Week Discussion and Finalization of
Topic
2. 2nd Week Literature Review
3. 3rd Week Submission of Proposed Plan
4 4th Week Information Collection
5. 5th Week Analysis of Data
6. 6th Week Compilation of content
7. 7th Week Editing and Revising the Content
8. 8th Week Report Preparation
9. 9th Week Report Preparation
10. 10th- 12th Presentation
Week

Date: / /20

Signature of Student Signature of Faculty

Index
Sr. Topics Pag.
no
no
1 Introduction 11

2 Need Of Hotel Management System 2

3 Methods of Booking Hotel’s 3

4 Advantages and Disadvantages of System 4

5 Test plan 5

6 Test Cases of Hotel Management System 7

7 Test summary report 10

8 Output 11

9 Conclusion 15

10 Reference 15
Introduction

What is hotel management?

Hotel management is really about successfully overseeing every operation of the

business to ensure consistent growth and development. This can involve the
management of anything related to the hotel industry and requires knowledge of
distribution strategy, finance and accounts, customer service, staff management,
marketing, catering management, hotel administration and more.

What is hotel management software?

Hotel management software is a technology that allows hotel operators and owners
to streamline their administrative tasks while also increasing their bookings in both
the short and long term.Your hotel management system is not only important for
your own day-to-day operations, but it’s a vital part of improving the overall guest
experience. From the beginning of your guests’ online booking journey until the
completion of their stay and their feedback once they return home, your hotel
management system is t
here to enhance their experience
Need Of Hotel Management System:

Manual maintenance of records is time taking and costly now in this technological
era. Technology has evolved during decades that have streamlined the operations
of the business. Think of a life without software at this age.

When it comes to the hotel industry, profits and revenues depend upon the services
experienced by the service. You need a hotel management software. The critical
factors in the industry start from the reception and go through room services, room
cleaning till payroll management of employees.

Now think of the situation when you have to manage all these factors manually.
Isn’t it tedious work?

What if you get all the factors on a single dashboard?

From there you can find out the best performing and least perfuming factors. The
solution is software that is customized as per the hotel industry. It will give you
data that is critical for making housekeeping services efficient.

The primary goal of an HMS is to keep your hotel's operations running smoothly.
An HMS that meets your property's reporting needs is vital to long-term success,
so if your current system makes it difficult or impossible to produce the numbers
you need to assess and expand your company, it's time to switch.
Methods of Booking Hotel’s

Personal approach: The may directly give their reservation to the hotel.
They are also termed as FITs (Free individual travellers) or chance guest.
Those guest are also termed as walk-in guests.

Travel agent: Travel agent acts as a middleman between guest and hotel by
making a reservation for a guest. A travel agent may make a reservation for FITs
(Free individual travellers) or chance guests.

Tour operator: These are wholesalers who coordinate with a different mode of
transportations, hotels, tour, associations, tourist offices etc.

Airlines: Different airlines book hotel rooms for their regular crew members or for
their clients in case of cancellation of their onward flights and also for the use of
their executives.

Inter-sell agencies: They are two or more business Organisations, like Airline and
Hotels, promoting each other’s business for mutual gain. Hotels and car rental
companies may also be inter-sell partners.

Referral groups: They are an informal or sometimes formal association of hotels

who refer guests to each other in case of sold-out status or if a guest is travelling to
another city where the hotel does not have a branch.

Online: Bookings made directly via hotels website, social media, chat widget on
the hotel website, instant messaging platforms like What’sapp, Facebook
Messenger etc.
Advantages of System

• Save time on admin tasks

• Implement an effective revenue management system.
• Increase bookings
• Accurate daily reports
• Prevent double bookings and manual errors

Disadvantages of System

• All the staff needs to be trained on the software

• The software needs to be renewed each year

• High risk of virus attack as the systems are connected to the internet most of
the time
Test Plan
A Test Plan is a detailed document that describes the test strategy, objectives, schedule,
estimation,deliverables, and resources required to perform testing for a software product. Test Plan
helps us determine the effort needed to validate the quality of the application under test. The test plan
serves as a blueprint to conduct software testing activities as a defined process, which is minutely
monitored and controlled by the test manager.
Name of the Project:
Hotel Management System
Introduction:
The objective of this test plan is to test the functionality of Hotel Management System
Test Items:
Test items include front-end, which includes modules such as Register form,login form, hotel details
page, and back-end (database) of the website
Features to be tested:
1. Register form of the system i.e. all functionalities that registers the user into the system.

2. The Login form to log in the already existing/registered user along with his/her or email-idor
phone number, and password authentication.

3. Page that provides the users options of booking, hotel details, etc.

4. Details of check-in and check-out

Features not to be tested: Appearance of the website

Approach:
System Testing is followed for performing the
testing on the system.
Test Entry Criteria:
Testing should begin when:
1. Definition of all test scenarios and test cases is complete.

2. Availability of hardware and software for initiating testing is complete.

3. Clarification of all queries is available.

Test Exit Criteria:

1. All major functionality should work as intended with no critical bugs.

2. Test cases designed in test suite are complete.

3. Coverage in terms of requirements, functionalities and features is achieved as defined in test plan.
Test Suspension Criteria:
Testing should be suspended when:
1. Major functionality doesn't work properly.

2. No more than 20 defects are found.

3. Show stopper defects are founding testing

Test Deliverables:
1. Test Cases

2. Summary report.
Testing Tasks:
Test environment should be ready priorto test
execution phase.Computer with:
1. Operating System: Windows7/ 8/10.

2. RAM: 4GB, 8GB or more.

3. Processor: Inteli5/i7/i9.

4. Active Internet Connection.

Responsibilities:
1. Test planning—Test Manager.

2. Test case writing and Test data definition —Testers with a senior tester.

3. Test Execution-Tester.

4. Query resolution- Test manager and Customer and other Stakeholders.

Staffing and Training needs
1. Training for awareness of quality, usage of tools and techniques must be done.

2. Adequate training must be given about functioning of HTML, CSS & JavaScript.
Schedule:
1. Test-Execution - 10 man-hour

2. Test-Reporting - 4 man-hours.
Risks and Contingencies:
In case of wrong budget estimation, the cost may overrun. Contingency plan Establish scope before
beginning the testing tasks and pay attention to the project planning and also track the budget
estimates constantly.
Approvals:
Project Manager should agree on the completion of the project and determine the steps to proceed
further
Test Cases:

Test Objective Pre-Requisites Steps Input Expected Actual Status

Case Data Output Output
ids
Add Reservation
Tc_1 Verify that User 1.User can NA System System has Pass
user can add Receptionist/ Enter the should saved the
reservation Front Desk data in the save the form
manager is 2. Check if form
logged in the
mandatory
fields are
empty.
3. Invoke the
reservation
form upon
clicking the
reservation
button.
Tc_2 Verify that User 1.Arrival Date : System System has pass
system Receptionist/ date is 12/05/22 should calculated
should Front Desk entered by calculate departure date
calculate & manager is the user. departure and displayed
display the logged in Date and it in the
departure display on correct field
date the
corrected
field
Tc_3 Verify that User 1.Select the Empty User can User has Pass
use can Receptionist/ empty room room is select selected
select an Front Desk 2. Click on selected empty empty room
empty room manager is ‘Select’ room
logged in button to
submit.
Tc_4 Verify that User 1.User has Customer Unique Unique ID has Pass
system Receptionist/ filled all the details ID generated
generates a Front Desk details. for should be
unique id for manager is 2.Click on reservation generated
every logged in Save Button.
reservation
Update Reservation
Tc_5 Verify that User 1.User select Data have to Update the Update Pass
user can Receptionist/ reservation. update reservation successful
select a Front Desk 2. Click against the
reservation manager is ‘UPD ’ exiting
from exiting logged in button to reservation
reservation invoke allotted id by
list update the system
reservation
interface
Tc_6 Verify that User 1.User select Data have to All the Update Pass
only the Receptionist/ reservation. update information successful
flied that Front Desk 2. Click that user
user want to manager is ‘UPD ’ want to
update are logged in button to update has
update invoke updated
update
reservation
interface
Check-in
Tc_7 Verify that User 1.User Click Change has Check-in Check-in Pass
user can Receptionist/ on Check-in given Update Update
invoke Front Desk button to successfully successfully
check-in manager is change the
interface logged in reservation
status.
Tc_8 Verify that User 1.User has NA Print the Print Pass
System Receptionist/ update the document successfully
should allow Front Desk reservation
user manager is status.
to print logged in 2.Click on
check-in ‘Print’
details button
Check-out
Tc_9 Verify that User 1.User Click NA Check out Check in Pass
user can Receptionist/ on Check- interface interface is
invoke Front Desk out button to should be open
check-out manager is change the open
interface logged in reservation
status.
Tc_10 Verify that User 1.User Click Check-out Check-out Check-out Pass
user can Receptionist/ on ‘Update’ update update update
change the Front Desk button to successful
check-out manager is update the
reservation logged in check-out
status status
Test Summary Report
Test Summary Report is a document which contains a summary of all test activities and final test
results of a testing project. Test report is an assessment of how well the Testing is performed. Based
on the test report, stakeholders can evaluate the quality of the tested product and make a decision on
the softwarerelease.

Test summary report identifier:

Test Summary:

A. Test Case Information:

1) Test Cases planned: 09

2) Test Cases implemented:09

3) Test Cases passed:09

4) Test Cases failed: 00

5) Test Case pending:0

B. Defects report
Information: Defects found

inTesting:00

Approval:

Name Role Responsibility Date & Signature

Mr. Jay Test Lead Test Summary Report 06-10-2020

Mr. Harsh QA Analyst Review &Approval 07-10-2020

Mr. Nirbhay Project Manager Review &Approval 08-10-2020

Output of Hotel Management System

Login Page :
Conclusion:
Hotel management system now-a-day have the advantage of modernization. Computer
have done the work more easy. Computer is playing a important role in management.
Reports are made on daily basis for every customer check in or check out which can
easily be seen by the management. Hotel management system has also primary
purpose is to provide facilities to customers. A software for computers makes the
things many times easy, these are made as user friendly and to keep an check and
balance in hotel management and accounts as well.

Reference:
www.wikipedia.com
www.booking.com
www.javapoint.com