MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION

DR. D. Y. PATIL SCHOOL OF ENGINEERING

(SECOND SHIFT POLYTECHNIC)

MICRO PROJECT
Academic year: - 2021-2022

TITLE OF THE PROJECT

Select suitable Software Process model for Software development

Use Software modeling to create data designs.

Course: Software Engineering Course code: 22413

 MAHARASHTRA STATE BOARD OF
TECHNICAL EDUCATION

Certificate
This is to certify that Mr. ROHIT RAMESH Mahato students of Diploma in
Computer Engineering of Institute, Dr. D. Y. Patil School of Engineering
(Second Shift Polytechnic) Institute Code – 1649, has completed the Micro
Project satisfactorily in course Software Engineering (22413) for the academic
year 2021-22 as prescribed in the curriculum.

Place : Enrollment No.

Date: Exam Seat No.

Course Teacher Head of the Department Principal

Seal of the
Institute
 MAHARASHTRA STATE BOARD OF
TECHNICAL EDUCATION

Certificate
This is to certify that Ms. Mansi Tukaram Devdare students of Diploma in
Computer Engineering of Institute, Dr. D. Y. Patil School of Engineering
(Second Shift Polytechnic) Institute Code – 1649, has completed the Micro
Project satisfactorily in course Software Engineering (22413) for the academic
year 2021-22 as prescribed in the curriculum.

Place : Enrollment No.

Date: Exam Seat No.

Course Teacher Head of the Department Principal

Seal of the
Institute
 MAHARASHTRA STATE BOARD OF
TECHNICAL EDUCATION

Certificate
This is to certify that Ms. Sanika Sagar Kotkar students of Diploma in Computer
Engineering of Institute, Dr. D. Y. Patil School of Engineering (Second Shift
Polytechnic) Institute Code – 1649, has completed the Micro Project
satisfactorily in course Software Engineering (22413) for the academic year
2021-22 as prescribed in the curriculum.

Place : Enrollment No.

Date: Exam Seat No.

Course Teacher Head of the Department Principal

Seal of the
Institute
 MAHARASHTRA STATE BOARD OF
TECHNICAL EDUCATION

Certificate
This is to certify that Mr. Hrushikesh Yogesh Kakulte students of Diploma in
Computer Engineering of Institute, Dr. D. Y. Patil School of Engineering
(Second Shift Polytechnic) Institute Code – 1649, has completed the Micro
Project satisfactorily in course Software Engineering (22413) for the academic
year 2021-22 as prescribed in the curriculum.

Place : Enrollment No.

Date: Exam Seat No.

Course Teacher Head of the Department Principal

Seal of the
Institute
 Dr. D Y Patil Educational Enterprises Charitable Trust’s
Dr. D. Y. PATIL SCHOOL OF ENGINEERING, (POLYTECHNIC)
Approved by AICTE NO. West / 1-3847411/2010/ New Dated 13 July
2010/DTE/Affiliated to MSBTE, Mumbai.
Dr. D Y Patil Knowledge City, Charholi Bk, Via Lohegaon, Pune – 41210

MICRO-PROJECT PROPOSAL

“ HOTEL MANAGEMENT “

Aims/Benefits of the micro project

1. To understand the use and need of Waterfall model in Software engineering

and on daily basis also how it is used.
2. Identifying how models and small projects or Software are created.
3. Developing Hotel management System to make more interactive
communication between hotel manager and customer.

Course outcomes addressed

✓ Select suitable Software Process model for Software development.
✓ Use Software modeling to create data designs.
Action Plans
Sr.No. Planned Planned Name of Responsible
Details of activity
Start date Finish date Teams Members
1. Searching Mansi Devdare
5-4-2022 6-4-2022

2. Selected Project
7-4-200 7-4-2022 Rohit Mahato

3. Collection information Mansi Devdare

8-4-2022 15-4-2022
Rohit Mahato
4. Study the needed Rohit Mahato
information 16-4-2022 20-4-20 Mansi Devdare

5. Prepare a rough Format Sanika Kotkar

21-4-20 25-4-20
Rohit Mahato
6. Started the work on this Mansi Devdare
micro project Rohit Mahato
27-4-20 6-5-2022
Sanika Kotkar
Hrushikesh Kakulte
7. Prepare and present
7-5-2022 8-5-2022 Hrushikesh Kakulte
reports
8. Submittedd to the Guide Mansi Devdare
Rohit Mahato
11-5-2022
Sanika Kotkar
Hrushikesh Kakulte

NAME OF TEAM MEMBERS WITH ROLL NO. :

17. ROHIT MAHATO

10. MANSI DEVDARE

13. HRUSHIKESH KAKULTE

53. SANIKA KOTKAR

 Dr. D Y Patil Educational Enterprises Charitable Trust’s
Dr. D. Y. PATIL SCHOOL OF ENGINEERING, (POLYTECHNIC)
Approved by AICTE NO. West / 1-3847411/2010/ New Dated 13 July
2010/DTE/Affiliated to MSBTE, Mumbai.
Dr. D Y Patil Knowledge City, Charholi Bk, Via Lohegaon, Pune – 41210

MICRO-PROJECT REPORT

Rationale

In the present time there is a great rush in hotels, as these have become necessity
for middle and upper class of the society. People travel a lot, stay in hotels, goes
to the hotels for functions, meeting and refreshment. Our project is developed
keeping in mind the general needs of the customers when he/she goes to the hotel.
Hotel Management System is a type of properly management system that
facilitates the management of hotel operations and functions; main operations
such as front office, sales, planning, and accounting.

Literature Review
Further read more about the topic from internet and different websites such as
www.scribd.com www.muengineers.in www.scrib.com
We also referred such books as follows:

Sr .No Title of Book Author Publication

1. Software Engineering :A Pressman, Roger S McGraw Hill

Practitioner’s approach Higher Education,
New Delhi.

2. Software Engineering Fairly, Richard McGraw Hill

Concepts Education, New
Delhi.
Methodology Followed
• We searched the topic for the micro-project .
• We selected Hospital Management System project. We selected this topic as
Waterfall model is so important in our daily basis and making Software
development for projects .
• We collected all the necessary information from Internet and books.
• We studied about all the water fall model and Software development used in
the project.
• Then we started to collect information regarding the project.
• We started the work on the micro-project and after compilation submitted to
our guide.

Actual Resources Used:

Sr. No. Name of Resource Quantity Remarks

1. Computer system 4GB RAM
AMD Ryzen 5
2. Internet / Reference Google Chrome
books
3. Other Source Printers
MS-Word
 HOTEL MANAGEMENT SYSTEM

This project aims at creating on Hotel Management System which can be used by Admin and
Customers. The admin to advise/publish the availability of rooms in different hotels and
customers are checking the availability of room in required hotel. Customers should be able
to know the availability of the rooms on a particular date to reserve in hotel. They should be
able to reserve the available rooms according to their need in advance to make their stay
comfortable. The Admin hands the booking information of customers. The users can register
and log into the system. The administrator will know the details of reservation and daily
income. The hotel department maintain the seat availability and booking details in certain
database. This project provides high security to Admin and user information.

The main objective of this project is to design a hotel management system for running a hotel
business. The system should be as flexible as possible so that it can be used for different
hotels. You have to find out which procedures hotels have used for different hotels. You have
to find out which procedures hotels have and based on that information, you should create a
system which makes it efficient.

You need to find out how a hotel system works on the internet, use your own experience or
directly talk to people in the hotel business. The more diverse the sources of your information
are, the better will be the resulting system and, possibly, your grade.
Introduction
The project, Hotel Management System is a web-based application that allows the hotel
manager to handle all hotel activities online. Interactive GUI and the ability to manage various
hotel bookings and rooms make this system very flexible and convenient. The hotel manager
is a very busy person and does not have the time to sit and manage the entire activities
manually on paper. This application gives him the power and flexibility to manage the entire
system from a single online system. Hotel management project provides room booking, staff
management and other necessary hotel management features. The system allows the manager
to post available rooms in the system. Customers can view and book room online. Admin has
the power of either approving or disapproving the customer’s booking request. Other hotel
services can also be viewed by the customers and can book them too. The system is hence
useful for both customers and managers to portable manage the hotel activities.

Aim
The mission is to facilitate easy management and administration of a hotel with capabilities to
do Booking or reservations of the rooms, Cancellation of the rooms, Cash billing, Room
service, Restaurant service, Restaurant Billing, Total Billing, Travels arrangement etc. using
the automated hotel management software. One can Keep detailed records or info on an
unlimited number of customers. The system lets the user Know which all rooms are available
for occupancy at any point of time. This makes the Booking considerably faster. And thus
helps the hoel in better management and reduce a lot of paper work as well as manpower.
Concepts of Hotel Management System
The Hotel Management System (HMS) is a software application for hotel establishment to
manage customer information and employee information for quick results. Hotel Management
System provides capabilities for entering customer data, facilitate easy management and
administration of a hotel with capabilities to do Booking or reservation of the rooms,
Cancellation of the rooms, Cash billing, Room services, Total billing etc. using computerized
hotel management system.

Features of Hotel Management System

1. User Authentication
2. Fast Data Insertion
3. User friendly insertion
Advantages Of Hotel Management System

1. Speed up the process. Hotel systems are designed to efficiently save, retrieve,
send, calculate and sync data into the database thus making the processes fast.
Having fast transactions makes more money, good customer experience and
convenient for hotel users.
2. Less Errors. Hospitality software are programmed to prevent duplicate entries,
wrong data type inputs. Also provides text preservation when accidentally
erased.
3. Real-time results. Computers with high specifications plus a high performance
hotel system would definitely give real-time results from any transactions like
saving data inputs, updating and deleting of data entries.
4. Accurate Daily Revenue Reports. Due to the real-time and error free features,
hotel managers have access to an accurate daily revenue reports that can be
either showed or printed.
5. Prevent Double Booking. In manual operations, double booking is a common
scenario but hospitality software can avoid this occurrence due to system
trappings and checks.
6. Timely Financials Reports. One of the many systems reports is the financial
information, and can be done through SAP Business One for SME’s.
7. Nationality Report. In the Philippines, all hospitality business that offers
accommodation needs to submit a nationality resort to the Department of
Tourism for compilation. Most report feature of hospitality software have the
nationality report.
8. Market segmentation. With a hotel system, managers and owners can better
 track the types of visitors that usually have and from that data they can see if
their business is targeting the right market.
9. Collaboration of various departments. There are many types of hotel users
that belongs to a specific department or division, with a hotel system it can
promote good collaboration various departments due to real-time reporting and
display status.

Disadvantages
• Expensive System.
• Maintenance is also not easier.
• Spoofing attack may occur in Online Hotel Reservation System.
• Hacking of website may lead to crashing of system.
System Development Model
The model to be employed in the development of this system is Rapid Application
Development model. This is an adaption of the traditional Waterfall model and is
better suited for the project because the development steps can be carried out
concurrently that is While more data is been gathered to make system robust and
fully effective, design and coding can start and additions made as the project moves
on. This will also make room for early testing to ensure that the system meets its
requirement.
The steps involved in Rapid Application Development are:
1. Planning and Document Requirements
2. System Analysis and Design
3. System Development
4. Testing
5. User Review

1. The Planning Phase

The goal of the planning phase is to map broad capabilities of the system from
the student perspective.
The phase is further divided into the following sub-phase:
i. Project Definition
ii. Session
iii. Final Document
 i. Project Definition
This has to do with identifying what the management wants from the project.
These include the Purpose, Scope, Objective, Process, Constraints,
Resources Requirements, Assumptions and Open issues. The purpose of this
particular project is to provide a platform that allows customers and staffs to
automate their work in the hotel by keeping information about customer and
staffs in the database and generate daily or weekly report for management
decision making.
ii. Session
This stage defines how information is entered into the system via computer
screen. The two type of defining screen are screen flow and screen design.
The session also includes the definition of all the outputs from the system and
any other printouts.
iii. Final Document
The final Document contains the entire documentation of the project
meetings, procedures and the other relevant documents needed for the
successful execution of the project.

2. Design Phase
The design phase is divided into two tiers; the front-end and the back-end.
Database Design
As earlier stated, the database was built using Microsoft SQL Server 2005 and it
consists of various tables storing varying information. The description of each
table is stated below.
Bill Table: It contain information about charges of customer such as food variety
charges, room bill, service tax, and extra charges.

Check Table: This contain information about check-in time of customer and
check-out time of customer, this table also keep record of number of days spent
in the hotel. Customer Table: This contains record of customers such as customer
id, customer name, customer address, and phone number.

Login Table: It contains the login information and the information about
authenticated user of the system, such as user name, password, first name, last
name, phone number.

Reservation Table: It contains information about customers who reserved for

later use. Information stored in this table include reservation id, reservation name,
address, phone number, reservation date, and no of days used to reserve the room.

Room_Master Table: Data stored in this table includes room number, room type,
status of the room, and tariff charge of the room.

Variety Table: This table keeps the record of different variety bought in the hotel
such as food variety and the full details of the variety such as variety id, variety
name, customer id of the customer that bought the variety, costs of the variety. If
the user is an administrator, he can add a new staff according to their designation,
review daily transaction, daily report, weekly report and monthly report,
mobilized report for printing, edit or delete staff account.
INPUT DESIGN
The input requirement of the design phase includes the following:
Admin username: This is the required username for administrator to enter
in the application
Admin password: This is the password of an administrator
Staff username: This is the users‟ username
Staff password: This is the users‟ password

PROCESS DESIGN
1. Room Enquiry and Reservation Module
This module deals with reservation enquiry and reservation. During
reservation, the details of the customers, type of room required and
number of room required are fed in to the system. Once these in
formations are entered, the system searches for the unoccupied rooms
and displays the result. In reservation enquiry, customer can get the
information such as rent of rooms and details of rooms available.
2. Check In/Check-out Module
This module deals with the reservation checkin (i.e., allocating room for
the customer who has already reserved) Direct checkin (i.e., checking in
without reservation), handling checkout of guest’s and Bill payment.
3. Bills and Payments Module
This module deals with the generation and tracking of bills and payments
made by the guest. The bills are classified into lodging bills and
Restaurant Bill. The lodging bill is calculated using the check in and
checkout details of the person. The Restaurant bill is generated based on
the food items consumed by the guest during his stay in the hotel.
4. Reports
This module deals with the generation of the reports for the various
modules. The customer list can be generated. Room status list can be
retrieved for reference. The check in and check out registers can also be
retrieved for any future queries.
3. System Development
Software development like any other field requires a prompt and proper
planning in order to have stable and reliable foundation for further
development.
4. Testing
Testing is the process of detecting errors. Testing performs a very
critical role for quality assurance and for ensuring the reliability of
software. The results of testing are used later on during maintenance
also.
Data Flow Diagram

Hotel Management Generate Hotel

Report

Generate Room
Room management
Report

Generate Booking
Booking
Report
management

Hotel Room
Booking System

Customer Generate Customer

management Report

Login management Check Customer

Report

Generate system
System user
user report
management
Conclusion Hotel Management System

Finally, in the Online hotel management system, we have developed a

secure, user-friendly Hotel Management System. This System can take care
of each member whether its Owner or Customer.

This System will Help them to properly Manage their hotel and help in
growth without creating any hassle. This system is completely secure since
every user is provided with a user ID and Password so there is no chance of
any unauthorized access.

Online Payment, Booking, and cancellation make it easier to use. So, using
this system will help in reducing the labor and provide more facility for
Customer to like Hotel and visit again and again