PM SHRI KENDRIYA VIDYALAYA

SIDDHARTHNAGAR
COMPUTER SCIENCE INVESTIGATORY
PROJECT

SUbMITTED bY:-
PANKAJ MADDHESHIYA
CLASS xII A
(2023-24)
ROLL NO:-

1
TABLE OF CONTENTS
Certificate

Undertaking

Acknowledgement

Synopsis & System Requirements

Introduction

About Python & MySQL

Database Design

Coding

Outputs

Limitations & Future Enhancement

Bibliography

2
 Certificate

This is to certify that PANKAJ MADDHESHIYA of class

XII (A) Science, PM Shri Kendriya Vidyalaya
Siddharthnagar, have successfully completed his
project “Student Management System” in computer
science practical for the AISSCE as prescribed by CBSE
in the year 2023-24.
Date :
Roll No. :

_____________________
Signature of Principal

___________________ ___________________
Signature of Internal Signature of External
Examiner Examiner

3
 Undertaking

I declare that the work presented in this project titled

STUDENT MANAGEMENT SYSTEM, submitted to Mr.
D. K. Jaiswal (PGT- Computer Science), PM Shri
Kendriya Vidyalaya Siddharthnagar for the award of
the CBSE – AISSCE class XII certificate. I have not
plagiarized or submitted the same work for the award
of any other examination. In case this undertaking is
found incorrect, we accept that our Certificates may
be unconditionally withdrawn.

4
 Acknowledgement

It would be my utmost pleasure to express my sincere

thanks to my Principal Shri Niraj Kumar Shukla sir for
his valuable guidance and motivation. I would also
give my sincere thanks to my Computer Science
Teacher Mr. D K Jaiswal (PGT CS) sir, for providing a
helping hand in this project. His valuable guidance,
support and supervision all through this project titled
“Student Management System”, are responsible for
attaining its present form. This project has been made
not only for fetching marks but also for knowledge.
Finally, I would like to thank CBSE for giving me this
opportunity to undertake this project.

____________________
(Signature of Student)
PANKAJ MADDHESHIYA

5
 SYNOPSIS
The main objective of the Student Management
System is to manage the details of students admitted
in the schools. Various details will be entered and
saved in permanent record storage. It manages all
the information of the students like roll no., name,
birth year etc. It will also manage the student’s
attendance record. The project is totally built at
administrative end and thus only the administrator
is guaranteed the access. The purpose of the project
is to build an application program to reduce the
manual work for managing the student’s details. At
initial level this project will handle the organized
details of the student’s details. At the later stage, its
functionality may be enhanced.
The program will do multiple tasks like creating a
new record, searching records on various
parameters, deleting the details based on
parameters. We have decided that this project
should be easily used by the user so it will be user
friendly.
This project will be containing many functions and
features of Python as front end. Also, MySQL will

6
be used as database back end. I have planned to
add more updates in future to make it more
efficient and usable by our teachers.

SYSTEM REQUIREMENTS

HARDWARE REQUIRED

 Printer, to print the required documents of the

project
 Pen Drive
 Processor : AMD
 RAM : 4 GB
 Hard Disk : 1 TB.

SOFTWARE REQUIRED

 Operating system : Windows 10

 Python 3.6.7 – IDLE
 MySQL
 MS Word, for presentation

7
 INTRODUCTION

Student Management System project is written

in Python. The project file contains a python
script (index.py). This is a simple GUI based
project which is very easy to understand and
use. Talking about the system, it contains all
the required functions which include adding,
viewing, deleting and searching the records.
This is the report of the coursework designed
to produce a system or an application that
handles Student Management System. This
software application has capability of this
system is to add student, view all student, delete
student, update info etc.
This new technology system will make users
face fewer problems than the previous days.
The old methods of Student Management
System create more problem like damage of
files, Time consuming etc. This system is user
8
friendly and time efficient and help to avoid the
unnecessary duplication of the data and make it
easy to search, view and understand. The main
feature of this project is that it will enable the
user to understand the integrated development
and learning environment and help them to use
the system fullest. It will incorporate Python
features with MySQL database connectivity.
The Student Management System serves
several essential purposes in the context of
educational institutions:
1. **Efficient Data Management:**
- Enables the systematic storage and retrieval
of student information.
- Facilitates easy organization and tracking of
student records.
2. **Automation of Administrative Tasks:**
- Automates the process of entering and
updating student details, reducing manual
efforts.
- Streamlines administrative tasks such as data
entry, retrieval, and deletion.
9
3. **Accuracy and Consistency:**
- Ensures the accuracy and consistency of
student data by avoiding manual errors.
- Provides a standardized format for data
entry, minimizing discrepancies.
4. **Quick Information Retrieval:**
- Allows for rapid retrieval of student details
based on various criteria.
- Enhances the efficiency of administrators
and educators in accessing relevant
information.
5. **Attendance Monitoring:**
- Tracks student attendance, making it easier
to identify patterns and trends.
- Enables the identification of students who
are consistently present or absent.
6. **User-Friendly Interface:**
- Provides a user-friendly interface for easy
interaction, making it accessible to users with
varying technical expertise.

10
 - Enhances usability, ensuring that
administrators, teachers, and staff can navigate
and utilize the system effectively.

7. **Customization and Flexibility:**

- Allows customization of student data fields
to adapt to specific institutional requirements.
- Offers flexibility in searching for students
based on different parameters.
8. **Time Efficiency:**
- Saves time for administrators and educators
by automating routine tasks.
- Reduces the time required for managing
and organizing student information manually.
9. **Data Security:**
- Incorporates security measures to protect
sensitive student information.
- Ensures that only authorized personnel have
access to certain functionalities.
10. **Reporting and Analysis:**

11
 - Supports the generation of reports for
analyzing student data trends.
- Provides insights into attendance patterns,
academic performance, and other relevant
metrics.

In summary, the Student Management System

is designed to enhance the overall efficiency of
educational institutions by providing a
centralized platform for managing student
information. It contributes to improved
accuracy, time savings, and better decision-
making based on data analysis.

12
 ABOUT PYHTON & MySQL

Python is an interpreted language as python

programs are executed by an interpreter. Thus,
Python interpreter should be installed on the
computer system to write and run python programs.
We have also learnt that Python IDLE (Integrated
Development and Learning Environment) provides
two working modes interactive mode (popularly
known as python shell) and script mode.

SQL (Structured Query Language) is a standard

language for accessing and manipulating database.
SQL commands are used to create, transform and
retrieve information from Relational Database
Management System (RDMS) and to create an
interface between user and database. By using SQL
commands, one can search for any data, remove
rows, drop table etc.

13
 Database Design
In the program we have MySQL functions for
using database queries in the program. In this
program we have used database for Name of
the person, Gender, Age, Address, Contacts.
Then this will be stored in the database calling
it in the function of the database command.
The users will be asked their details to be filled.
We have make the program that no detail
should be empty every detail should be filled
according to it.

TAbLE: Member

14
MySQL Connector module provides connectivity
and access to the MySQL server and databases for
client programs. It is written in pure Python and
does not have any dependencies except for the
Python Standard Library. It allows us to create a
cursor and perform functions like execute() ,
add_attribute() , clear_attribute() , close() and many
more.
Python time module is used to create time related
tasks in the programs. It provides direct functions
which can be used to display time in different units
and various ways such as strings, numbers. It also
has related functions to format the programs based
on time such as sleep function.

15
 CODING

# A Computer Science Project by KV SDDN

# of class 12th on "Student Managment System" using Python and MySQL

import mysql.connector
mydb = mysql.connector.connect(host ="localhost",user ="root",passwd ="kvsddn")
mycur = mydb.cursor()
mycur.execute("create database if not exists student_db1")
mycur.execute("use student_db1")
abc="Y"
print(" ================================= \n =================================
\n STUDENT MANAGEMENT SYSTEM :: KV SDDN \n =================================
\n ================================= \n \n")

def while_fn():
while abc=="Y" or abc=="y":
if menu==1 :
userinput()
elif menu==2 :
search_fn()
menu_fn()
elif menu==3:
delete_fn()
menu_fn()

def userinput():
16
 roll=str(input("Enter roll no. of the student : "))
name=str(input("Enter name of the student : "))
dob=str(input("Enter year of birth of the student : "))
att=str(input("Enter attendence of the student P/A : "))
creat_tb = "create table if not exists student_tb ( sroll varchar(30) primary key, sname
varchar(30), sdob varchar(30), satt varchar(30))"
mycur.execute(creat_tb)
colum_tb = "insert into student_tb (sroll, sname, sdob, satt) values
('"+roll+"','"+name+"','"+dob+"','"+att+"')"
mycur.execute(colum_tb)
mydb.commit()
mycur.execute("select * from student_tb")
result = mycur.fetchall()
print(" All details of students \n")
print("|| roll no || name || birth year || attendence || ")
for x in result:
print(x)
global abc
abc = input("do you want to continue adding student ? [Y/N] : ")

def search_fn():
menu2=int(input(" ================================= \n [1] Searching by roll no. \n
[2] search by name \n [3] search by birth year \n [4] search present student \n [5] search
absebt student \n [6] main menu \n =================================\n:"))
if menu2==1 :
print("==================== \n [1] Searching by roll no. \n====================")
search=str(input("Enter roll no. of student :"))
mycur.execute("select * from student_tb where sroll='"+search+"'")
result = mycur.fetchall()
print("|| roll no || name || birth year || attendence ||
\n=====================================\n")

17
 for x in result:
print(x)
elif menu2==2 :
print("==================== \n [2] Searching by name \n====================")
search=str(input("Enter name of student :"))
mycur.execute("select * from student_tb where sname='"+search+"'")
result = mycur.fetchall()
print("\n || roll no || name || birth year || attendence ||
\n=====================================\n")
for x in result:
print(x)
elif menu2==3 :
print("==================== \n [3] Searching by birth year
\n====================")
search=str(input("Enter birth year of student :"))
mycur.execute("select * from student_tb where sdob='"+search+"'")
result = mycur.fetchall()
print("|| roll no || name || birth year || attendence ||
\n=====================================\n")
for x in result:
print(x)
elif menu2==4 :
print("==================== \n [4] Searching present student
\n====================")
mycur.execute("select * from student_tb where satt='P'")
result = mycur.fetchall()
print("\n || roll no || name || birth year || attendence ||
\n=====================================\n")
for x in result:
print(x)
elif menu2==5 :

18
 print("==================== \n [5] Searching absent student
\n====================")
mycur.execute("select * from student_tb where satt='A'")
result = mycur.fetchall()
print("\n || roll no || name || birth year || attendence ||
\n=====================================\n")
for x in result:
print(x)
elif menu2==6 :
menu_fn ()
def delete_fn():
menu3=int(input(" ================================= \n [1] Deleting by roll no. \n
[2] Deleting by name \n =================================\n:"))
if menu3==1 :
print("==================== \n [1] Deleting by roll no. \n====================")
roll=str(input("Enter roll no. of the student to be deleted : "))
mycur.execute("delete from student_tb where sroll='"+roll+"'")
print("record deleted of roll no." , roll)

elif menu3==2 :
print("==================== \n [2] Deleting by name \n====================")
name=str(input("Enter name of the student to be deleted : "))
mycur.execute("delete from student_tb where sname='"+name+"'")
print("record deleted of name" , name)

def menu_fn() :
global menu

19
 menu=int(input("====\n press [1] for entry of new student \n press [2] for searching
student \n press [3] for deleting student details
\n====================================\n :"))
while_fn()
print(abc)

menu_fn()

while_fn()

20
 OUTPUTS
MAIN MENU

NEW ENTRY

21
SEARCHING

SEARCHING BY ROLL NO.

22
SEARCHING BY NAME

SEARCHING BY BIRTH YEAR

23
PRESENT STUDENTS DETAILS

ABSENT STUDENTS DETAILS

24
DELETE

DELETING BY ROLL NO.

25
DELETING BY NAME

26
 LIMITATIONS & FUTURE
ENHANCEMENTS

We have tried our best to do this program but

we have found some Drawbacks in the
program.
The following are the Drawbacks of the
program: Limitations
We can add only the name of the students
as it is named as student management
system it should contain a capacity of
storing multiple values of a student.
Future enhancement:
As the limitations say future enhancement
will be based on storing multiple details of a
student.
Better look and feel features.
Removing data related issues.
This can perform online tasks.
27
 BIBLIOGRAPHY

1. www. python.org
2. www.mysql.com
3. www.google.com
4. Computer Science with Python by
Preeti Arora.
5. Computer Science with Python by
Sumita Arora.

28