KAMARAJ INTERNATIONAL ACADEMY (CBSE)

SENIOR SECONDARY SCHOOL

083-COMPUTER SCIENCE PROJECT REPORT

Topic: SCHOOL MANAGEMENT SYSTEM BY USING

PYTHON My-SQL CONNECTIVITY

Submitted by
S. AHILASH
20678612
XII

A Report of the project

Submitted to the
Senior School Certificate Examination
Central Board of Secondary Education,
New Delhi
 BONAFIDE CERTIFICATE

Certified that this project report titled “SCHOOL MANAGEMENT

SYSTEM BY USING PYTHON My-SQL CONNECTIVITY” is the
bonafide work of [Link] of class XII during the academic year
2025-2026, submitted for the Computer Science Practical Examination.

SIGNATURE SIGNATURE
Dr.K.R. Sasikala [Link].,[Link].,Ph.D Mrs. Syed Ali Fathima [Link].,[Link].,

PRINCIPAL PGT COMPUTER SCIENCE

KAMARAJ INTERNATIONAL ACADEMY KAMARAJ INTERNATIONAL ACADEMY

Submitted for the Viva voce examination held on ………………

INTERNALEXAMINER EXTERNALEXAMINER
 TABLE OF CONTENTS

[Link] DESCRIPTION
01 ACKNOWLEDGEMENT

02 INTRODUCTION

03 OBJECTIVES

04 HARDWARE & SOFTWARE REQUIREMENTS

05 PYTHON LIBRARY MODULES

06 FUNCTIONS

07 SOURCE CODE

08 OUTPUT
09 CONCLUSION

10 BIBLIOGRAPH
 ACKNOWLEDGEMENT

I take this opportunity to put record our sincere thanks to all who
enlightened my path towards the successful completion of this project.
At the very outset, I thank the almighty for this abundant blessings
showered on me.

It is my greatest privilege to convey my thanks to

[Link] [Link].,[Link].,Ph.D Principal, Kamaraj International
Academy(CBSE) for having provided me with all required facilities to
complete my project without hurdles.
I thank my guide Mrs. [Link] Ali Fathima [Link].,[Link]., PGT
Computer Science for his excellent guidance patiently throughout my
project work and for having helped me with excellent suggestions and
hints, which facilitated my task very much.
I also bound to thank the other staff members of the Kamaraj
International Academy (CBSE), whose support and cooperation also
contributed much to complete this project work.
INTRODUCTION
 Introduction:
In the era of digital transformation, the efficient management of educational
institutions is crucial for smooth operations and enhanced productivity. A School
Management System plays a pivotal role in streamlining various administrative
tasks, reducing manual efforts, and ensuring seamless communication between
stakeholders.

Our School Management System, developed using the versatile Python

programming language and powered by MySQL for robust database management,
is designed to revolutionize the way educational institutions handle their day-to-
day operations.

 Student Information Management: Easily manage student records,

including personal details, academic performance, attendance, and more.
 Teacher and Staff Management: Keep track of teacher and staff
information, monitor their schedules, and facilitate effective
communication.
 Attendance Tracking: Automate attendance tracking for students and staff,
reducing paperwork and minimizing errors.
 Gradebook and Exam Management: Efficiently manage grades, conduct
exams, and generate comprehensive reports for better academic analysis.
 Fee Management: Streamline fee collection, generate invoices, and keep
transparent records of financial transactions.
 Communication Hub: Foster seamless communication between teachers,
parents, and students through integrated messaging features.
 Library Management: Organize and manage the school library efficiently,
including book tracking, issuance, and returns.
 Event Scheduling: Plan and schedule school events, examinations, and
extracurricular activities effortlessly.
OBJECTIVES
 Objectives:
The main objective of a School Management System
(SMS) is to streamline and enhance the overall administration and academic
processes within an educational institution. The system aims to provide a centralized
platform for efficient management of various activities, fostering a collaborative
environment and improving communication among stakeholders. Well-organized,
efficient, and collaborative environment that enhances the overall educational
experience for students, teachers, and parents, while also simplifying administrative
tasks for school administrators. Here are the main objectives of a School
Management System.

 Student Information Management

 Academic Performance Tracking

 Employee and Payroll Management

 Data Analysis and Reporting

HARDWARE &
SOFTWARE
REQUIREMENTS
HARDWARE AND SOFTWARE REQUIREMENTS :

Operating system Windows 7 and above

Processor Pentium(any) or AMD

Motherboard 1.845 or 915995 for Pentium or MSI

K9MM-V VIAK8M800+8237R plus
chipset for AMD ATHALON
Ram 512MB+

Hard disk SATA 40GB or above

CD/DVDr/w If backup required

multi drive
Combo
Software Python3X,MYSQL

Monitor 14.1 or 15-17 inch

Keyboard & Required wired or wireless

Mouse
Printer If print is required-[Hard copy]

OS Windows, linux , ios

Software Python 3.x, MySQL
PYTHON LIBRARY
MODULES
Python Libraries Modules:
 import mysqlconnector : It is used for the
connectivity of the python interface with
mysql.
FUNCTIONS
Functions:
1. connect( ):To create a connection between the MySQL database and the
python application.

2. is_connected( ):Reports whether the connection to the MySQL server

is available or not it returns True when the connection is

available,False otherwise .

3. cursor( ) : They are bound to the connection for the entire life time
and all the commands are executed in the context of the database

session wrapped by the connection .

4. execute( ):It is used to execute the MySQL queries in python .

5. fetchall( ):The method fetches all (or all remaining ) rows of query
result set and returns a list of tuples if no more rows available it

returns an empty list.

6. fetchone( ):This method retrieves the next row of a query result set and
returns a single sequence, or None if no more rows are available.
7. rowcount: It returns the numbers of rows affected by the last execute( )
method for the same cursor( ) object and thus returns one further first

cursor( ).

8. commit( ):The commit( ) method is used to make sure the

changes made to the database or consistent.

9. quit( ):This method sends a QUIT command to the MySQL server,

closing the current connection .
SOURCE CODE
Source code:
import [Link] as a
con=[Link](host="localhost",user="root",password="CSLab@KiaKvp"
,database="mysql")
def ast():
n=input("ENTER THE NAME OF STUDENT")
c=input("ENTER THE CLASS OF STUDENT")
r=int(input("ENTER THE ROLL NUMBER"))
a=input("ENTER THE ADDRESS")
p=int(input("ENTER THE PHONE
NUMBER"))
data=(n,c,r,a,p)
sql='insert into student values(%s,%s,%s,%s,%s)'
c=[Link]()
[Link](sql,data)
[Link]()
print("Data entered successfully")
print("> ")
main()
def rst():
c=input("class name:")
r=int(input("Roll number:"))
data=(c,r)
sql='delete from student where c =%s and r=%s'
c = [Link]()
[Link](sql,data)
[Link]()
print("Data Updated")
print("> ")
main()
def addt():
n=input("Teacher:")
p=input("post:")
s=int(input("salary:"))
 ph=int(input("phone:"))
ac=int(input("account:"))
data=(n,p,s,ph,ac)
sql='insert into teacher values(%s,%s,%s,%s,%s)'
c= [Link]()
[Link](sql,data)
[Link]()
print("Data Entered Successfully")
print("> ")
main()
def remt():
n=input("Teacher name :")
ac=int(input("Account No:"))
data=(n,ac)
sql='delete from teacher where n = %s and ac =%s'
c= [Link]()
[Link](sql,data)
[Link]()
print(" Data Updated")
print("> ")
main()
def abclass():
d=input("date:")
cl=input("Class:")
ab=input("Name Of Absent Student")
data=(d,cl,ab)
sql='insert into cattendance values(%s,%s,%s)'
c=[Link]()
[Link](sql,data)
[Link]()
print("Data Updated")
print("> ")
main()
def abteacher():
d=input("date:")
ab=input("Names Of Absent Teacher")
data=(d,ab)
sql='insert into tattendance values(%s,%s)'
c=[Link]()
[Link](sql,data)
[Link]()
print("Data Updated")
print("> ")
main()
def submitf():
n=input("student name:")
c=input("class name :")
r=int(input("roll no."))
m=input("months and
year") f=int(input("fess:"))
d=input("date:")
data=(n,c,r,m,f,d)
sql='insert into fees values(%s,%s,%s,%s,%s,%s)'
c=[Link]()
[Link](sql,data)
[Link]()
print("Data Entered Successfully")
print("> ")
main()
def pays():
n=input("Teacher
name:")
m=input("months:")
p=input("Yes/No:")
data=(n,m,p)
sql='insert into salary values(%s,%s,
%s)' c=[Link]()
[Link](sql,data)
 [Link]()
print("Data Entered Successfully")
print("> ")
main()
def dclass():
c=input("class:")
data=(c,)
sql='select*from student where c=%s'
c1=[Link]()
[Link](sql,data)
c1=[Link]()
print(c1)
for i in c1:
print("NAME:",i[0])
print("CLASS:",i[1])
print("ROLL:",i[2])
print("ADDRESS:",i[3])
print("PHONE:",i[4])
print("> <")
print("> ")
main()
def dteacher():
d="select*from teacher"
c=[Link]()
[Link](d)
c=[Link]()
for i in c:
print("NMAE:",i[0])
print("POST:",i[1])
print("SALARY:",i[2])
print("ADDRESS:",i[3])
print("ACNO:",i[4])
print("> <")
print("> ")
def main():
print(""" KAMARAJ
INTERNATIONAL ACADEMY(CBSE)
SENIOR SECONDARY SCHOOL, KOVILPATTI
/@@@@@@ AHILASH XII COMPUTER SCIENCE
PROJECT 2023-2024 @@@@@\

[Link] STUDENT [Link] STUDENT

[Link] TEACHER [Link] TEACHER
[Link] ATTENDANCE [Link]
ATTENDANCE
7. SUBMIT FEES
8. PAY SALARY
9. DISPLAY CLASS
[Link] LIST
""")
choice=input("Enter The NO. :")
print("> <")
if(choice=='1'):
ast()
elif(choice=='2'):
rst()
elif(choice=='3'):
addt()
elif(choice=='4'):
remt()
elif(choice=='5'):
abclass()
elif(choice=='6'):
abteacher()
elif(choice=='7'):
submitf()
elif(choice=='8'):
pays()
 elif(choice=='9'):
dclass()
elif(choice=='10'):
dteacher()
else:
print("Wrong choice................")
main()
def pswd():
p=input("Password:")
if p=="12345":
main()
else:
print("Wrong Password:")
pswd()
pswd()
OUTPUT
Output:
.
CONCLUSION
Conclusion:
Developing a School Management System (SMS) using Python and
MySQL connectivity can offer a powerful and versatile
solution for educational institutions. The
combination of Python, a versatile and easy-to-understand programming
language, and MySQL, a robust relational database management system,
provides an effective platform for creating a feature-rich SMS. In
conclusion, the use of Python and MySQL in an SMS offers several advantages.
This program was successfully executed without any lag and met all our
expectations and in future it will help to improve some applications. This is the
end of the project. We’ve explored the big ideas of composition of functions,
functions as data, recursion, and sequential programming. As a review, you
might ensure that our project has something special. The project had been
completed due to the hard efforts taken by us and we had faced many difficulties
while doing
this project. This was a great experience for us in learning.
BIBLIOGRAPHY
Bibliography:
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 Computer science with Python by Sumita
Arora CLASS-XII
 Computer science with Python by Preeti Arora
CLASS-XII

*********THANK YOU*********