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) 6
3.3.2 Oracle Database 6
3.4 Tools & IDEs 6
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 7
4.4 Table Relationships 8
5. SYSTEM DESIGN 9
5.1 System Architecture 9
5.2 Modules Description 9

i
6. SYSTEM IMPLEMENTATION 10
7. CONCLUSION 12
8. FUTURE ENHANCEMENTS 13
9. REFERENCES 14
APPENDIX (Sample Code) 15
APPENDIX (SQL Queries) 16

iii
 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, searching results, 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.

vi
 LIST OF FIGURES
Figure No. Figure Title Page No.
1 Login Screen of Student Result 10
Management System
2 Main Menu Screen of Student Result 10
Management System
3 Student Details Entry Screen 10

4 Marks Entry Screen 10

5 Student Result Display Screen 11

6 Student Records View Screen 11

vi
 LIST OF TABLES

Table No. Table Title Page No.

1 Student Relational Database Table 7

2 Marks Relational Database Table 7

vi
 ACRONYMS

 SRMS : Student Result Management System

 JDBC : Java Database Connectivity
 GUI : Graphical User Interface
 SQL : Structured Query Language

vi
 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
 Enabling quick search and retrieval of student results
 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 enable quick searching of student results using ID or name
 To display student results in an organized format

1
1.4 Scope of the Project
The Online Student Result Management System can be used in educational institutions
such as schools, colleges, universities, and training institutes to manage student
examination results efficiently. It supports operations such as entering student details,
recording subject-wise marks, calculating results automatically, searching for student
records, and displaying results in an organized manner.

The system provides a simple and user-friendly interface for maintaining student result
data in a centralized database.

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.

 Search Student Results

The system should support searching for student results using specific criteria
such as student ID or student name. The search functionality should return
accurate and relevant results quickly.

 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, and searching results without noticeable delay

 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: VS Code
4
 Database: Oracle Database
 Connectivity: JDBC

5
 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,
and searching student records. 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 Detail Form

 Marks Entry Form
 Search Result Window
 Display Result Screen
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.

6
 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

 Visual Studio Code / Eclipse
Visual Studio Code (VS Code) and Eclipse are used as development environments for the
project. These tools support Java programming and provide features such as syntax
highlighting, code completion, and debugging support.

They help in writing, testing, and managing the code efficiently, making development
faster and easier.

7
 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
course VARCHAR2(50)

Branch
branch VARCHAR2(50)

Table 1: Student Relational Database Table

 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 -

Subject4 NUMBER Marks -

Subject5 NUMBER Marks -

Table 2: Marks Relational Database Table

8
 • 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

• Data Type Constraints:

o Each field accepts only valid data types

These constraints help in maintaining consistency and avoiding duplicate or invalid data.

9
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.

10
 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, and searching
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. Search Module
 Searches student results by ID or name

11
5. Database Connectivity
 Connects Java application with database using JDBC
 Executes SQL queries

12
 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

Main Menu Screen / Admin Dashboard Screen:

This screen provides options such as adding student details, entering marks, searching
results, and viewing student records

15
 Figure 2: Main Menu Screen / Admin Dashboard Screen of Student Result
Management System

Student Details Entry Screen:

This screen allows the user to enter and store student information such as student ID,
name, course, and branch.

15
Figure 3: Student Details Entry Screen

15
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

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.

25
 Figure 5: All Student Results Display Screen

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

25
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

25
 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.

25
 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.

25
 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]

25
 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);
[Link](2, "Ravi");

25
 [Link](3, "[Link]");
[Link](4, "CSE");

int i = [Link]();

if (i > 0) {
[Link]("Student record inserted successfully");
}

[Link]();

} catch (Exception e) {
[Link](e);
}
}
}
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)
);

25
Create Result Table:
CREATE TABLE result (
student_id NUMBER,
total NUMBER,
percentage NUMBER,
grade VARCHAR2(10),
FOREIGN KEY (student_id) REFERENCES student(student_id)
);

25