Project
Project
PROJECT REPORT ON
SCHOOL MANAGEMENT SYSEM
Submitted by:
Shubham Kumar
XII-A
Computer Science (083)
Project Guide:
Mr. Lalit Bhardwaj
D.A.V. PUBLIC SCHOOL, KAILASH HILLS
CERTIFICATE
7. Output Screen 31
8. Bibliography 37
Acknowledgement
Apart from the efforts of me, the success of any project depends
largely on the encouragement and guidelines of many others. I take
this opportunity to express my gratitude to the people who have
been instrumental in the successful completion of this project.
I express deep sense of gratitude to almighty God for giving me
strength for the successful completion of the project. I express my
heartfelt gratitude to my parents for constant encouragement while
carrying out this project.
I gratefully acknowledge the contribution of the individuals who
contributed in bringing this project up to this level, who continues to
look after me despite my flaws.
I express my deep sense of gratitude towards Mrs. Ira Khanna, The
Principal, D.A.V. Public School Kailash Hills, for constant
encouragement and the guidance provided during this project.
I am overwhelmed to express my thanks to the Computer Science
Department for providing me an infrastructure and moral support
while carrying out this project in the school.
My sincere thanks to Mr. Lalit Bhardwaj, a guide, a Mentor and all
the above a friend, who critically reviewed my project and helped in
solving each and every problem, occurred during implementation of
the project.
The guidance and support received from all the members who
contributed to this project, was vital for the success of the project. I
am grateful for their constant support and help.
Introduction to School Management System
Abstract:
The technological advancements have influenced the society so as to take a leap towards
success every technological reform is a small step towards advancement and progress of
mankind. Developments in information Technologies have also been impacting upon
educational organization. The introduction of Technology in school can does result in a
decrease use of paper and bringing most of the school’s office work in an E-format thus the
schools should employ management information system to improve the efficiency of
Administrative Service. School management system is a system or a process that provides
the information necessary to manage school efficiently, they provide an objective system for
recording and aggregating information and supports the Institutions strategic goal and
direction administrative processes and official procedures of school can be simplified by the
means of management information system, school records information about all the
students teachers and other school employees, school’s financial issues etc. can be
efficiently maintained by means of school management information system which can
efficiently maintain the data retaining to examination issues faculties and management of
the institution to sum up School management information system not only is the office work
but also ensure the efficient functioning of the school it makes possible a more efficient way
of storage and distribution of information therefore realization of importance of
management information system in schools and its successful implementation is a message
City there is there is a dire need to employ subsystem to bring qualitative improvement in
the prevalent educational practices.
Python:
Python is an interpreted, high level, general-purpose high-level programming language.
Python's design philosophy emphasizes code readability with its notable use of significant
whitespace. Its language constructs and object-oriented approach aim to
help programmers write clear, logical code for small and large-scale projects.
Python is dynamically typed and it supports multiple object oriented, and functional
programming
The python language is one of the most accessible programming languages available
because it has simplified syntax and not complicated, which gives more emphasis on natural
language. Due to its ease of learning and usage, python codes can be easily written and
executed much faster than other programming languages.
My SQL:
MySQL is an open source Relational Database Management System (RDBMS. A relational
database organizes data into one or more data tables in which data types may be related to
each other; these relations help structure the data. SQL is a language that programmers use
to create, modify and extract data from the relational database, as well as control user
access to the database. In addition to relational databases and SQL, an RDBMS like MySQL
works with an operating system to implement a relational database in a computer's storage
system, manages users, allows for network access and facilitates testing database integrity
and creation of backups.
Tables:
Table structures:
Source Code:
#____________________Student Management____________________
def add_student():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
adm=int(input('Enter adm_no:'))
n=input('Enter name:')
s=input('Enter stream:')
g=input('Enter gender(M/F):')
m=input('Enter mobile no.:')
dob=input('Enter DOB(yyyy-mm-dd):')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def update_student():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
print('Update:\n1.Name\n2.Father\'s Name\n3.Stream\n4.Gender\n5.Mobile\n6.DOB')
adm=int(input('Enter adm_no:'))
if b==1:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==2:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==3:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==4:
try:
n=input('Enter gender(M/F):')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==5:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==6:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
def delete_student():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def show_student():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
x.execute("select*from student")
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==2:
try:
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
#____________________Employee Management____________________
def add_employee():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
e=int(input('Enter e_no:'))
n=input('Enter name:')
g=input('Enter gender(M/F):')
s=input('Enter Subject:')
dob=input('Enter DOB(yyyy-mm-dd):')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def update_employee():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
print('Update:\n1.Name\n2.Gender\n3.Subject\n4.Mobile\n5.DOB')
e=int(input('Enter e_no:'))
if b==1:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==2:
try:
n=input('Enter Gender(M/F):')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==3:
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==4:
try:
n=input('Enter Mobile:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif b==5:
try:
n=input('Enter DOB(yyyy-mm-dd):')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
def delete_employee():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def show_employee():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
x.execute("select*from employee")
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==2:
try:
e=int(input('Enter e no:'))
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
#____________________Exam Management____________________
def add_marks():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
e=input('English:')
p=input('Physics:')
c=input('Comp Sci:')
m=input('Math:')
ec=input('Economics:')
h=input('History:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def update_marks():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==2:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==3:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==4:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==5:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==6:
try:
n=input('Enter marks:')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def delete_marks():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def show_marks():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
x.execute("select*from exam")
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==2:
try:
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
#____________________Fees Management____________________
def add_fees():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def update_fees():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
a=int(input('Enter amount:'))
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def delete_fees():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def show_fees():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
x.execute("select*from fees")
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
elif a==2:
try:
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
else:
print('Invalid code')
#____________________Salary Management____________________
def add_salary():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
e=int(input('Enter e no:'))
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def update_salary():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
e=int(input('Enter e no:'))
a=int(input('Enter amount:'))
print('Done!!!')
except:
d.rollback()
print('Invalid')
def delete_salary():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
try:
d.commit()
print('Done!!!')
except:
d.rollback()
print('Invalid')
def show_salary():
import mysql.connector
d=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='dav')
x=d.cursor()
a=int(input('Enter choice:'))
if a==1:
try:
x.execute("select*from salary")
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
print('Invalid')
elif a==2:
try:
e=int(input('Enter e no:'))
y=x.fetchall()
for i in y:
print(i,sep='\n')
d.commit()
print('Done!!!')
except:
print('Invalid')
else:
print('Invalid code')
#---------------------------------------------------------------------------------------
#---------------------------------------------------------------------------------------
while True:
print()
print('1.Student Management')
print('2.Employee Management')
print('3.Exam Management')
print('4.Fees Management')
print('5.Salary Mangement')
print('6.Exit')
choice=int(input('Enter choice:'))
if choice==1:
while True:
print()
if c1=='a':
add_student()
print()
elif c1=='b':
update_student()
print()
elif c1=='c':
delete_student()
print()
elif c1=='d':
show_student()
print()
elif c1=='e':
break
else:
print('Invalid')
print()
elif choice==2:
while True:
print()
if c2=='a':
add_employee()
print()
elif c2=='b':
update_employee()
print()
elif c2=='c':
delete_employee()
print()
elif c2=='d':
show_employee()
print()
elif c2=='e':
break
else:
print('Invalid')
print()
elif choice==3:
while True:
print('b.Update Marks')
print()
if c3=='a':
add_marks()
print()
elif c3=='b':
update_marks()
print()
elif c3=='c':
delete_marks()
print()
elif c3=='d':
show_marks()
print()
elif c3=='e':
break
else:
print('Invalid')
print()
elif choice==4:
while True:
print()
if c4=='a':
add_fees()
print()
elif c4=='b':
update_fees()
print()
elif c4=='c':
delete_fees()
print()
elif c4=='d':
show_fees()
print()
elif c4=='e':
break
else:
print('Invalid')
print()
elif choice==5:
while True:
print()
if c5=='a':
add_salary()
print()
elif c5=='b':
update_salary()
print()
elif c5=='c':
delete_salary()
print()
elif c5=='d':
show_salary()
print()
elif c5=='e':
break
else:
print('Invalid')
print()
elif choice==6:
break
else:
print()
Output Screen
BIBLIOGRAPHY
Website: https://www.w3resource.com
Website: https://stackoverflow.com
Website: https://www.wikipedia.com