0
PROJECT ON :-Hostel Management System
INTRODUCTION
This project is based on management of hostels, such
as information about the students such as his\her roll number
in department they belong to , etc. These information can be
stored in the data and can be verified whenever we want. This
computer programme can be used for hostels schools etc.
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the
programming knowledge into a real- world situation/problem and
exposed the students how programming skills helps in developing a
good software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when
developing small to medium sized projects.
3. Write effective procedural code to solve small to medium sized
problems
4. Students will demonstrate a breadth of knowledge in computer
science, as exemplified in the areas of systems, theory and
software development
5. Students will demonstrate ability to conduct a research or
applied Computer Science project, requiring writing and
presentation skills which exemplify scholarly style in computer
science
1
2
3
PROPOSED SYSTEM
The HOTEL MANAGEMENT SYSTEM is a software application which avoids
more manual hours in taking the book, that need to spend in record keeping
and generating reports. Maintaining of consumer details is complex in manual
system in terms of agreements, royalty and activities. This all have to be
maintained in ledgers or books. Manager need to verify each record for small
information also
1) The system maintains the different location that are available and
registered in a central DB, which leads easy accessibility and consistency.
2) Each Accommodation available units and all the unit facilities are also
available at the click of a mouse.
3) The registration of new guest is online house new guest can make them
they convenient for registration process on the basic of 24x7x326days.
4) The Units can be booked by the Registered guest irrespective of the
Geographical barriers.
5) The Guest are provided with up to minute information related to the
unit availability and their status. From their convenient place
6) The decision process in more faster and more consistent
7) The guest have information at their demand related to any unit status of
their own unit booking status
4
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
5
DESIGN PHASE
The design phase involves converting the informational, functional, and
network requirements identified during the initiation and planning phases into unified
design specifications that developers use to scriptprograms during the development
phase. Program designs are constructed in various ways. Using a top-down
approach, designers first identify and link majorprogram components and interfaces,
then expand design layouts as they identify and link smaller subsystems and
connections. Using a bottom-up approach, designers first identify and link minor
program components and interfaces, then expand design layouts as they identify
and link larger systems and connections. Contemporary design techniques often use
prototyping tools that build mock-up designs of items such as application screens,
database layouts, and system architectures. End users, designers, developers,
database managers, and network administrators should review and refine the
prototyped designs in an iterative process until they agree on an acceptable design.
Audit, security, and quality assurance personnel should be involved in the review
and approval process. During this phase, the system is designed to satisfy the
functional requirements identified in the previous phase. Since problems in the
design phase could be very expensive to solve in the later stage of the software
development, a variety of elements are considered in the design to mitigate risk.
These include:
Identifying potential risks and defining mitigating design features.
Performing a security risk assessment.
Developing a conversion plan to migrate current data to the new system.
Determining the operating environment.
Defining major subsystems and their inputs and outputs.
Allocating processes to resources.
Preparing detailed logic specifications for each software module. The result is
a draft System Design Document which captures the preliminary design for
the system.
Everything requiring user input or approval is documented and reviewed by
the user. Once these documents have been approved by the Agency CIO and
6
Business Sponsor, the final System Design Document is created to serve as
the Critical/Detailed Design for the system.
This document receives a rigorous review byAgency technical and functional
representatives to ensure that it satisfies the business requirements.
Concurrent with the development of the system design, the Agency Project
Manager begins development of the Implementation Plan, Operations and
Maintenance Manual, and the Training Plan.
7
DEVELOPMENT PHASE
The development phase involves converting design specifications into
executable programs. Effective development standards include requirements that
programmers and other project participants discuss design specifications before
programming begins. The procedures help ensure programmers clearly
understand program designs and functional requirements. Programmers use
various techniques to develop computer programs. The large transaction oriented
programs associated with financial institutions have traditionally been developed
using procedural programming techniques. Procedural programming involves the
line-by-line scripting of logical instructions that are combined to form a
[Link] completion of the previous stages is a key factor in the success
of the Development phase. The Development phase consists of:
Translating the detailed requirements and design into system components.
Testing individual elements (units) for usability.
Preparing for integration and testing of the IT system.
.
8
SOURCE CODE
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='1234',database='hostel_manage ment')
[Link]=True
if conn.is_connected():
print('connected succesfully')
else:
print('not connected')
c1=[Link]()
#[Link]("create table fees(department int primary key,fees int)") v_department=input("enter your
department
v_fees=input("enter your fee")
abc=("insert into fees values ("+v_department+","+v_fees+")")
print(abc)
[Link](abc)
[Link]()
#[Link]("create table hostel_management(roll_no int primary key,name varchar(20),address
varchar(100),room_no int,dept varchar(15),fees int,bal int)
Print (" WELCOME TO HOSTEL MANAGEMENT ")
print(“ [Link] FORM")
print(" [Link] CHECKING")
print(" [Link] DATA")
print(" [Link] ONLY")
9
print(" [Link]")
choice=int(input('ENTER YOUR CHOICE'))
if choice==1:
v_roll=input("ENTER YOUR ROLL NUMBER")
v_name=input("ENTER YOUR NAME")
v_add=input("ENTER YOUR ADDRESS")
v_room_no=input("ENTER YOUR ROOM NUMBER")
v_dept=input("ENTER YOUR DEPARTMENT")
v_fees=input("ENTER YOUR FEES")
v_bal=input("ENTER YOUR BALANCE")
abc=("insert into hostel_management values
("+v_roll+",'"+v_name+"','"+v_add+"',"+v_room_no+",'"+v_dept+"',"+v_fees+","+v _bal+")")
print(abc)
[Link](abc)
[Link]()
elif choice==3:
roll_no=int(input("enter your roll number"))
mysql="select*from hostel_management where roll_no={}".format(roll_no)
[Link](mysql)
data=[Link]()
print("roll_no:",data[0][0])
print("name:",data[0][1])
print("address:",data[0][2])
print("room_no:",data[0][3])
print("dept:",data[0][4])
print("fees:",data[0][5])
print("bal:",data[0][6]
10
elif choice==2:
print("AVAILABLE DEPARTMENTS AS FOLLOWS")
print("[Link]")
print("[Link]")
print("[Link]")
print("[Link]")
print("[Link]")
print("[Link]")
department=input("ENTER YOUR DEPARTMENT")
mysql="select*from fees where department='{}'".format(department) [Link](mysql)
data=[Link]()
print("your fees is:",data[0][1])\
elif choice==4:
print( "SORRY,YOU ARE NOT AUTHORIZED TO USE THIS SITE ")
else:
print("QUITTING!!!!!!!!!")
11
TESTING
Software Testing is an empirical investigation conducted to provide
stakeholders with information about the quality of the product or service
under test [1] , with respect to the context in which it is intended to
operate. Software Testing also provides an objective, independent view
of the software to allow the business to appreciate and understand the
risks at implementation of the software. Test techniques include, but are
not limited to, the process of executing a program or application with the
intent of finding software bugs.
It can also be stated as the process of validating and verifying that a
software program/application/product meets the business and technical
requirements that guided its design and development, so that it works as
expected and can be implemented with the same characteristics.
Software Testing, depending on the testing method employed, can be
implemented at any time in the development process, however the most
test effort is employed after the requirements have been defined and
coding process has been completed
Psychology of Testing : The aim of testing is often to demonstrate that a
program works by showing that it has no errors. The basic purpose of testing
phase is to detect the errors that may be present in the program. Hence one
should not start testing with the intent of showing that a program works, but
the intent should be to show that a program doesn’t work. Testing is the
process of executing a program with the intent of finding errors.
12
Testing Objectives: The main objective of testing is to uncover a host of errors,
systematically and with minimum effort and time. Stating formally, we can say
Testing is a process of executing a program with the intent of finding an
error. A successful test is one that uncovers an as yet undiscovered error. A
A good test case is one that has a high probability of finding error, if it exists.
The tests are inadequate to detect possibly present errors. The software
more or less confirms to the quality and reliable standards
Integration Testing: Integration testing is one of the new aspects of
testing for us. It includes different modules of software, tested together
by combining them in a group.
Negative Testing: It involves testing the software to determine its
behavior by entering unexpected values. It is also known as “against the
rule” testing
Billing Models: We also came across different types of hotel
management billing models. These include different methods of
calculation of taxes, category wise billing, and the addition of other
services.
Functional Testing: This is the type of block box testing which is included in the
quality assurance processes to assess the functional performance of the
system against the specifications and the requirements. Functional testing is
primarily conducted by feeding the requirements into the testing module,
running it on the existing system, and then examining the output against the
desired results. If the outcome has a lot of deviations and variations from the
expectations, from a developmental perspective, then it is cataloged under the
defective components.
13
14
HARDWARE AND SOFTWARE REQUIREMENTS
[Link] SYSTEM : WINDOWS 7 AND ABOVE
II. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUALCORE)
III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIAK8M800+8237R PLUS
CHIPSET FOR AMD ATHALON
IV. RAM : 512MB+
V. Hard disk : SATA 40 GB OR ABOVE
VI. CD/DVD r/w multi drive combo: (If back up required)
VII. FLOPPY DRIVE 1.44 MB : (If Backup required)
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse
X. Printer : (if print is required – [Hard copy])
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python
III. MySQL
15
BIBLIOGRAPHY
1. Computer Science with Python - Class XI By; SumitaArora
2. A project report on Blood Bank Management System (BBMS)
3. Website: [Link]
***
16
