SCHOLAR DATA MANAGEMENT
SYSTEM
PROJECT REPORT
Submitted By
NARAIN SHARVESH. A
KABILAN S.T.
SURYA VISHAKAN P.S.
THE INDIAN PUBLIC SCHOOL
ERODE 638112
2024 - 2025
CERTIFICATE
CERTIFICATE
This is to certify that the project work entitled “SCHOLAR
DATA MANAGEMENT SYSTEM” is the bonafide record of
work done by NARAIN SHARVESH. A, Exam No:
in partial fulfillment of the requirement for the award of the 12th
standard during the academic year 2024- 2025.
Viva voce held on:
Internal examiner External examiner
Principal
ACKNOWLEDGEMENT
ACKNOWLEDGEMENT
We are over whelmed in all humbleness and
gratefulness to acknowledge our depth to all those who
have helped us to put these ideas, well above the level
of simplicity and into something concrete.
We are very thankful to our principal Mr.ATUL
RUNTHALA and our guide
Mrs. Sudha for her valuable help. She was always
there to show us the right track when we needed her
help. With the help of her valuable suggestions,
guidance, and encouragement, we were able to perform
this project work.
We would also like to thank our classmates and family
members, who often helped and gave us support at critical
junctures during the making to the project " SCHOLAR
DATA MANAGEMENT SYSTEM" using PYTHON.
CONTENTS
CONTENTS
S.No TOPIC Page No.
1. Synopsis 07
2. Sample code 09
3. Sample screen 16
4. Bibliography 21
SYNOPSIS
SYNOPSIS
This project "SCHOLAR DATA MANAGEMENT SYSTEM" has
been developed to effectively maintain the database of student's
academic performance. The computerized system has been developed
in the
The Indian Public School, Erode. The computerized Student data
management system is user friendly and it provides many features.
The details of the students are maintained in a record. This project
can also be used in various applications where there is need of
maintenance of records. The test data have proved that the result
generated by the software are accurate and has been tested with
test data.
This system is divided into five modules
The first module deals with adding student details in a record.
The second module deals with modifying student details in a
existing record using roll no.
The third module deals with deleting student details in a existing
Record using roll no.
The fourth module deals with searching the student details
using their roll number.
The fifth module deals with listing all the records in the student
data management system.
SAMPLE CODE
SCHOLAR DATA MANAGEMENT
SYSTEM
import os
import mysql.connector as a
con=a.connect(host=”localhost”,user=”scott”,password=”password”,
database=”tips”)
c=con.cursor()
c.execute(“create table student(rollno int PRIMARY KEY,name
varchar(30),mark int)’)
# ADD NEW RECORD
def addrecord():
print("Add a new Record")
print(“===============”)
r=int(input('Enter rollno='))
n=input('Enter name=')
m=float(input('Enter marks='))
c.execute(insert into student(rollno,name,marks) values {},’{}’,
{}.format(r,n,m))
con.commit()
print("Record
Saved")
input("Press any key to continue..")
# MODIFY EXISTING RECORD
def modifyrecord():
print ("Modify a Record")
print(“===========”)
r=int(input(“Enter roll no to be modified:”))
n=input(“Enter new name:”)
m=int(input(“Enter new marks:”))
c.execute(“update students set name=’{}’,marks={} where rollno is
{}.format(n,m,r)”)
con.commit()
input("Press any key to continue..")
# DELETE EXISTING RECORD
def deleterecord():
deln=int(input(“Enter roll no to be deleted”))
c.execute(“delete from students where rollno is {}.format(deln)”)
con.commit()
input("Press any key to continue..")
# SEARCH EXISTING RECORD
def search():
print("Search a Record")
print("==================")
r=input('Enter rollno you want to search:')
c.execute(“select * from students where rollno is {}.format(r)”)
l=c.fetchone()
print(l)
input("Press any key to continue..")
# VIEW ALL EXISTING RECORDS
def viewall():
print("List of All Records”)
print(“============”)
c.execute(“select * from students”)
l=c.fetchall()
for i in l:
print(i)
input("Press any key to continue..")
# MAIN MENU
def mainmenu():
choice=0
while choice!=6:
print("\n") print("Main Menu")
print("==============")
print("1.Add a new Record")
print(“2.Modify a Record”)
print(‘3.Delete Existing Record')
print(“4.Search a Record”)
print(“5.View all Record”)
print(“6.Exit”)
choice=int(input('Enter your choice:'))
if choice==1:
addrecord()
elif choice==2:
modifyrecord()
elif choice==3:
deleterecord()
elif choice==4:
search()
elif choice==5:
viewall()
elif choice==6:
print("Software Terminated")
con.close()
break
mainmenu()
SAMPLE SCREEN
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:1
Add a new Record
=================
Enter rollno=11
Enter name=Yamuna
Enter marks=415
Record Saved
Press any key to continue..
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:2
Modify a Record
=================
Enter roll no you want to modify:11
Enter new name: Yamuna
Enter new marks: 416
Record Modified
Press any key to continue..
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:3
Enter rollno you want to delete:4
Record Deleted
Press any key to continue..
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:4
Search a Record
==================
Enter rollno you want to search:9
(9,Sakshi,14)
Press any key to continue..
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:5
List of All Records
==============
(1,Aparna,495)
(2,Archana,472)
(3,Arun,483)
(5,Jay,489)
(6,Neha,443)
(7,Newton,387)
(8,Pankaj,435)
(9,Sakshi,497)
(10,Sruthi,375)
(11,Yamuna,416)
Main Menu
==============
1.Add a new Record
2. Modify Existing Record
3. Delete Existing Record
4. Search a Record
5. List all Records
6. Exit
Enter your choice:6
Software Terminated
BIBLIOGRAPHY
BIBLIOGRAPHY
Source: Internet
> www.google.com
> www.python.org
>www.w3schools.com
>www.tutorialspoint.com
BOOKS REFERRED
> Computer Science with Python -Class
XII (By: Sumita Arora)
THANK YOU
