INDEX

[Link]. Contents Page No.

1. Introduction 1

2. Manual System 7

3. Proposed System 8

4. Introduction of the Project 9

5. Module used in this project 11

6. Design work 12

7. System Development Life Cycle [SDLC] 13

8. Source Code 19

9. Output (Screenshots) 30

10. System Testing & Maintenance 37

11. Conclusion 38

12. Bibliography 39

0|Page
INTRODUCTION TO
PYTHON

1|Page
Python is an interpreter, object-oriented, high-level programming language with
dynamic semantics. Its high-level built in data structures, combined with dynamic
typing and dynamic binding; make it very attractive for Rapid Application
Development, as well as for use as a scripting language to connect existing
components together. Python's simple and easy to learn syntax emphasizes
readability and therefore reduces the cost of program maintenance. Python supports
modules and packages, which encourages program modularity and code reuse. The
Python interpreter and the extensive standard library are available in source or binary
form without charge for all major platforms, and can be freely distributed.
Python's features include −
➢ Easy to code: Python is a high-level programming language and it is very easy
to code. It is also a developer-friendly language.

➢ Free and Open Source: Python is freely available. You can download it from the
Python Official Website. Secondly, it is open-source. This means that its source code
is available to the public. You can download it, change it, use it, and distribute it.

➢ Object-Oriented Language: One of the key features of python is Object-Oriented

programming. Python supports object-oriented language and concepts of classes,
objects, modularization, etc.

➢ GUI Programming Support: Graphical User interfaces can be made using a

module such as PyQt5, PyQt4, wxPython, or Tkinpython.

➢ High-Level Language: Python is a high-level language. When we write

programs in python, we do not need to remember the system architecture, nor do we
need to manage the memory.

➢ Extensible feature: If needed, you can write some of your Python code in other
languages like C++. This makes Python an extensible language, meaning that it can
be extended to other languages.

2|Page
➢ Python is Portable language: Python language is also a portable language. For
example, if we have python code for windows and if we want to run this code on other
platforms such as Linux, Unix and Mac then we do not need to change it, we can run
this code on any platform.

➢ Python is Integrated language: Python is also an Integrated language because

we can easily integrated python with other languages like C, C++, etc.

➢ Interpreted Language: Python is an Interpreted Language because Python code

is executed line by line at a time. Like other languages C, C++, Java, etc. there is no
need to compile entire python code. This makes it easier to debug the code.

➢ Large Standard Library: Python has a large standard library which provides a
rich set of module and functions so you do not have to write your own code for every
single thing. There are many libraries present in python for such as regular
expressions, web browsers, etc.

➢ Dynamically Typed Language: Python is dynamically-typed. This means that

the type for a value is decided at runtime, not in advance. This is why we don’t need
to specify the type of data while declaring it.

3|Page
INTRODUCTION TO
MySQL

4|Page
A database is a collection of information related to a particular subject or purpose, such as
tracking customer orders or maintaining a product collection. Using any RDBMS application
software like MS SQL Server, MySQL, Oracle, Sybase etc., all information can be managed
from a single database file. Within the file, data can be divided into separate storage
containers called tables. Data can be retrieved using queries.
A table is a collection of data about a specific topic, such as products or suppliers. Using a
separate table for each topic means you can store that data only once, which makes your
database more efficient and reduces data-entry errors. Table organizes data into columns
(called fields) and rows (called records).
A Primary key is one or more fields whose value or values uniquely identify each record
in a table. In a relationship, a primary key is used to refer to specific record in one table
from another table. A foreign key is a column in a relational database table that provides a
link between data in two tables. It acts as across- reference between tables because it
references the primary key of another table, thereby establishing a link between them.

Role of RDBMS Application Program:

A computer database works as a electronic filing system, which has a large number of ways
of cross- referencing, and this allows the user many different ways in which to re-organize
and retrieve data. A database can handle business inventory, accounting and filing and use
the information in its files to prepare summaries, estimates and other reports. The
management of data in a database system is done by means of a general-purpose software
package called a Database Management System (DBMS). Some commercially available
DBMS are MS SQL Server, MS ACCESS, INGRES, ORACLE, and Sybase. A database
management system, therefore, is a combination of hardware and software that can be
used to set up and monitor a database, and can manage the updating and retrieval of
database that has been stored in it. Most of the database management systems have the
following capabilities:
 Creating of a table, addition, deletion, modification of records.
 Retrieving data collectively or selectively.
 The data stored can be sorted or indexed at the user's discretion and direction.
 Various reports can be produced from the system. These may be either standardized
report or that maybe specifically generated according to specific user definition.
 Mathematical functions can be performed and the data stored in the database can be
manipulated with these functions to perform the desired calculations.
The management of data in a database system is done by means of a general-purpose
software package called a Database Management System (DBMS). Some commercially
available RDBMS are MS SQL Server, MS ACCESS, INGRES, ORACLE, and Sybase.

5|Page
The Main Features of MySQL

➢ MySQL is written in C and C++.

➢ Easy to use: MySQL is easy to use. We have to get only the basic knowledge of SQL. We
can build and interact with MySQL by using only a few simple SQL statements.
➢ Secure: It consists of a solid data security layer that protects sensitive data from intruders.
Also, passwords are encrypted in MySQL.
➢ Client/ Server Architecture: It follows the working of a client/server architecture. There is
a database server (MySQL) and arbitrarily many clients (application programs), which
communicate with the server; that is, they can query data, save changes, etc.
➢ Free to download: It is free to use so that we can download it from MySQL official website
without any cost.
➢ Speed: It is considered to be one of the very fast database languages, backed by a large
number of the bench mark test.
➢ High Flexibility: It supports a large number of embedded applications, which makes it very
flexible.
➢ Compatible on many operating systems: It is compatible to run on many operating
systems, like Novell NetWare, Windows, Linux, many varieties of UNIX, etc.
➢ Allows roll-back: It allows transactions to be rolled back, commit, and crash recovery.
➢ Memory efficiency: Its efficiency is high because it has a very low memory leakage
problem.
➢ High Performance: It is faster, more reliable, and cheaper because of its unique storage
engine architecture. It provides very high-performance results in comparison to other databases
without losing an essential functionality of the software. It has fast loading utilities because of
the different cache memory.
➢ High Productivity: MySQL uses Triggers, Stored procedures, and views that allow the
developer to give higher productivity.
➢ Platform Independent: It can be downloaded, installed, and executed on most of the
available operating systems.
➢ Supports large databases: MySQL Server can be used with databases that contain 50
million records. There are users who use MySQL Server with 200,000 tables and about
50,000,000rows.

6|Page
 MANUAL SYSTEM
Manual system means a system which does it’s work itself not by help of any
technology in which paper work has some special place.

All conventional methods are in more use instead of new technologies. And
now as everybody knows that computer graphs at its extent means the more
you can use computer system the more you can make your work easier.

And if in this case system is not computerized then it has to face a lot of
problems because every task gets complex and time consumable.

 Costly
 Difficulty in searching the records
 Maintenance Problem
 Time consuming
 Tedious

7|Page
PROPOSEDSYSTEM
Proposed system is a system which is computerized in every manner.
Computerized system is not just adding machines but they are capable
of doing much complex, tedious and cumbersome tasks.

Processing of data by hand is satisfactory only when the amount of

data to be processed is small and also the manual processing is slow,
monotonous & often subject to error.

Above explanation is clearly telling us that existing system contains a

lot of deficiencies which can be removed by only by following proposed
system.

Now a days, computer graph is at its extent. Computerization contains

a lot of benefits so that everyone chasing and following computerized
items. Now, question arises what kind of help this project or
computerized system can give to remove all disadvantages of this
existing system.

8|Page
 INTRODUCTION
TO PROJECT
Managing a school efficiently is a complex and multifaceted task that
involves various administrative, academic, and operational
responsibilities. In the digital age, automating school management
processes has become imperative to streamline operations, enhance
communication, and ensure data accuracy. Python, a versatile and
powerful programming language, offers a robust platform for creating
comprehensive school management systems. Our Python School
Management Program is designed to address the diverse needs of
educational institutions, from elementary schools to universities.

This program aims to simplify and improve the management of students,

courses, grades, and more, allowing educators and administrators to
focus on what truly matters: providing a high-quality learning experience.
In this program, we will leverage Python's flexibility and libraries to develop
a user-friendly and efficient school management system.

We will cover essential features such as student enrollment, updating

student records, issuing transfer certificate, mark enrollment, fees
payment, grade management, report card generation, fees receipt
generation. Whether you are a school administrator looking to streamline
operations or a developer interested in building educational software, this
program will serve as a valuable resource to get started. Let's embark on
this journey to create a more organized and efficient school management
solution using the power of Python.

9|Page
The options given in this project are as follows:

➢ To add new admission.

➢ To display all the details of the students.
➢ To update a record of a particular student.
➢ To issue transfer certificate to a student.
➢ To add a student’s marks detail.
➢ To display all students’ report card.
➢ To display student wise report card.
➢ To pay student’s fee.
➢ To display all students’ fees receipt.
➢ To display student wise fees receipt.
➢ To display a Help message.
➢ To Exit.

10 | P a g e
MODULES USED IN
THE PROJECT
MySQL connector: -
We can connect MySQL and python using this module. Add
record in MySQL using this module.

11 | P a g e
 DESIGN WORK - MIND MAP
TO ADD EMPLOYEE
TO ADD NEW
ADMISSION

TO DISPLAY DETAILS
OF ALL STUDENTS

TO DISPLAY A RECORD OF A TO UPDATE

TO UPDATE RECORD
PARTICULAR EMPLOYEE OFDATA
STUDENT’S A STUDENT

TO ISSUE A TO ISSUE A TRANSFER

CERTIFICATE
TRANSFER CERTIFICATE

TO ADD STUDENT
MARK DETAIL

TO DISPLAY
STUDENTS REPORT
CARD
TO ADD A STUDENT’S
TO DISPLAY STUDENT
WISE THE
TO MODIFY REPORT CARD
PARTICULAR EMPLOYEE
TO PAY FEES OF A
TO DISPLAY PAYROLL STUDENT

TO DISPLAY FEES
TO DISPLAY RECEIPT
SALARY SLIP
FOR ALL THE EMPLOYEES

TO DISPLAY STUDENT
TO DISPLAY
WISE SALARY SLIP
FEES RECEIPT
FOR A PARTICULAR
TO DISPLAY A HELP
MESSAGE
12 | P a g e
 SYSTEM DEVELOPMENT
LIFE CYCLE – SDLC
Every computer based system has a life cycle. System development
starts when management or sometimes system development personnel
feel that a new system or an improvement in the existing system is
required. The system development life cycle is classically thought of as
the set of activities that analysis, designers and user carry to develop
and implement an information system.

Steps Follow in System Development Life Cycle is:

1. Preliminary Survey or Investigation.

2. Feasibility Study

3. System Analysis

4. Design of Software

5. Development of software

6. System Testing

7. Implementation and evaluation

8. Maintenance

13 | P a g e
Preliminary Survey

One of the most difficult tasks to the system analyst is identifying the real problem of the
existing system. Without clear understanding of the problem in the system, any further
work done will lead to wastage of effort at a later stage.

In Preliminary Survey the analyst gets information about different source and find out
what are the objective of designing the proposed system i.e. what are requirement of
designing of the new software. In this we identified what are the problems in current
system to find out the drawback of current system and find out what are the best system
that full the requirement of a particular Business Enterprises.

Feasibility Study
In this step we examine the feasibility of the proposed system. This involves the costs
and benefits of the system. Initially a rough cost benefit analysis will be sufficient for the
top management to take a decision either in favour of or against the proposed system.

System design

When the system analyst decides that the requested system is feasible and the
management agrees to continue the development process, the next phase of SDLC is
determination of system requirements. This phase includes studying of existing system
in details and collecting data in order to find out the requirement of the users.

Implementation

In implementation, the designs are translated in to code. Computer programs are written
using a conventional programming language or application generator. Programming
tools like compilers, interpreters, debuggers are used to generate the code. Different
high-level languages like python, C, C++, Pascal, Java are used for coding.

14 | P a g e
PICTORIAL REPRESENTATION OF SDLC

Planning phase

The planning phase is the most critical step in completing development, acquisition, and
maintenance projects. Careful planning, particularly in the early stages of a project, is
necessary to coordinate activities and manage project risks effectively. The depth and formality
of project plans should be commensurate with the characteristics and risks of a given project.
Project plans refine the information gathered during the initiation phase by further identifying
the specific activities and resources required to complete aproject.
A critical part of a project manager’s job is to coordinate discussions between user, audit,
security, design, development, and network personnel to identify and document as many
functional, security, and network requirements as possible. During this phase, a plan is
developed that documents the approach to be used and includes a discussion of methods, tools,
tasks, resources, project schedules, and user input. A Project Management Plan is created with
components related to acquisition planning, configuration management planning, quality
assurance, planning, concept of operation.

15 | P a g e
Requirements analysis phase

This phase formally defines the detailed functional user requirements using high-level
requirements identified in the Initiation, System Concept, and Planning phases. It also
delineates the requirements in terms of data, system performance, security, and
maintainability requirements for the system. The requirements are defined in this phase to
a level of detail sufficient for systems design to proceed. They need to be measurable,
testable, and relate to the business need or opportunity identified in the Initiation Phase.
The requirements that will be used to determine acceptance of the system are captured in
the Test and Evaluation Master Plan.
The purposes of this phase are to:

Further define and refine the functional and data requirements and document them in
the Requirements Document,
Complete business process reengineering of the functions to be supported (i.e., verify
what information drives the business process, what information is generated, who
generates it, where does the information go, and who processes it),
Develop detailed data and process models (system inputs, outputs, and the process.
Develop the test and evaluation requirements that will be used to determine acceptable
system performance.

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 script programs during the development phase. Program designs are
constructed in various ways. Using a top-down approach, designers first identify and link major
program 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.

16 | P a g e
 Developing a conversion plan to migrate current data to the new system.
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 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 by Agency 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.

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 program. Effective 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.

Testing as a deployed system with end users working together with contract personnel

17 | P a g e
Implementation phase

This phase is initiated after the system has been tested and accepted by the user. In this phase,
the system is installed to support the intended business functions. System performance is
compared to performance objectives established during the planning phase. Implementation
includes user notification, user training, installation of hardware, installation of software onto
production computers, and integration of the system into daily work processes. This phase
continues until the system is operating in production in accordance with the defined user
requirements.

Operations and maintenance phase

The system operation is ongoing. The system is monitored for continued performance in
accordance with user requirements and needed system modifications are incorporated.
Operations continue as long as the system can be effectively adapted to respond to the
organization’s needs. When modifications or changes are identified, the system may re-enter
the planning phase.

The purpose of this phase is to:

Operate, maintain, and enhance the system.

Certify that the system can process sensitive information.
Conduct periodic assessments of the system to ensure the functional
requirements continue to be satisfied.
Determine when the system needs to be modernized, replaced, or retired.

Integration and test phase

Subsystem integration, system, security, and user acceptance testing is conducted during the
integration and test phase. The user, with those responsible for quality assurance, validates
that the functional requirements, as defined in the functional requirements document, are
satisfied by the developed or modified system. OIT Security staff assesses the system security
and issue a security certification and accreditation prior to installation/implementation.

Multiple levels of testing are performed, including:

Testing at the development facility by the contractor and possibly supported by end users
.

18 | P a g e
SOURCE CODE

19 | P a g e
SOURCE CODE:

import [Link]
# GLOBAL VARIABLES DECLARATION
myConnection = ""
cursor = ""
userName = ""
password = ""

# MODULE TO CHECK MYSQL CONNECTIVITY

def MYSQLconnectionCheck():
global myConnection
global userName
global password

myConnection=[Link](host="localhost",user="root”,
passwd="", database="SMS",auth_plugin='mysql_native_password')

if myConnection:
print("\n CONGRATULATIONS ! YOUR MYSQL CONNECTION HAS BEEN
ESTABLISHED !")
cursor = [Link]()
[Link]("CREATE DATABASE IF NOT EXISTS SMS")
[Link]("COMMIT")
[Link]()
return myConnection
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION CHECK USERNAME
AND PASSWORD !")

# MODULE TO ESTABLISH MYSQL CONNECTION

def MYSQLconnection():
global userName

20 | P a g e
 global password
global myConnection

myConnection=
[Link](host="localhost",user="root",passwd="",database
="SMS",auth_plugin='mysql_native_password')

if myConnection:
return myConnection
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
[Link]()

# MODULE FOR NEW ADMISSION

def newStudent():
if myConnection:
cursor = [Link]()
createTable = """CREATE TABLE IF NOT EXISTS STUDENT(
SNAME VARCHAR(30),
FNAME VARCHAR(30),
MNAME VARCHAR(30),
PHONE VARCHAR(12),
ADDRESS VARCHAR(100),
SCLASS VARCHAR(5),
SSECTION VARCHAR(5),
SROLL_NO VARCHAR(5),
SADMISSION_NO VARCHAR(10) PRIMARY KEY)
"""
[Link](createTable)

sname = input("\n ENTER STUDENT'S NAME : ")

fname = input(" ENTER FATHER'S NAME : ")
mname = input(" ENTER MOTHER'S NAME : ")
phone = input(" ENTER CONTACT NO. : ")
address = input(" ENTER ADDRESS : ")
sclass = input(" ENTER CLASS : ")
21 | P a g e
 ssection = input(" ENTER SECTION : ")
sroll_no = input(" ENTER ROLL_NO : ")
sadmission_no = input(" ENTER ADMISSION_NO : ")

sql = "INSERT INTO

student(SNAME,FNAME,MNAME,PHONE,ADDRESS,SCLASS,SSECTION,SROLL_NO,SAD
MISSION_NO) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
values = (sname, fname, mname, phone, address, sclass, ssection,
sroll_no, sadmission_no)
[Link](sql, values)
[Link]("COMMIT")
[Link]()
print("\nNew Student Enrolled Successfully !")
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")

# MODULE TO DISPLAY STUDENT'S DATA

def displayStudent():
cursor = [Link]()
if myConnection:
[Link]("SELECT * FROM STUDENT")
data = [Link]()
print(data)
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")

# MODULE TO UPDATE STUDENT'S RECORD

def updateStudent():
cursor = [Link]()
if myConnection :
admission_no = input("ENTER ADMISSION NO")
sql = "SELECT * FROM STUDENT WHERE SADMISSION_NO= %s"
[Link](sql, (admission_no,))
data = [Link]()
if data:
22 | P a g e
 print("PRESS 1 FOR NAME")
print("PRESS 2 FOR CLASS")
print("PRESS 3 FOR ROLL NO")
choice = int(input("Enter Your Choice"))
if choice == 1:
name = input("ENTER NAME OF THE STUDENT :")
sql = "UPDATE STUDENT SET SNAME= %s WHERE SADMISSION_NO = %s"
[Link](sql, (name, admission_no))
[Link]("COMMIT")
print("NAME UPDATED")
elif choice == 2:
std = input("ENTER CLASS OF THE STUDENT :")
sql = "UPDATE STUDENT SET SCLASS= %s WHERE SADMISSION_NO= %s"
[Link](sql, (std, admission_no))
[Link]("COMMIT")
print("CLASS UPDATED")
elif choice == 3:
roll_no = int(input("ENTER ROLL NO OF THE STUDENT :"))
sql = "UPDATE STUDENT SET SROLL_NO= %s WHERE SADMISSION_NO = %s"
[Link](sql, (roll_no, admission_no))
[Link]("COMMIT")
print("ROLL NO UPDATED")
else:
print("Record Not Found, Try Again !")
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")

# MODULE TO ENTER MARKS OF THE STUDENT

def marksStudent():
if myConnection :
cursor = [Link]()
createTable = """CREATE TABLE IF NOT EXISTS MARKS(
SADMISSION_NO VARCHAR(10) PRIMARY KEY,
HINDI INT,
ENGLISH INT,
23 | P a g e
 MATH INT,
SCIENCE INT,
SOCIAL INT,
COMPUTER INT,
TOTAL INT,
AVERAGE DECIMAL)
"""
[Link](createTable)
admission_no = input("ENTER ADMISSION NO OF THE STUDENT : ")
hindi = int(input("\n ENTER MARKS OF HINDI : "))
english = int(input("\n ENTER MARKS OF ENGLISH : "))
math = int(input("\n ENTER MARKS OF MATH : "))
science = int(input("\n ENTER MARKS OF SCIENCE : "))
social = int(input("\n ENTER MARKS OF SOCIAL : "))
computer = int(input("\n ENTER MARKS OF COMPUTER : "))
total = hindi + english + math + science + social + computer
sql = "INSERT INTO
MARKS(SADMISSION_NO,HINDI,ENGLISH,MATH,SCIENCE,SOCIAL,COMPUTER,TOTAL)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s)"
values = (admission_no, hindi, english, math, science, social,
computer, total, )
[Link](sql, values)
[Link]("COMMIT")
[Link]()
print("\nMarks of the Student Entered Successfully !")
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
# MODULE TO GENERATE REPORT CARD OF ALL STUDENTS
def reportCardAllStudent():
cursor = [Link]()
if myConnection:
[Link]("SELECT * FROM MARKS")
data = [Link]()
print(data)
[Link]()
else:
24 | P a g e
 print("\nSomething Went Wrong, Please Try Again !")

# MODULE TO GENERATE REPORT CARD OF ONE STUDENT

def reportCardOneStudent():
cursor = [Link]()
if myConnection :
admission_no = input("ENTER ADMISSION NO OF THE STUDENT : ")
cursor = [Link]()
sql = "SELECT * FROM MARKS WHERE SADMISSION_NO= %s"
[Link](sql, (admission_no,))
data = [Link]()
if data:
print(data)
else:
print("Record Not Found, Please Try Again !")
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")
# MODULE TO ENTER FEES OF THE STUDENTS
def feeStudent():
if myConnection:
cursor = [Link]()
createTable = """CREATE TABLE IF NOT EXISTS FEES(
SADMISSION_NO VARCHAR(10) PRIMARY KEY,
MONTH INT,
TUTION_FEES INT,
VVN INT,
COMPUTER_FEES INT,
MUSIC_FEES INT,
TOTAL INT)
""" [Link](createTable)
admission_no = input("ENTER ADMISSION NO OF THE STUDENT : ")
month = int(input("\n ENTER MONTH IN NUMERIC FORM (1-12) : "))
tutionfee = int(input("\n ENTER TUTION FEES : "))
vvn = int(input("\n ENTER VVN : "))
computerfee = int(input("\n ENTER COMPUTER FEES : "))
25 | P a g e
 musicfee = int(input("\n ENTER MUSIC FEES : "))
total = tutionfee + vvn + computerfee + musicfee
sql = "INSERT INTO
FEES(SADMISSION_NO,MONTH,TUTION_FEES,VVN,COMPUTER_FEES,MUSIC_FEES,TOTAL)
VALUES(%s,%s,%s,%s,%s,%s,%s)"
values = (admission_no, month, tutionfee, vvn, computerfee,
musicfee, total)
[Link](sql, values)
[Link]("COMMIT")
[Link]()
print("\nFees of Student Accepted Successfully !")
else:
print("\nERROR ESTABLISHING MYSQL CONNECTION !")
# MODULE TO GENERATE FEES RECEIPT OF ALL STUDENTS
def feeReceiptAllStudent():
cursor = [Link]()
if myConnection:
[Link]("SELECT * FROM FEES")
data = [Link]()
print(data)
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")

# MODULE TO GENERATE FEES RECEIPT OF ONE STUDENT

def feeReceiptOneStudent():
cursor = [Link]()
if myConnection:
admission_no = input("ENTER ADMISSION NO OF THE STUDENT : ")
cursor = [Link]()
sql = "SELECT * FROM FEES WHERE SADMISSION_NO= %s"
[Link](sql, (admission_no,))
data = [Link]()
if data:
print(data)
else:
26 | P a g e
 print("Record Not Found, Please Try Again !")
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")
# MODULE TO ISSUE TRANSFER CERTIFICATE
def transferStudent():
cursor = [Link]()
if myConnection :
admission_no = input("ENTER ADMISSION NO OF THE STUDENT : ")
cursor = [Link]()
sql = "SELECT * FROM STUDENT WHERE SADMISSION_NO= %s"
[Link](sql, (admission_no,))
data = [Link]()
if data:
sql = ("DELETE FROM STUDENT WHERE SADMISSION_NO=%s")
[Link](sql, (admission_no,))
[Link]("COMMIT")
print("Student's Transfer Certificate Generated !!!")
else:
print("Record Not Found, Please Try Again !")
[Link]()
else:
print("\nSomething Went Wrong, Please Try Again !")

# MODULE TO PROVIDE HELP FOR USER

def helpMe():
print("Please, Visit The Official Website Of School To Download The
Manual !!!")
# MAIN SCREEN OF THE SYSTEM
print("#############################################################"
)
print("\n\t\t\t\t| WELCOME |")
print("\n\t\t\t| SCHOOL MANAGEMENT |")
print("\n|-----------------------------------------------------------
---|")
print("##########################################################")
27 | P a g e
 # STARTING POINT OF THE SYSTEM
myConnection = MYSQLconnectionCheck()
if myConnection is True:
MYSQLconnection()
while True:
print("|---------------------------------------------------------
----|")
print("| Enter 1 - New Admission. |")
print("| Enter 2 - Display Student's Data. |")
print("| Enter 3 - Update Students's Data . |")
print("| Enter 4 - Issue Transfer Certificate . |")
print("| Enter 5 - Add Student's Marks Detail. |")
print("| Enter 6 - Generate All Student's Report Card. |")
print("| Enter 7 - Generate Student Wise Report Card. |")
print("| Enter 8 - Pay Student's Fee. |")
print("| Enter 9 - Generate Student Wise Fees Receipt. |")
print("| Enter 10 - Generate Student's Fee Receipt. |")
print("| Enter 11- Exit. |")
print("|---------------------------------------------------------
----|")
print("| Enter 0(ZERO) - Help. |")
print("|---------------------------------------------------------
----|")
choice = int(input("PLEASE ENTER YOUR CHOICE : "))
if choice == 1:
newStudent()
elif choice == 2:
displayStudent()
elif choice == 3:
updateStudent()
elif choice == 4:
transferStudent()
elif choice == 5:
marksStudent()
elif choice == 6:
reportCardAllStudent()
28 | P a g e
 elif choice == 7:
reportCardOneStudent()
elif choice == 8:
feeStudent()
elif choice == 9:
feeReceiptAllStudent()
elif choice == 10:
feeReceiptOneStudent()
elif choice == 11:
[Link]()
break
elif choice == 0:
helpMe()
else:
print("Sorry, Maybe You Are Giving Me Wrong Input, Please Try
Again !!!")
else:
print("Check Your MYSQL Connection First !!!")

29 | P a g e
OUTPUT SCREENSHOTS

30 | P a g e
Main Menu

To enter a student’s data

31 | P a g e
To display all the students’ data

To update a student’s data

To generate transfer certificate for a student

32 | P a g e
To enter marks of a student

To display marks of all students

To display marks of particular student

33 | P a g e
To pay students fees

To display fees of all students

To display fees of particular student

34 | P a g e
To Exit

MySQL Table: student

35 | P a g e
MySQL Table: marks

MySQL Table: fees

36 | P a g e
 SYSTEM TESTING &
MAINTENANCE
Testing can be define as the project of executing the project in a controlled manner. In
order to answer the question" does the project behave as specified" .It also is then only
way of finding out whether or not there are any error in a [Link] testing is an
important part of SDLC.

Like all other stages of SDLC, testing too needs time and proper resources to become
meaningful [Link] is vital to the success of the system. Testing make a logical
assumption that if all parts of the system are correct, the goal will be successfully
achieved.

TYPES OF TESTING

Unit testing:-each component or part of the program is tested individually to verify that
the detail design for unit has been correctly implemented.
Module testing:- In large system a module may be a group of several programs or
functions or sub-module testing.
Integration testing:- It is carried out to find problem in the interface between
resembled units module in a system.
System testing:-It is executing a program to check logic changes made in it
and with the intention of finding errors.
MAINTENANCE:

After the implementation, the systems need to be maintained in order to adapt the
changing business and user needs. Different techniques are used to properly maintain a
system like:

[Link] – correction means to find out the error of the existing system and then
correctthem.
[Link] – Adaptation means changes are done in existing software according the
requirement of the newenvironment.
37 | P a g e
 CONCLUSION

To conclude with, the software presents the user with the system that satisfies
all the objectives of the organization. The system developed presents the user
with the major benefits of user-friendliness, security, and hardware
independence. Its data is also used to generate the reports that are needed by
the client of this system.

38 | P a g e
 BIBLIOGRAPHY

In order to work on this project titled – Online bus ticketing system, the
following books and literature are referred by me during the various
phases of development of the project.

Science with python – BY Sumita Arora

[Link]
Computer [Link]
[Link]/download

39 | P a g e