Computer Science

Project Work

STUDENT MANAGEMENT
DATABASE

NAME-KUMAR SAKSHAM
CLASS- XII-A
ROLL NO-12111
 CERTIFICATE
This is to certify that Kumar Saksham of class: XII
A of Bal Bharati Public School has done her
Project on STUDENT MANAGEMENT SYSTEM
under my supervision. She has taken interest and
has shown at most Sincerity in completion of this
project.
I certify this project up to my expectation & as
per guidelines issued by CBSE, NEW DELHI.

Internal Examiner External Examiner

Principal
 ACKNOWLEDGEMENT
It is with pleasure that I acknowledge my
Sincere gratitude to our teacher, MRS. Preeti
Tandon who taught and Undertook the
responsibility of teaching the subject computer
science. I have been greatly benefited from hes
classes.
I am especially indebted to our Principal MRS.
Swapna Nair who has always been a source of
encouragement and support And without whose
inspiration this project would not have been a
successful I would like to place on record
heartfelt thanks to her.

Finally, I would like to express my Sincere

appreciation for all the other Students for my
batch their friendship & the fine time that we all
shared Together.
 AIM
The aim of this project is to develop a Student Management
System using Python and SQL that automates the
management of student records in educational institutions.
The system is designed to streamline operations such as
adding, updating, searching, and deleting student details,
providing a user-friendly and efficient alternative to manual
record-keeping.
This system aims to achieve the following objectives:
1萏ː萑 옕퀁 葞ː葠 .耀 Simplify Student Record Management:
‫ﺘ‬ ‫؂‬ ‫ﺘ‬

Enable administrators to manage student details (e.g., name,

age, class) efficiently using a centralized database.
2萏ː萑 옕퀁 葞ː葠 .耀 Improve Data Accuracy: Minimize human
‫ﺘ‬ ‫؂‬ ‫ﺘ‬

errors by automating tasks like searching for students or

updating information.
3萏ː萑 옕퀁 葞ː葠 .耀 Enhance Accessibility: Provide an intuitive
‫ﺘ‬ ‫؂‬ ‫ﺘ‬

interface to quickly access and manage student records.

4萏ː萑 옕퀁 葞ː葠 .耀 Save Time: Eliminate repetitive tasks such as
‫ﺘ‬ ‫؂‬ ‫ﺘ‬

manually maintaining student data, allowing administrators

to focus on more critical responsibilities.
5萏ː萑 옕퀁 葞ː葠 .耀 Secure and Organized Data Storage: Leverage
‫ﺘ‬ ‫؂‬ ‫ﺘ‬

SQL for secure and structured storage of student

information, ensuring data integrity.
By combining Python for programming and SQL for robust
database management, this system offers a reliable and
practical solution for managing student records in a way that
is scalable and adaptable for institutions of all sizes.

INTRODUCTION
Managing student records is a critical
aspect of any educational institution.
Traditionally, this process has been
handled manually, involving large
amounts of paperwork and time-
consuming operations. However, in the
modern era, where technology plays a
pivotal role in streamlining operations,
an automated solution is essential to
manage student data efficiently.
The Student Management System is a
software application developed using
Python and SQL. It is designed to
automate and simplify the management
of student records by providing an
intuitive platform for administrators to
perform tasks such as adding, updating,
viewing, and deleting student
information.
This project leverages Python for its
simplicity and flexibility in programming
and SQL for secure and efficient database
management. The system ensures that all
student information is stored in a
structured and organized manner,
making it easy to retrieve and update as
required.
Key features of this system include:
Adding and updating student details such
as name, age, and class.
Searching for students by name or class
for quick access to records.
Deleting records of students who have
graduated or left the institution.
Viewing all student data in an organized
format.
The Student Management System not
only enhances the efficiency of managing
student records but also reduces the risk
of errors and data loss associated with
manual record-keeping. It serves as a
reliable and scalable solution, adaptable
for use in schools, colleges, and other
educational institutions.
This project demonstrates how
technology can be applied to solve real-
world administrative challenges,
providing a practical tool for managing
student data while fostering digital
transformation in educational
environments.
Python Source Code

Import mysql.connector as con

#To search students from student details

#table.
Def search_student():
Print(“*****************STUDENT
DETAILS***********************”)
K=input(“Enter name to search student Name : “)

D=con.connect(host=”localhost”,user=”root”,passwor
d=”Saksham@99711”,database=”STUDENT_MANAGE
MENT_SYSTEM”)
C=d.cursor()
c.execute(“select*from STUDENT_DETAILS
where NAME like ‘%{}%’”.format(k))
a=c.fetchall()
if len(a)>=1:
 for i in a:
print(“Addmission no:”,i[0])
print(“Name is:”,i[1])
print(“Sex:”,i[2])
print(“Class=”,i[3])
print(“Sec:”,i[4])
print(“Phone number is=”,i[5])
print(“Email_id:”,i[6])
print(“Stream is:”,i[7])
else:
print(“Student Details Not Found”)
d.commit()
#To update details of students from student details
table.

Def update_details():

D=con.connect(host=”localhost”,user=”root”,passwor
d=”Saksham@99711”,database=”STUDENT_MANAGE
MENT_SYST EM”)
C=d.cursor()
 Print(“1. Update Name”)
Print(“2. Update Gender”)
Print(“3. Update class”)
Print(“4. Update Section”)
Print(“5. Update Phone no.”)
Print(“6. Update E-mail id”)
Print(“7. Update Stream”)
Opt=int(input(“Enter your choice to update”))
If opt==1:
Q=input(“Enter ADDMISSION_NUMBER whose
data you want to update: “)
L=input(“Enter your updated name: “)
c.execute(“update STUDENT_DETAILS set
NAME=’{}’ where
ADDMISSION_NUMBER={}”.format(l,q))
d.commit()
elif opt==2:
p=input(“Enter name whose data you want to
update: “)
l=input(“Enter your updated Gender: “)
 c.execute(“update STUDENT_DETAILS set
SEX=’{}’ where name=’{}’”.format(l,p))
d.commit()
elif opt==3:
m=input(“Enter name whose data you want to
n=input(“Enter your updated class: “)
c.execute(“update STUDENT_DETAILS set CLASS={}
where name=’{}’”.format(n,m))
d.commit()

elif opt==4:
y=input(“Enter name whose data you want to
update: “)
e=input(“Enter your updated section: “)
c.execute(“update STUDENT_DETAILS set SEC=’{}’
where name=’{}’”.format(e,y))
d.commit()

elif opt==5:
h=input(“Enter name whose data you want to
r=input(“Enter your updated phonenumber: “)
 c.execute(“update STUDENT_DETAILS set
PHONE_NUMBER={} where name=’{}’”.format(r,h))
d.commit()
elif opt==6:
j=input(“Enter name whose data you want to
update: “)
k=input(“Enter your updated email_id : “)
c.execute(“update STUDENT_DETAILS set
EMAIL_ID=’{}’ where name=’{}’”.format(k,j))
d.commit()

elif opt==7:
f=input(“Enter name whose data you want to
z=input(“Enter your updated stream : “)
c.execute(“update STUDENT_DETAILS set
STREAM=’{}’ where NAME=’{}’”.format(z,f))
d.commit()
else:
update_details()
 #To display the marks of students from student
details table .

Def view_Marks():
Print(“******************* VIEW STUDENT
DETAILS******************”)
K=input(“Enter name to view student details : “)

D=con.connect(host=”localhost”,user=”root”,passwo
r
d=”Saksham@99711”,database=”student_managem
ent_system”
)

C=d.cursor()
c.execute(“select*from STUDENT_DETAILS where
NAME like ‘%{}%’”.format(k))
s=c.fetchall()
for i in s:
print(“MARKS:”,i[8])
d.commit()
 #To insert details to student details table

Def add_student():
Print(“.................. ADD STUDENT
DETAILS......................”)

N=input(“Enter student name : “)

A=int(input(“Enter student admission number: “))
R=input(“Enter gender of student: “)
I=int(input(“Enter class of student:”))
P=input(“Enter student section : “)
T=int(input(“Enter student phone number:”))
W=input(“Enter student stream: “)
U=input(“Enter your mail id:”)
M=int(input(“Enter your marks:”))

D=con.connect(host=”localhost”,user=”root”,passwo
r
d=”admin”,database=”STUDENT_MANAGEMENT_SY
ST EM”)
C=d.cursor()
 Sq=”insert into STUDENT_DETAILS
values({},’{}’,’{}’,{},’{}’,{},’{}’,’{}’,
{})”.format(a,n,r,i,p,t,u, w,m)
c.execute(sq)
d.commit()
print(“student data added successfully”)
#To delete items from student details table Def
delete_student():
Print(“******************** DELETE STUDENT
DETAILS*******************”)
K=input(“Enter name to DELETE student details : “)
D=con.connect(host=”localhost”, user=”root”,
password
d=”Saksham@9971”,database=”STUDENT_MANAGE
MENT_SYST EM”)
C=d.cursor()
c.execute(“delete from STUDENT_DETAILS where
name=’{}’”.format(k))
print(“.........Data deleted successfully..........”)
d.commit()
def admin(): while True:
print(“***************WELCOME TO STUDENT
MANAGEMENT *****************”)
print(“1.search student details”)
print(“2.update student details”)
print(“3.view student details”)
print(“4.add student details”)
print(“5.delete student details”)
print(“6.exit”)
ch=int(input(“your choice: “))
if ch==1:
search_student()
elif ch==2:
update_details()
elif ch==3:
view_Marks()
elif ch==4:
add_student()
elif ch==5:
 delete_student()
elif ch==6:
break
else :
print(“invalid input”)

def user(): while True:

print(“***************WELCOME TO STUDENT
MANAGEMENT **************”)
print(“1.search your Details”)
print(“2.view Details”)
print(“3.exit”)
ch=int(input(“what is your choice: “))
if ch==1:
search()
elif ch==2:
view_Marks()
elif ch==3:
 break
else:
print(“invalid input”)

#To search students from student details table.

Def search():
Print(“*****************STUDENT
DETAILS***********************”)
K=input(“Enter name to search student details: “)

D=con.connect(host=”localhost”,user=”root”,passwo
rd=”Saksham@99711”,database=”STUDENT_MANAG
EMENT_SYST EM”)
C=d.cursor()
c.execute(“select*from STUDENT_DETAILS where
NAME like ‘%{}%’”.format(k))
a=c.fetchall()
if len(a)>=1:
for i in a:
print(“Addmission no:”,i[0])
 print(“Name is:”,i[1])
print(“Sex:”,i[2])
print(“Class=”,i[3])
print(“Sec:”,i[4])
print(“Phone number is=”,i[5])
print(“Email_id:”,i[6])
print(“Stream is:”,i[7])
print(“----------------------------------------------------“)
else:
print(“Student Details Not Found”)
d.commit()
#To display the marks of students from student
details table .

Def view_Marks():
Print(“******************* VIEW STUDENT
DETAILS******************”)
K=input(“Enter name to view student details : “)
D=con.connect(host=”localhost”,user=”root”,passwo
r
d=”Saksham@99711”,database=”student_managem
ent_system”
)
C=d.cursor()
c.execute(“select*from STUDENT_DETAILS where
NAME like ‘%{}%’”.format(k))
s=c.fetchall()
for i in s:
print(“MARKS:”,i[8])

print(“-----------------------------------------------------“)
d.commit()

while True:
print(“**************WELCOME TO STUDENT
MANAGEMENT*****************”)
print(“1.admin”)
print(“2.user”)
print(“3.exit”)
ch=int(input(“login through: “))
if ch==1:
admin()
elif ch==2:
user()
elif ch==3:
break
else:
print(“invalid input”)
 MySQL DATABASES

STUDENT MANAGEMENT SYSTEM DATABASE AND

STUDENT DETAILS TABLE:-
/

ADD STUDENT FROM STUDENT _DETAILS TABLE:

#Added a new student in student details table named
PRITI SHARMA
/
 Updated Student Class From STUDENT_DETAILS
Table:
/

#updated the class of student name SALONI from class

12 to class 11.

Updated Student Stream From STUDENT_DETAILS

Table:
/

/
#updated the Stream of student name SALONI from
SCIENCE to ARTS.

DELETE STUDENT FROM STUDENT _DETAILS TABLE:

/

#Deleted the Details of student name PRITI SHARMA

from STUDENT_ DETAILS TABLE.
OUTPUTS
 #User Panel and Admin Panel:
/

#search Student Details:

/

#Update student Details:

##Name:
/

##Gender:
 /

##Class:
/
##Section:
/

##Stream:
/

#View Mark of student :

/

#Add student Details:

/
#Delete Student Details:
/