SCHOOL OF ENGINEERING
Department of Computer Science and Engineering
CERTIFICATE
This is to certify that the Cornerstone project work entitled “STUDENT RESULT
MANAGEMENT SYSTEM” is
submitted by
[Link] KRISHNA (25B21CS051)
[Link] (25B21CS052)
[Link] (25B21CS053)
[Link] TEJA (25B21CS054)
in partial fulfilment of the requirements for the award of the [Link]. degree in Computer Science
Technology for the academic year 2025-2026.
Project Guide Head of the Department
[Link] Ganesh Dr. T Sudha Rani , [Link]. , Ph.D
Assistant Professor, Assistant Professor,
Department of CSE Department of CSE
i
DECLARATION
We hereby declare that the Cornerstone project entitled “STUDENT RESULT
MANAGEMENT SYSTEM” is original and is submitted to ADITYA UNIVERSITY,
Surampalem, in partial fulfilment of the requirements for the award of the [Link]. degree
in Computer Science and Engineering. We further declare that this project work has not
been submitted, either in full or in part, for the award of any degree in this or any other
institution. We also confirm that this work complies with the Institutional Academic
Integrity and AI Usage Policy
Place: Surampalem
Date: 09-04-2026
By
[Link] KRISHNA (25B21CS051)
K.D.S.V MANIKANTA (25B21CS052)
[Link] (25B21CS053)
[Link] TEJA (25B21CS054)
ii
ACKNOWLEDGEMENT
It is with immense pleasure that we express our sincere gratitude to our Cornerstone
Project Guide, Mr. Mr [Link] Ganesh, Assistant Professor, who has guided us throughout the
project. His valuable support, encouragement, and guidance have greatly contributed to the
successful completion of this work.
We would like to thank our Deputy Heads of the Department, [Link] Sekhar,
Associate Professor and [Link] Jyothula, Associate professor, Department of CSE, for their
support and valuable suggestions.
Our deepest thanks to our Head of the Department [Link] Rani,Ph.D, Assistant Professor,
for her inspiration and for providing all the necessary facilities and resources required for this
project.
We also extend our sincere thanks to Dr. M.V. Rajesh, Associate Dean, School of
Engineering for their encouragement and support during the course of our project.
We would like to express our sincere gratitude to [Link],Registrar, Dr. A Ramesh,
Pro Vice-Chancellor (Engineering & Sciences), Dr. [Link] Sree , Pro Vice- Chancellor
(Academics), [Link], Vice-Chancellor, Dr. M. Sreenivasa Reddy,
Deputy Pro Chancellor and Management, Aditya University for providing excellent
infrastructure and state-of-the-art laboratories.
Finally, we would like to thank the faculty members, lab technicians, non-teaching staff,
and our friends who have directly or indirectly supported us in completing this
Cornerstone project successfully.
iii
Table of contents
CONTENTS PAGE NO
ABSTRACT i
LIST OF FIGURES ii
LIST OF TABLES iii
ACRONYMS iv
1. INTRODUCTION 1
1.1 Brief Information about the Project 1
1.2 Motivation and Contribution of Project 1
1.3 Objectives of the Project 1
1.4 Scope of the Project 2
2. SYSTEM ANALYSIS 3
2.1 Functional Requirements 3
2.2 Non-Functional Requirements 4
2.3 Requirements Specification 4
2.3.1 Minimum Hardware Requirements 4
2.3.2 Software Requirements 4
3. TECHNOLOGY DESCRIPTION 5
3.1 Programming Language 5
3.1.1 Introduction to Java 5
3.2 Framework / Libraries 5
3.2.1 Introduction to Swing 5
3.3 Database Technology 5
3.3.1 JDBC (Java Database Connectivity) 5
3.3.2 Oracle Database 5
3.4 Tools & IDEs 5
3.4.1 Visual Studio Code 6
4. DATABASE DESIGN 7
4.1 Database Tables 7
4.2 Table Structure 7
4.3 Keys and Constraints 8
4.4 Table Relationships 9
5. SYSTEM DESIGN 10
5.1 System Architecture 10
iv
5.2 Modules Description 10
6. SYSTEM IMPLEMENTATION 11
7. CONCLUSION 18
8. FUTURE ENHANCEMENTS 19
9. REFERENCES 20
APPENDIX (Sample Code) 22
APPENDIX (SQL Queries) 23
v
ABSTRACT
The Online Student Result Management System (SRMS) is a desktop/web-based
application developed to efficiently manage student examination results. The system
replaces traditional manual methods of result preparation with an automated solution,
reducing human errors and saving time. This application allows users to enter student
details and subject-wise marks through a user-friendly interface. It automatically
calculates total marks, percentage, and assigns grades based on predefined criteria. The
system ensures accurate and fast processing of student results. The project is developed
using Core Java for application logic, Swing for designing the graphical user interface,
JDBC for database connectivity, and Oracle/MySQL database for secure data storage.
The system provides functionalities such as adding student records, entering marks, and
displaying student performance. Overall, the system improves efficiency, accuracy, and
reliability in managing student results. It also provides secure and centralized data
storage, making it highly useful for educational institutions like schools and colleges. In
addition, the system provides efficient data management by allowing administrators to
add, update, and maintain student records easily. It ensures data consistency and reduces
redundancy through a centralized database. The application also enhances security by
implementing user authentication to prevent unauthorized access to student information.
It minimizes paperwork by storing all records digitally and enables quick calculation and
display of results in a structured format. Furthermore, the system can be extended in the
future to include additional features such as advanced reporting and performance analysis,
making it more flexible and scalable.
vi
LIST OF FIGURES
Figure No. Figure Title Page No.
1 Login Screen of Student Result 11
Management System
2 Main Menu Screen of Student Result 12
Management System
3 Student Details Entry Screen 13
4 Marks Entry Screen 14
5 Student Result Display Screen 15
6 Student Records View Screen 16
7 Student Result Dashboard Screen 17
vii
LIST OF TABLES
Table No. Table Title Page No.
1 Student Relational Database Table 7
2 Marks Relational Database Table 8
3 Results Relational Database Table 8
viii
ACRONYMS
• SRMS : Student Result Management System
• JDBC : Java Database Connectivity
• GUI : Graphical User Interface
• SQL : Structured Query Language
ix
1. INTRODUCTION
1.1 Brief Information about the Project
The Online Student Result Management System (SRMS) is a desktop/web-based
application developed to manage student examination results efficiently in educational
institutions. It provides a centralized platform to store, retrieve, update, and manage
student result data in a structured manner. The system replaces traditional manual result
preparation methods with an automated solution, thereby improving accuracy, reducing
redundancy, and enhancing accessibility. The application is developed using Core Java
for programming, Swing for designing the graphical user interface, JDBC for database
connectivity, and Oracle/MySQL Database for storing student data. It is designed to be
user-friendly and suitable for use in schools, colleges, and universities.
1.2 Motivation and Contribution of Project
In many educational institutions, student results are still prepared manually, which leads
to inefficiencies such as calculation errors, difficulty in managing large volumes of data,
and increased chances of data loss. These limitations motivated the development of the
Online Student Result Management System.
The key contributions of this project include:
• Providing a digital solution for managing student results
• Reducing manual effort and paperwork
• Improving accuracy and consistency of result data
• Enhancing data security through centralized storage
This system simplifies result management and improves overall efficiency in
educational institutions.
1.3 Objectives of the Project
The main objectives of the Online Student Result Management System are:
• To develop a user-friendly application for managing student results
• To store student data in a structured database
• To automate calculation of total marks, percentage, and grades
• To display student results in an organized format
1
1.4 Scope of the Project
The Online Student Result Management System is designed to simplify and automate the
process of managing student academic results. It can be effectively used in various
educational institutions such as schools, colleges, universities, and training centres. The
system ensures efficient handling of large volumes of student data with accuracy and
speed. The scope of the system includes the ability to store and manage student personal
details, course information, and subject-wise marks in a centralized database. It enables
faculty or administrators to enter, update, and delete student records easily. The system
automatically calculates total marks, percentages, grades, and pass/fail status, reducing
manual effort and minimizing errors. Additionally, It provides a structured and organized
way of displaying results, making it easier for students and administrators to access
information quickly. The system can also generate result reports that can be viewed online
or printed for official use. The application ensures data consistency, security, and
reliability by maintaining proper database management techniques. It can be extended to
include features such as student login portals, result history tracking, performance
analysis, and graphical reports. This makes the system scalable and adaptable to future
requirements of educational institutions. Overall, the system aims to replace manual result
processing methods with a digital solution, improving efficiency, accuracy, and
accessibility of student result information. Security is also a key part of the system’s
scope. It includes user authentication (login system), role-based access control, and data
protection mechanisms to ensure that sensitive student information is not misused.
Furthermore, the system supports:
• Multi-course and multi-semester management
• Handling of internal and external examination marks
• Grade system customization (CGPA, GPA, percentage)
• Automatic rank calculation and merit list generation
The system can be accessed through web browsers, making it platform-independent and
easily accessible from anywhere. This enables students to check their results online
without visiting the institution physically. Future scalability is another important aspect
of the system. It can be upgraded to include advanced features such as:
• Data analytics for student performance tracking
• Graphical dashboards and reports
• SMS/Email notifications for result updates
• Mobile application support
In conclusion, the scope of the Online Student Result Management System extends
beyond simple result storage and provides a comprehensive, secure, and scalable solution
for managing academic performance efficiently in modern educational environments.
2
2. SYSTEM ANALYSIS
2.1 Functional Requirements
Functional requirements define the core operations and functionalities that the Online
Student Result Management System (SRMS) must perform to effectively manage
student result-related information.
The functional requirements of the Online Student Result Management System are:
• Add Student Details
The system should allow the administrator to add new student records, including
details such as student ID, name, course, branch, and other relevant information.
Proper validation should be applied to ensure data accuracy.
• Update Student Records
The system should allow authorized users to delete student records from the
database. A confirmation mechanism should be included to prevent accidental
deletion of important data.
• Enter Marks
The system should allow the user to enter subject-wise marks for each student.
Proper validation should ensure that marks entered are within valid limits.
• Calculate Results
The system should automatically calculate total marks, percentage, and assign
grades based on predefined criteria. This helps eliminate manual calculation
errors.
• Display Student Results
The system should display student results in a structured format, including marks,
total, percentage, and grade. Sorting and filtering options can be included for
better usability.
3
2.2 Non-Functional Requirements
Non-functional requirements define the quality attributes and performance standards that
the Online Student Result Management System (SRMS) must satisfy.
• Performance
The system should respond quickly to operations such as adding student details,
entering marks.
• Security
The system should ensure that only authorized users can access and modify data
through proper authentication and access control mechanisms.
• Usability
The system should be simple, user-friendly, and easy to operate so that users can
perform tasks without difficulty.
• Reliability
The system should operate consistently without failure and should handle errors
without loss of data.
• Scalability
The system should be able to handle increasing amounts of data and users
without affecting system performance.
2.3 Requirements Specification
This section specifies the hardware and software requirements needed to run the Online
Student Result Management System efficiently.
• Minimum Hardware Requirements
• Processor: Intel i3 or above
• RAM: 4 GB (minimum)
• Hard Disk: 20 GB free space
• Monitor: Standard display
• Keyboard and Mouse
• Software Requirements
• Operating System: Windows 7/10/11
• Programming Language: Java
• IDE: Net Beans
• Database: My Sql
• Connectivity: JDBC
4
3. TECHNOLOGY DESCRIPTION
3.1 Programming Language
• Introduction to Java
Java is a high-level, object-oriented programming language developed by Sun
Microsystems. It is widely used for developing desktop, web, and enterprise applications
due to its platform independence and robustness.
In the Online Student Result Management System, Java is used to implement the core
functionality of the application. It handles operations such as adding, updating, deleting.
Java provides features like object-oriented programming, exception handling, and
strong memory management, which help in building reliable and efficient applications.
One of the main advantages of Java is that it is platform-independent, meaning the
program can run on any system that has a Java Virtual Machine (JVM). This makes it
suitable for developing portable applications like the Student Result Management
System.
3.2 Framework / Libraries
• Introduction to Swing
Swing is a part of Java that is used to create graphical user interfaces (GUI). It provides
a set of components such as buttons, labels, text fields, tables, and frames to design user-
friendly applications.
In this project, Swing is used to design the user interface of the Employee Management
System. It allows users to interact with the system easily through windows such as:
• Login Window
• Student Entry Form
• Marks Entry Form
• Result Window
• Display Students window
Swing provides flexibility in designing layouts and improves the overall user
experience. It makes the application visually interactive and easy to use.
3.3 Database Technology
The Online Student Result Management System uses a relational database for storing and
managing student information in a structured manner. The database ensures efficient data
storage, retrieval, and manipulation, which is essential for maintaining accuracy and
consistency in the system.
5
• JDBC (Java Database Connectivity)
JDBC is an API (Application Programming Interface) used in Java to connect and
interact with databases. It allows Java applications to execute SQL queries and retrieve
or update data in the database.
In the Employee Management System, JDBC is used to connect the Java application
with the Oracle database. It performs operations such as:
• Establishing a connection to the database
• Executing SQL queries (INSERT, UPDATE, DELETE, SELECT)
• Retrieving data from the database
• Closing the database connection
JDBC acts as a bridge between the application and the database, ensuring smooth
communication and data transfer. It helps in maintaining data consistency and enables
efficient data handling.
• Oracle Database / mySQL
Oracle Database and MySQL are relational database management systems used for
storing and managing structured data. They provide high performance, reliability, and
security for handling large volumes of data.
In this project, the database is used to store student details, subject-wise marks, and
result information. It supports SQL for data manipulation and ensures data integrity
through constraints like primary keys and data types.
3.4 Tools & IDEs
• Net Beans
NetBeans is used as the development environment for the Online Student Result
Management System. It supports Java programming and provides features like code
completion, debugging, and GUI design.
It helps in developing modules such as student details, marks entry, and result
calculation, and allows easy connection with the database for storing and retrieving
student records efficiently.
6
4. DATABASE DESIGN
4.1 Database Tables
The Online Student Result Management System uses a relational database to
store student result information in a structured manner. The database consists
of three main tables: Student, Marks, and Result.
• The Student table stores basic student details.
• The Marks table stores subject-wise marks of students.
• The Result table stores calculated results such as total, percentage, and grade.
This separation of data helps in reducing redundancy and improves data organization.
4.2 Table Structure
• Student Table
First Data Type Description Constraint
Name
Student_id NUMBER Srudent ID Primary Key
Department Not Null
name VARCHAR2(50)
Name
Course Not Null
course VARCHAR2(50)
Father Name
father_name VARCHAR2(50)
Phone Number
phone_no NUMBER
User Password Not Null
Password VARCHAR2(50)
Table 1: Student Relational Database Table
7
• Marks Table:
Field Constraint
Data type Description
Name
Student_id NUMBER Marks Primary Key
Subject1 NUMBER Marks Not Null
Subject2 NUMBER Marks -
Subject3 NUMBER Marks -
Table 2: Marks Relational Database Table
• Results table
Field Name Data Type Description Constraint
student_id NUMBER Student ID Foreign
Key
total NUMBER Total Marks -
Percentage NUMBER Percentage -
grade VARCHAR2(10) Grade -
4.3 Keys and Constraints
Keys and constraints are used to maintain data integrity and ensure accurate data storage.
• Primary Keys:
o student_id in Student table
• Foreign Key:
o student_id in Marks table references Student table
o student_id in Result table references Student table
• NOT NULL Constraint:
o Important fields such as student ID and name cannot be empty
8
• Data Type Constraints:
o Each field accepts only valid data types
These constraints help in maintaining consistency and avoiding duplicate or
invalid data.
4.4 Table Relationships
The Student, Marks, and Result tables are related through the student_id field.
• One student can have one set of marks
• Marks are used to generate result
• Result is derived from marks
This represents a one-to-many relationship between Department and Employee tables.
9
5. SYSTEM DESIGN
5.1 System Architecture
The Employee Management System follows a three-layer architecture:
1. Presentation Layer (User Interface)
o Developed using Java Swing
o Allows users to interact with the system
2. Application Layer (Business Logic)
o Processes user inputs
o Performs operations such as adding student details, entering marks,
calculating results.
3. Data Layer (Database)
o Stores student, marks, and result data
o Managed using Oracle/MySQL Database
This architecture ensures better organization, security, and maintainability.
5.2 Modules Description
The system is divided into the following modules:
1. Student Management Module
• Adds new student details
• Updates existing student records
• Deletes student information
• Shows student data in table format
2. Marks Entry Module
• Allows entry of subject-wise marks
• Validates marks before storing
3. Result Calculation Module
• Calculates total marks
• Computes percentage
• Assigns grades automatically
4. Database Connectivity
• Connects Java application with database using JDBC
• Executes SQL queries
10
6. SYSTEM IMPLEMENTATION
Login Screen:
This screen allows the user to log in by entering username and password. Only
authorized users can access the system
Figure 1: Login Screen of Student Result Management System
11
Main Menu Screen / Admin Dashboard Screen:
This screen provides options such as adding student details, entering marks and viewing
student records
Figure 2: Main Menu Screen / Admin Dashboard Screen of Student Result
Management System
12
Student Details Entry Screen:
This screen allows the user to enter and store student information such as student ID,
name, course, and branch.
Figure 3: Student Details Entry Screen
13
Marks Entry Screen:
This screen is used to enter subject-wise marks for students. It validates the input before
storing it in the database.
Figure 4: Marks Entry Screen
14
Result Display Screen:
This screen displays all student results in a table format. It shows roll number and
subject-wise marks. It also provides options like edit, delete, and refresh.
Figure 5: All Student Results Display Screen
15
Student Records View Screen:
This screen displays all registered student details in a table format. It shows
information such as name, roll number, branch, and other details. It also provides
options like delete and refresh for managing records.
Figure 6: Registered Students Screen
16
Student Result Dashboard Screen:
This screen displays complete student result details. It shows student information such as roll
number, name, branch, and gender along with subject-wise grades, grade points, credits, and
result status. It also provides semester summary and overall result details.
Figure 7: Student Result Dashboard Screen
17
7. CONCLUSION
The Online Student Result Management System has been successfully developed to
manage student examination results in an efficient and organized manner. The system
replaces manual result processing with a computerized solution, thereby reducing errors,
saving time, and improving accuracy. The application provides functionalities such as
adding student details, entering marks, calculating results, and displaying student
performance through a user-friendly interface. By using technologies like Java, Swing,
JDBC, and Oracle/MySQL Database, the system ensures reliable performance, secure
data handling, and quick access to information. The system is easy to use and helps
administrators manage large volumes of student data efficiently. It minimizes manual
work and ensures that all calculations are performed accurately without human
intervention. It also improves data consistency and allows quick retrieval of student
results, which is very useful for academic purposes. The centralized database ensures
that all records are stored securely and can be accessed whenever required. The project
demonstrates the effective use of database management and programming concepts in
solving real-world problems in educational institutions. It also provides a foundation for
developing more advanced systems in the future. Overall, the Online Student Result
Management System is a reliable and efficient solution that enhances the process of
result management and contributes to better academic administration.
18
8. FUTURE ENHANCEMENTS
The Online Student Result Management System can be further enhanced by adding
advanced features to improve its functionality and usability. The system can be upgraded
to a web-based application so that students and administrators can access results from
anywhere through the internet. A student login module can be added to allow students to
view their results securely using their own credentials. Multi-user support can also be
implemented so that multiple administrators can manage student data simultaneously.
Additional features such as report generation, result downloading, and printing options
can be included for better usability. Integration of graphical analysis like charts for
performance evaluation can also be added.
The system can be further improved by enhancing the user interface and adding better
security features such as encryption and authentication. These enhancements will make
the system more efficient, scalable, and suitable for real-time applications in educational
institutions.
19
9. REFERENCES
The following references were used during the development of the Student
Results Management System:
1. Herbert Schildt, Java: The Complete Reference, Oracle Press, 11th Edition.
2. E. Balagurusamy, Programming with Java, McGraw Hill Education.
3. Korth, Silberschatz, Sudarshan, Database System Concepts, McGraw Hill.
4. Oracle Documentation, [Link]
5. Java Documentation (Oracle), [Link]
6. JDBC Tutorial – Geeks for Geeks, [Link]
7. Java Swing Tutorial – Tutorials Point,
[Link]
8. W3Schools Java Tutorial, [Link]
20
APPENDIX
A.1 Sample Code
Database Connection Code:
The following code establishes a connection between the Java application and the
database using JDBC.
[Link]:
import [Link].*;
public class DBConnection {
public static Connection getConnection() {
Connection con = null;
try {
[Link]("[Link]");
con = [Link](
"jdbc:oracle:thin:@localhost:1521:xe","system","password");
} catch (Exception e) {
[Link](e);
}
return con;
}
}
Insert Student Record Code:
This code is used to add a new student into the database.
[Link]:
import [Link].*;
public class InsertStudent {
public static void main(String[] args) {
try {
Connection con = [Link]();
String query = "INSERT INTO student VALUES(?,?,?,?)";
PreparedStatement pst = [Link](query);
[Link](1, 101);
21
[Link](2, "Ravi");
[Link](3, "[Link]");
[Link](4, "CSE");
int i = [Link]();
if (i > 0) {
[Link]("Student record inserted successfully");
}
[Link]();
} catch (Exception e) {
[Link](e);
}
}
}
22
SQL Queries
Create Student Table:
CREATE TABLE student (
student_id NUMBER PRIMARY KEY,
name VARCHAR2(100) NOT NULL,
course VARCHAR2(50),
branch VARCHAR2(50)
);
Create Marks Table:
CREATE TABLE marks (
student_id NUMBER,
subject1 NUMBER,
subject2 NUMBER,
subject3 NUMBER,
subject4 NUMBER,
subject5 NUMBER,
FOREIGN KEY (student_id) REFERENCES student(student_id)
);
Create Result Table:
CREATE TABLE result (
student_id NUMBER,
total NUMBER,
percentage NUMBER,
grade VARCHAR2(10),
FOREIGN KEY (student_id) REFERENCES student(student_id)
);
23
24