Hotel
Hotel
Hotel
1. Introduction
The project, Hotel Management System is a desktop
application that allows the hotel manager and staff to
handle all hotel activities in hotel reception. Interactive
GUI and the ability to manage various hotel bookings and
rooms make this system very flexible and convenient.
Home Page
Add Customer Details
Room Booking
Billing
Page |2
2. Definitions
Proposed System
3. FEASIBILTY REPORT
3.1 GENERAL REQUIREMENTS FEASIBILTY REPORT:
4. TECHINICAL FEASIBILITY:
5. Technical Description
The total number of databases that were identified to
build the system is 10. The major part of the Databases is
categorized as administrative components and the user
components. The administrative components are useful is
managing the actual master data that may; be necessary to
maintain the consistency of the system. The administrative
databases are purely used for the internal organizational needs
and necessities.
7.1 Purpose:
The main purpose for preparing this document is to give
a general insight into the analysis and requirements of the
existing system or situation and for determining the operating
characteristics of the system.
7.2 Scope:
This Document plays a vital role in the development life
cycle (SDLC) As it describes the complete requirement of the
system. It is meant for use by the developers and will be the
basic during testing phase. Any changes made to the
requirements in the future will have to go through formal
change approval process.
Page |7
8. Functional Requirements:
Inputs:
Output:
9. Performance Requirements:
the system, with respect to the requirements that have been pin
pointed to get the exact structure of the system as stated by the
actual client.
Visual Studio Code has some very unique features. They are
listed as below:
Step 1: Visit the official website of the Visual Studio Code using
any web browser like Google Chrome, Microsoft Edge, etc.
Visit-the-official-website-of-the-Visual-Studio-Code
Press-the-Download-for-Windows-button
Step 3: When the download finishes, then the Visual Studio Code
icon appears in the downloads folder.
Visual-Studio-Code-Installer
Step 5: After the Installer opens, it will ask you for accepting the
terms and conditions of the Visual Studio Code. Click on I accept
the agreement and then click the Next button.
Step 6: Choose the location data for running the Visual Studio
Code. It will then ask you for browsing the location. Then click on
Next button.
Option-for-Visual-Studio-Code
Step 7: Then it will ask for beginning the installing setup. Click
on the Install button.
P a g e | 19
Click-on-the-Install-button
Installing-Visual-Studio-Code
Visual-Studio-Code-installation-is-finished
Step 10: After the previous step, the Visual Studio Code window
opens successfully. Now you can create a new file in the Visual
Studio Code window and choose a language of yours to begin
your programming journey!
14 DATABASE
A database is a structured collection of data that is
organized, stored, and managed in a way that allows efficient
retrieval, updating, and manipulation of the data. It is a
fundamental component of most software applications, providing
a persistent and reliable storage solution for handling large
volumes of structured information.
14.1 MySQL
After clicking on the apply button the SQL script is applied to the
Database. It will show it has successfully applied the script to the
database. Now we can click finish, we have successfully created a
database schema named hotel.
P a g e | 27
1) register
2) customer
3) room
4) details
P a g e | 28
1) register
P a g e | 29
P a g e | 30
P a g e | 31
2) customer
P a g e | 32
P a g e | 33
3) room
P a g e | 34
P a g e | 35
4) details
P a g e | 36
P a g e | 37
16 NUMBER OF VIEWS:
• Administrative View
• Guest View
o Data Insertion
o Data Deletion
o Data Updating
P a g e | 39
o Data Selection
HOTEL
USER MANAGEMENT
SYSTEM
DATABASE
P a g e | 41
Customer Info
Admin
Booking Info
ACCOMODATIO
N Report
UPHOLDING
SYSTEM
Guest
P a g e | 42
19. ER-Diagrams
P a g e | 43
1. 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.
Psychology of Testing:
Testing Objectives:
Levels of Testing:
Requirements
System Testing
Design
Integration Testing
Code
Unit Testing
P a g e | 45
Registration Page
Login Page
P a g e | 46
Home Page
Customer Page
P a g e | 47
MAINTENANACE
References:
Steven Feuerstein, Bill Pribyl , PL/SQL Programming,
O’Reilly Media, 2014
Website References:
https://openai.com/blog/chatgpt
https://data-flair.training/
https://www.w3schools.com/
https://www.python.org/
https://www.mysql.com/