DIVINE GURUKULAM

THE TRADITIONAL SCHOOL

COMPUTER SCIENCE PROJECT

Project Name: Students Record Managaement System

Name : Nishith Patel

Roll No.: 54
Class :12th - B
Session:2024-2025

1
 CERTIFICATE
This is to certify that Nishith Patel of class XII science
has prepared the Computer Science project entitled
Student Record Management System for class XII
practical examination of Central Board of Secondary
Education (CBSE) for the year 2024-25.
It is further certified that this project is the work of
Nishith Patel under the guidance of Mrs. Mamta Kohar
The report is the result of their sincere efforts and
endeavours.

PRINCIPAL INTERNAL EXTERNAL

EXAMINER EXAMINER

2
 ACKNOWLEDGEMENT
I would like to extend my sincere and heartfelt gratitude
to the Trustee, Mr. Kiran Vadilal Mirani and Director,
Mrs. Hetal Mirani of Divine Gurukulam the Traditional
School for their support in completing this project.
I also wish to express my deep gratitude and sincere
thanks to the Principal, [Link] Sarkar for providing
me with encouragement and all the facilities for this
project work. I sincerely appreciate this magnanimity by
taking me into their fold for which I shall remain
indebted to them.
I would like to express my special thanks to our mentor
Mrs. Mamta Kohar for her time and efforts she
provided throughout the year. Your useful advice and
suggestions were really helpful to me during the project’s
completion. In this aspect, I am eternally grateful to you.
I would like to acknowledge that this project was
completed entirely by our group and not by someone else.

Signature
Nishith Patel

3
 TABLE OF CONTENTS

[Link] DESCRIPTION PAGE

NO.
1. INTRODUCTION 5
2. OBJECTIVE OF THE PROJECT 5

3. PROPOSED SYSTEM 6
4. SYSTEM DEVELOPMENT LIFE 7
CYCLE(SDLC)
5. PHASES OF SYSTEM 7
DEVELOPMENT LIFE CYCLE
6. SOURCE CODE 17

7. OUTPUT 29

8. HARDWARE AND SOFTWARE 40

REQUIRED
9. BIBLIOGRAPHY 40

4
 INTRODUCTION
This project is all about software for School. It helps the
teachers to manage students’ details. It adds a student,
updates an existing student’s details, deletes a student in
case of a TC, and ofcourse displays the details of
students.
The project scope is as follows:
 To come up with an efficient database management

application for student record management. The

application shall help to add in student records like
their personal information, fees-related information,
scholarship-related information, and course-related
information, and marks-related information.
 The application shall allow you to edit or delete any

student record based on authorized permission The

application shall allow generating reports like marks
statistics etc.
 The key information like a password shall be stored

in encrypted form for security purposes.

OBJECTIVES OF THE PROJECT

The objective of this project is to apply programming
knowledge into a real-world situation/problem and how
programming skills help in developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object-oriented programming principles
effectively when developing small to medium sized
projects.

5
3. Write effective procedural code to solve small to
medium sized problems.
4. Demonstrate a breadth of knowledge in computer
science, as exemplified in the areas of systems, theory
and software development.
5. Demonstrate ability to make applied Computer
Science project, requiring writing and presentation skills

PROPOSED SYSTEM
Today one cannot afford to rely on the fallible human
beings of be really wants to stand against today’s
merciless competition where not to wise saying “to err is
human” no longer valid, it’s outdated to rationalize your
mistake. So, to keep pace with time, to bring about the
best result without malfunctioning and greater efficiency
so to replace the unending heaps of flies with a much-
sophisticated hard disk of the computer. One has to use
the data management software. Software has been an
ascent in atomization various organizations. Many
software products working are now in markets, which
have helped in making the organizations work easier and
efficiently. Data management initially had to maintain a
lot of ledgers and a lot of paper work has to be done but
now software product on this organization has made their
work faster and easier. Now only this software has to be
loaded on the computer and work can be done. This
prevents a lot of time and money. The work becomes
fully automated and any information regarding the
organization can be obtained by clicking the button.
Moreover, now it’s an age of computers of and
automating such organization gives the better looks.

6
 SYSTEM DEVELOPMENT LIFE
CYCLE (SDLC)
The systems development life cycle is a project
management technique that divides complex projects into
smaller, more easily managed segments or phases.
Segmenting projects allows managers to verify the
successful completion of project phases before allocating
resources to subsequent phases.
Software development projects typically include
initiation, planning, design, development, testing,
implementation, and maintenance phases.
However, the phases may be divided differently
depending on the organization involved.
For example, initial project activities might be designated
as request, requirements-definition, and planning phases,
or initiation, concept- development, and planning phases.
End users of the system under development should be
involved in reviewing the output of each phase to ensure
the system is being built to deliver the needed
functionality.

PHASES OF SYSTEM
DEVELOPMENT LIFE CYCLE
The Initiation Phase begins when a business sponsor
identifies a need or an opportunity.
The purpose of the Initiation Phase is to:
a) Identify and validate an opportunity to improve
business accomplishments of the organization or a
deficiency related to a business need. ii) Identify

7
significant assumptions and constraints on solutions to
that need.

b) Recommend the exploration of alternative concepts

and methods to satisfy the need including questioning the
need for technology, i.e., will a change in the business
process offer a solution?

c) Assure executive business and executive technical

sponsorship. The Sponsor designates a Project Manager
and the business need is documented in a Concept
Proposal. The Concept Proposal includes information
about the business process and the relationship to the
Agency/Organization.

d) Infrastructure and the Strategic Plan. A successful

Concept Proposal results in a Project Management
Charter which outlines the authority of the project
manager to begin the project.

e)Careful oversight is required to ensure projects support

strategic business objectives and resources are effectively
implemented into an organization’s enterprise
architecture. The initiation phase begins when an
opportunity to add, improve, or correct a system is
identified and formally requested through the
presentation of a business case. The business case should,
at a minimum, describe a proposal’s purpose, identify
expected benefits, and explain how one of the proposed
system supports organization’s business strategies. The
business case should also identify alternative solutions
and detail as many informational, functional, and
network requirements as possible

8
 SYSTEM CONCEPT DEVELOPMENT
PHASE
The System Concept Development Phase begins after a
business need or opportunity is validated by the
Agency/Organization Program Leadership and the
Agency/Organization CIO.
The purpose of the System Concept Development Phase
is to:
 Determine the feasibility and appropriateness of the

alternatives.
 Identify system interfaces.

 Identify basic functional and data requirements to

satisfy the business need.

 Establish system boundaries; identify goals,
objectives, critical success factors, and performance
measures.
 Evaluate costs and benefits of alternative
approaches to satisfy the basic functional
requirements Assess project risks.
 Identify and initiate risk mitigation actions, and

Develop high-level technical architecture, process

models, data models, and a concept of operations.
This phase explores potential technical solutions
within the context of the business need.
 It may include several trade-off decisions such as

the decision to use COTS software products as

opposed to developing custom software or reusing
software components, or the decision to use an

9
 incremental delivery versus a complete, onetime
deployment.
 Construction of executable prototypes is encouraged
to evaluate technology to support the business
process. The as an important System Boundary
Document serves reference document to support the
Information Technology Project Request (ITPR)
process.
 The ITPR must be approved by the State CIO
before the project can move forward.
PICTORIAL REPRESENTATION OF
SDLC:

[Link] PHASE
The planning phase is the most critical step in
completing development, acquisition, and maintenance
projects. Careful planning, particularly in the early stages
of a project, is necessary to coordinate activities and
manage project risks effectively. The depth and formality
of project plans should be commensurate with the
characteristics and risks of a given project. Project plans
refine the information gathered during the initiation
phase by further identifying the specific activities and
resources required to complete a project.

10
A critical part of a project manager’s job is to coordinate
discussions between user, audit, security, design,
developed that documents the approach to be used and
includes a discussion of methods, tools, tasks, resources,
project schedules, and user input. Personnel assignments,
costs, project schedule, and target dates are established.
A Project Management Plan is created with components
related to acquisition planning, configuration
management planning, quality assurance planning,
concept 11 of operations, system security, verification
and validation, and systems engineering management
planning.
[Link] ANALYSIS PHASE
This phase formally defines the detailed functional user
requirements using high-level requirements identified in
the Initiation, System Concept, and Planning phases. It
also delineates the requirements in terms of data, system
performance, security, and maintainability requirements
for the system. The requirements are defined in this
phase to a level of detail sufficient for systems design to
proceed. They need to be measurable, testable, and relate
to the business need or opportunity identified in the
Initiation Phase. The requirements that will be used to
determine acceptance of the system are captured in the
Test and Evaluation Master Plan.
The purposes of this phase are to :
 Further define and refine the functional and data

requirements and document them in the

Requirements Document.
 Complete business process reengineering of the

functions to be supported (i.e., verify what

information drives the business process, what

11
 information is generated, who generates it, where
does the information go, and who processes it).
 Develop detailed data and process models (system
inputs, outputs, and the process.
 Develop the test and evaluation requirements that
will be used to determine acceptable system
performance.
[Link] PHASE
The design phase involves converting the informational,
functional, and network requirements identified during
the initiation and planning phases into unified design
specifications that developers use to script programs
during the development phase. Program designs are
constructed in various ways. Using a top-down approach,
designers first identify and link major program
components and interfaces, then expand design layouts
as they identify and link smaller subsystems and 12
connections. Using a bottom-up approach, designers first
identify and link minor program components and
interfaces, then expand design layouts as they identify
and link larger systems and connections. Contemporary
design techniques often use prototyping tools that build
mock-up designs of items such as application screens,
database layouts, and system architectures. End users,
designers, developers, database managers, and network
administrators should review and refine the prototyped
designs in an iterative process until they agree on an
acceptable design. Audit, security, and quality assurance
personnel should be involved in the review and approval
process. During this phase, the system is designed to
satisfy the functional requirements identified in the
previous phase. Since problems in the design phase could
be very expensive to solve in the later stage of the

12
software development, a variety of elements are
considered in the design to mitigate risk.
These include:
 Identifying potential risks and defining mitigating

design features.
 Performing a security risk assessment.

 Developing a conversion plan to migrate current

data to the new system.

 Determining the operating environment.

 Defining major subsystems and their inputs and

outputs.
 Allocating processes to resources.

 Preparing detailed logic specifications for each

software module. The result is a draft System

Design Document which captures the preliminary
design for the system.
 Everything requiring user input or approval is

documented and reviewed by the user. Once these

documents have been approved by the Agency CIO
and Business Sponsor, the final System Design
Document is created to serve as the
Critical/Detailed Design for the system.
 This document receives a rigorous review by

Agency technical and functional representative to

ensure that it satisfies the business requirements.
Concurrent with the development of the system
design, the Agency Project Manager begins
development of the Implementation Plan,
Operations and Maintenance Manual, and the
Training Plan.

13
 [Link] PHASE
The development phase involves converting design
specifications executable programs. Effective
development includes requirements that programmers
and other project participants discuss design
specifications before programming begins. The
procedures help ensure programmers clearly understand
program designs and functional requirements.
Programmers use various techniques to develop
computer programs. The large transaction-oriented
programs associated with financial institutions have
traditionally been developed using techniques.
Procedural programming
programming involves the line-by-line scripting of
logical instructions that are combined to form a program.
Effective completion of the previous stages is a key
factor in the success of the Development phase. The
Development phase consists of:
 Translating the detailed requirements and design

into system components.

 Testing individual elements (units) for usability.

 Preparing for integration and testing of the IT

system.
INTEGRATION AND TEST PHASE
Subsystem integration, system, security, and user
acceptance testing is conducted during the integration
and test phase. The user, with those responsible for
quality assurance, validates that the functional
requirements, as defined in the functional requirements
document, are satisfied by the developed or modified

14
system. OIT Security staff assesses the system security
and issue a security certification and accreditation prior
to installation/implementation.
Multiple levels of testing are performed, including:
*Testing at the development facility by the contractor
and possibly supported by end users.
*Testing as a deployed system with end users working
together with contract personnel
*Operational testing by the end user alone performs all
functions. Requirements are traced throughout testing, a
final Independent Verification & Validation
evaluation is performed and all documentation is
reviewed and accepted prior to acceptance of the system.
IMPLEMENTATION PHASE
This phase is initiated after the system has been tested
and accepted by the user. In this phase, the system is
installed to support the intended business functions.
System performance compared to performance
objectives established during the planning phase.
Implementation includes user notification, user training,
installation of hardware, installation of software onto
production computers, and integration of the system into
daily work processes. This phase continues until the
system is operating in production in accordance with the
defined user requirements.

OPERATIONS AND MAINTENANCE PHASE

The system operation is ongoing. The system is
monitored for continued performance in accordance with
user requirements and needed system modifications
incorporated. Operations continue as long as the system
can be effectively adapted to respond to the

15
organization’s needs. When modifications or changes are
identified, the system may renter the planning phase.
purpose of this phase is to:
 Operate, maintain, and enhance the system.

 Certify that the system can process sensitive

information.
 Conduct periodic assessments of the system to

ensure the functional requirements continue to be

satisfied.
 Determine when the system needs to be modernized,

replaced, or retired.

16
 SOURCE CODE
import [Link] as c
con=[Link](host='localhost',
user='root',
password='nishKOMAL2610',
database='project')
cursor=[Link]()
print("connection successful")

#to insert data into the table

def enter():
print("________________________
INSERT NEW CREDANTIALS__________________")

print("**********************************************
******************")
roll=int(input("enter the roll number of student:"))
name=input("enter the name of the student:")
sta=int(input("enter the standard of the student:"))
fee=int(input("enter the pending fees of the student:"))

e='insert into students values(%s,%s,%s,%s)'

c=(roll,name,sta,fee)
[Link](e,c)
[Link]()
print("data entered successfully")

#to display the data

def dis():
print("___________________STUDENTS RECORDS
2024-2025________________")

17
print("**********************************************
***************")
print("your result is being shown")
d='select * from students'
[Link](d)
d=[Link]()
for i in d:
print(i)
[Link]()

#to search the student information

def search():
print("__________________ENTER
THE CREDANTIAL________________________")

print("**********************************************
****************")
w=input("enter the roll number of the student:")
[Link]('select * from students where
Rno={}'.format(w))
print("********************************************
*******************")
print("__________________RETRIEVED
DATA_______________________________")

e=[Link]()
for i in e:
print("Roll number:",i[0])
print("Name of the student:",i[1])
print("Standard of the student:",i[2])
print("Fees of the student:",i[3])

18
 [Link]()

#to update the student information

def update():
print("________________UPDATE YOUR
CREDANTIALS__________________________")

print("**********************************************
*******************")
print("[Link] name")
print("[Link] standard")
print("[Link] pending fees amount")

f=int(input("what do you want to update?:"))

if f==1:
d=int(input("enter the roll number where you want to
update name:"))
r=input("enter the updated name:")

[Link]('update students set Name="{}"where

Rno={}'.format(r,d))

print("updation successful")
print("updated data:")
[Link]("select * from students where
Rno={}".format(d))
x=[Link]()
for i in x:
print("Roll number of the student is:",i[0])
print("Name of the student:",i[1])
print("Standard of student:",i[2])
print("Pending fee amount:",i[3])
[Link]()

elif f==2:

19
 i=int(input("enter the roll number where you want to
update standard:"))
j=input("enter the updated standard:")
[Link]('update students set standard={} where
Rno={}'.format(j,i))
print("updation successful")

print("updated data:")
[Link]("select * from students where
Rno={}".format(i))
t=[Link]()
for i in t:
print("Roll number of the student is:",i[0])
print("Name of the student:",i[1])
print("Standard of student:",i[2])
print("Pending fee amount:",i[3])

[Link]()

elif f==3:
m=int(input("enter the roll number where you want to
update fees:"))
n=input("enter the updated pending fees amount:")
[Link]('update students set fees={} where
Rno={}'.format(n,m))
print("updation successful")

print("updated data:")
[Link]("select * from students where
Rno={}".format(m))
q=[Link]()
for i in q:
print("Roll number of the student is:",i[0])
print("Name of the student:",i[1])
print("Standard of student:",i[2])
print("Pending fee amount:",i[3])

20
 [Link]()

#to delete student information

def remove():
print("______________________DELETE
INFORMATION_______________________")

print("**********************************************
*****************")
z=int(input("enter the roll number you want to delete
information:"))
[Link]('delete from students where
Rno={}'.format(z))
print("deletion successful")
print("The Updated Records are:")
[Link]('select * from students')
q=[Link]()
for i in q:
print(i)

[Link]()

#to work on student's marksheet

def marks():
print("____________________STUDENTS
MARKSHEET 2024-2025______________")

print("**********************************************
****************")
print("[Link] MARKS.")
print("[Link] MARKS")
print("[Link] MARKS")
print(“[Link] MARKS”)

c=int(input("enter your choice:"))

21
 if c==1:
print("_______________________ENTER THE
MARKS___________________________")

print("**********************************************
*******************")
roll=int(input("enter the roll number:"))
nam=input("enter the name of the student:")
eng=int(input("enter emarks of english:"))
mat=int(input("enter marks of mathematics:"))
sci=int(input("enter marks of science:"))
ss=int(input("enter marks of scoial studies:"))
comp=int(input("enter marks of computer science:"))
[Link]('insert into marks
values({},"{}",{},{},{},{},{})'.format(roll,nam,eng,mat,sci,ss,c
omp))

print("data insertion successful!")

[Link]('select * from marks')
a=[Link]()
for i in a:
print(i)
[Link]()

elif c==2:
print("________________________MAKSHEET 2024-
2025__________________________")

print("**********************************************
**********************")
[Link]('select * from marks')
z=[Link]()
from prettytable import PrettyTable

22
 table=PrettyTable(['Roll_no','Name','English','Maths','S
cience','Social studies','Computer'])

forRoll_no,Name,English,Maths,Science,Social_studie
s,Computer in z:

table.add_row([Roll_no,Name,English,Maths,Science,
Social_studies,Computer])
print(table)

[Link]()

elif c==3:
print("___________________________UPDATING
MARKS_____________________________")

print("**********************************************
************************")
g=int(input("enter the roll number of the student of
whom you want to update marks:"))
print("current marks entry for the student is:")

[Link]('select * from marks where

Roll_no={}'.format(g))
u=[Link]()
for i in u:

print("Name of the student:",i[1])

print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])
print("____________________________________________
___________________________")
print("1. Update english marks.")

23
 print("2. Update maths marks.")
print("3. Update science marks.")
print("4. Update social studies marks.")
print("5. Update computer science marks.")

w=int(input("your choice:?"))
#for english marks updation
if w==1:

eng=int(input("enter marks of english:"))

[Link]('update marks set
English={}'.format(eng))
[Link]('select * from marks where
Roll_no={}'.format(g))
s=[Link]()

print("______________________________________________
___________________________")
print("UPDATED RECORD")
for i in s:
print("Name of student:",i[1])
print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])

[Link]()

#for maths mark updation

elif w==2:

mat=int(input("enter marks of mathematics:"))

[Link]('update marks set
Maths={}'.format(mat))
[Link]('select * from marks where
Roll_no={}'.format(g))

24
 print("UPDATED RECORD")

print("______________________________________________
___________________________")
f=[Link]()
for i in f:
print("Name of student:",i[1])
print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])

[Link]()
#for science marks updation
elif w==3:
sci=int(input("enter marks of science:"))
[Link]('update marks set
Science={}'.format(sci))
[Link]('select * from marks where
Roll_no={}'.format(g))
s=[Link]()
for i in s:
print("Name of student:",i[1])
print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])
[Link]()

#for social studies marks updation

elif w==4:
ss=int(input("enter marks of social studies:"))
[Link]('update marks set
Social_studies={}'.format(ss))
l=[Link]()

25
 for i in l:
print("Name of student:",i[1])
print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])
[Link]()

#for computer marks updation

elif w==5:
com=int(input("enter marks of computer science:"))
p=[Link]('update marks set
Computer={}'.format(com))
for i in p:
print("Name of student:",i[1])
print("Marks in english:",i[2])
print("Marks in maths:",i[3])
print("Marks in science:",i[4])
print("Marks in social studies:",i[5])
print("Marks in computer:",i[6])

[Link]()
else:
print("invalid choice")

#to delete data from records

elif c==4:

print("______________________DELETE
INFORMATION_______________________")

print("**********************************************
*****************")

print("CURRENT DATA:")

26
 [Link]("select * from marks")
w=[Link]()
from prettytable import PrettyTable
table=PrettyTable(['Roll_no','Name','English','Maths',
'Science','Social studies','Computer'])

forRoll_no,Name,English,Maths,Science,Social_studies,
Computer in w:

table.add_row([Roll_no,Name,English,Maths,Science,
Social_studies,Computer])
print(table)

z=int(input("enter the roll number you want to delete

information:"))
[Link]('delete from marks where
Roll_no={}'.format(z))
print("deletion successful")
print("The Updated Records are:")
[Link]('select * from marks')
q=[Link]()

from prettytable import PrettyTable

tble=PrettyTable(['Roll_no','Name','English','Maths',
'Science','Social studies','Computer'])

forRoll_no,Name,English,Maths,Science,Social_studies,Co
mputer in q:

tble.add_row([Roll_no,Name,English,Maths,Science,
Social_studies,Computer])
print(tble)

[Link]()

27
 while True:
print("---------------------------------------------------------------")
print("______________WELCOME TO STUDENT
RECORDS_______________________")
print("---------------------------------------------------------------")

print("**********************MAIN
MENU********************************")
print("---------------------------------------------------------------")
print("[Link] Student Infromation")
print("[Link] Students Infromation")
print("[Link] Student Information")
print("[Link] Student Infromation")
print("[Link] Student Information ")
print("6. View Report Card")
print("[Link]")
print("---------------------------------------------------------------")

h=int(input("enter your choice:"))

if h==1:
enter()
elif h==2:
dis()
elif h==3:
search()
elif h==4:
update()
elif h==5:
remove()
elif h==6:
marks()

28
 OUTPUT
STUDENTS TABLE

MARKS TABLE:

ADDING RECORDS

29
ADDING RECORDS

30
 DISPLAYING RECORDS

SEARCHING RECORDS

31
SEARCHING RECORDS

UPDATING RECORDS

32
UPDATING RECORDS

33
DELETING RECORDS

34
 WORKING ON MARKSHEET
1. VIEWING MARKSHEET OF CLASS

35
2. ADDING MARKS OF STUDENT IN MARKSHEET

[Link] A MARKS ENTRY FROM RECORD

36
3. UPDATING MARKS IN STUDENT MARKSHEET

37
38
39
 Hardware Used
 OPERATING SYSTEM: WINDOWS 10
 PROCESSOR: Intel(R) Core(TM) i3-103561 CPU
 MOTHERBOARD: HP 8775 INTEL 495
 RAM: 8 GB
 Hard disk: SAMSUNG MZVLQ512HALU-
000H1[512 GB] CD/DVD r/w multi drive combo: (If
back up required)
 MONITOR: 14.1 or 15 -17 inch
 Key board and mouse

Software Used
→ Windows OS
→Python
→MySQL

Bibliography

 Computer science with python Class XI by Sumita Arora

Computer Science with Python Textbook for Class 11:Sumita
Arora:[Link]:Books

 Computer science with python Class XII by Sumita Arora

Computer Science with Python Textbook for Class 11:Sumita
Arora:[Link]:Books

40
41