Project Report

On

Student Result Management System

Bachelor of Technology In
Information Technology

Dr. A.P.J Abdul Kalam Technical University,

Lucknow (Uttar Pradesh)

Group Members: Under the supervision:

Harshita Singh (2101330130057) Dr. Sandhaya Umrao

Manya Gupta (2101330130077)

Muskan Agrawal (2101330130085)

Index
Acknowledgement
We are grateful to all our faculty members who have contributed in
inspiring and clarifying our thought over the years (Dr. Sandhaya Umrao)
and many other faculty members of NIET College. Special gratitude to
my respected head of the division Mrs. Kumud Saxena, for allowing us
to use the facilities available and also help us to coordinate my project.
We are thankful also for the tireless generosity to our sponsors, well-
wishers and our family for spiritual, moral and even financial support.
Thanks also to the entire staff of my College, Furthermore, We would
also like to acknowledge with much appreciation the crucial role of
faculty members on this occasion. Last but not least, We would like to
thank friends who help us to assemble the parts and gave a suggestion
about the project. Finally, Honor and glory to the highest God for having
enabled us successfully accomplishes.
.

----------------------
Abstract
The main objective of this project is to build a student result
management system that will store and display result of students. It is
purposed to reduce time spent on administrative tasks. The system is
intended to accept process, generate students. The system is also
intended to provide better services to users, provide meaningful,
consistent, and timely data and information and finally promotes
efficiency by converting paper processes to electronic form. The system
was developed using basic technologies such as Python GUI(Tkinter) and
Database connectivity with SQlite. The system is free of errors and very
efficient and less time consuming due to the care taken to develop it. All
the phases of software development cycle are employed and it is
worthwhile to state that the system is user friendly and strong.
Provision is made for future development in the system.
Introduction
Student Result Management System is project which is helpful for
students as well as the school authorities. In the current system all the
activities are done manually. It is very time consuming and costly. Our
Student Result Management System deals with the activities related to
the management of the result of the students.

The two main users involved in this system are

1. User(i.e., Students)
2. Admin

In the project we can login a student by the authentication code i.e., roll
number view the results which is announced by admin.
Purpose
The objective of Student Result Management System is to allow
the admin of any organization to edit and find out the personal
details of a student and allows the student to check their result
with the help of their roll number .It’ll also facilitate keeping all the
records of students, such as their id, name, mailing address, phone
number, DOB etc. So, all the information about a student will be
available in a few seconds.
Overall, it’ll make Student Result and its academic details
management an easier job for the admin and the student of any
organization.

Advantages:
 It helps the educational admin to handle and manage students’
records.
 It helps educational admin to generate result.
 It brings transparency and efficiency in the working of educational
system.
Disadvantages:
 The system can only handle the result of the student.
 The system does not include specific marks of the subject but the
total obtained marks.
Applications:
The project Student Result Management System is aimed towards
recording a considerable number of student records and needs
online assistance for managing result of students. Website should
be user-friendly, ‘quick to learn’ and reliable project for the above
purpose. Student Result Management System is intended to be a
stand-alone product and should not depend on the availability of
other domain. The system will also have an admin who has full-
fledged rights with regards to performing all actions related to
control and management of the student academic details.
Feasibility study
A feasibility study is an important step in determining the viability of a
project before investing time and resources into it. Here are some key
factors to consider when conducting a feasibility study for a student
result management system:
- Technical feasibility
- Economic feasibility
- Physical feasibility

Technical feasibility:

This involves assessing whether the technology and infrastructure

required to implement the system are available and can support to
meet the exact requirements of the project.

Economic feasibility:

This involves analyzing the financial costs and benefits of implementing

the system. This includes determining the initial costs of development,
installation, and training, as well as the ongoing maintenance and
operating costs. It is important to evaluate whether the benefits of the
system justify the investment, and whether it will provide a positive
return on investment.
Operational feasibility:

This involves assessing whether the system can be effectively

implemented and used by the users. This includes evaluating whether
the system aligns with the school's existing policies and procedures, and
whether the staff and students have the necessary skills and knowledge
to use the system.

Schedule feasibility:

This involves evaluating whether the system can be completed within

the specified timeline. This includes assessing the availability of
resources such as staff, hardware, and software, and determining
whether the development and implementation timeline is reasonable.

By conducting a thorough feasibility study, you can assess the

viability of a student result management system and identify potential
challenges and risks before investing in the project.
Scope of the Project

The proposed system will affect or interface with the user (student) and
admin. The system works and fulfills all the functionalities as per the
proposed system. It will provide reduced response time against the
queries made by different users. This project is based on python(GUI
Tkinter) language with SQlite database which manage the details of the
student because it is a tedious job for any organization.

All possible features such as verification, validation, security, user

friendliness etc. have been considered.

The different types of modules present in this project are

1. Admin
2. User
Admin:
1. Dashboard: In this section, admin can see and update all details in
brief like Total Courses, Total Students, Add student results and
View student results.
2. Course: In this section, admin can manage courses
(Add/Update/Delete).
3. Students: In this section, admin can manage the students
(Add/Update/Delete).
4. Result: In this section admin, can add the result of the student by
the help of their roll number.
5. View Result: In this section admin, can also view the results of
students enrolled in various courses.
User (Students):
1. Dashboard: It is welcome page for students.
2. Login: In this section, user have to enter the registered roll number
to access the result.
3. View Result: In this section student can view the results of courses
in which they are enrolled.
User (Non-Register):
1. Home: It is welcome page for user.
2. About: User can view about us page.
3. Contact: User can view contact us page.
Software & Hardware requirements

Hardware requirements:
Processor: A fast and reliable processor such as Intel Core i5 or higher is
recommended.
RAM: A minimum of 4 GB RAM is required to run the software, but 8 GB
or more is preferred.
Storage: You will need sufficient storage space to store the software,
database, and any related files.
Network: A stable internet connection is necessary to access and
manage the software.

Software requirements:
Operating System: A reliable and secure operating system like Windows,
Linux, or macOS is needed to develop the software.
Database Management System: A database management system like
MySQL, Oracle, or Microsoft SQL Server is required to store and manage
student data, however we use the SQlite database.
Programming Languages: You can choose from a variety of
programming languages such as Java, Python, C#, or PHP to develop the
software.
System Design
Design is the first step in the development phase for any techniques and
principles for the purpose of defining a device, a process or system in
sufficient detail to permit its physical realization.

Once the software requirements have been analyzed and specified the
software design involves three technical activities - design, coding,
implementation and testing that are required to build and verify the
software.

The design activities are of main importance in this phase, because in

this activity, decisions ultimately affecting the success of the software
implementation and its ease of maintenance are made. These decisions
have the final bearing upon reliability and maintainability of the system.
Design is the only way to accurately translate the customer’s
requirements into finished software or a system.

Design is the place where quality is fostered in development. Software

design is a process through which requirements are translated into a
representation of software. Software design is conducted in two steps.
Preliminary design is concerned with the transformation of
requirements into data
Unified Modelling Language Diagrams (UML):

 The unified modelling language allows the software engineer to

express an analysis model using the modelling notation that is
governed by a set of syntactic semantic and pragmatic rules.

 A UML system is represented using five different views that

describe the system from distinctly different perspective. Each view
is defined by a set of diagrams, which is as follows.

User Model View

i. This view represents the system from the user’s perspective.

ii. The analysis representation describes a usage scenario from the

end-user’s perspective.

Structural model view

 In this model the data and functionality are arrived from inside
the system.

 This model view models the static structures.

Implementation Model View

 In this the structural and behavioural as parts of the system are

represented as they are to be built.

Environmental Model View

In these the structural and behavioural aspects of the environment in

which the system is to be implemented are represented.

UML is specifically constructed through two different domains they are

 UML Analysis modelling, which focuses on the user model and

structural model views of the system?

 UML design modelling, which focuses on the behavioural

modelling, implementation modelling and environmental model
views.
Use Case Diagrams User/Student

Login(Roll no)

Dashboard

View Result
Use Case Diagrams Admin
Sign in(Password)

Dashboard

Manage Course
(Add/Update/Del)

Manage Students
(Add/Update/Del)

Manage Result

(Add/Update/Del)

View Result

Update Own Profile

Change Password
Database Design
The data in the system has to be stored and retrieved from database.

Designing the database is part of system design. Data elements and data

structures to be stored have been identified at analysis stage. They are

structured and put together to design the data storage and retrieval

system.

A database is a collection of interrelated data stored with minimum

redundancy to serve many users quickly and efficiently. The general

objective is to make database access easy, quick, inexpensive and flexible

for the user. Relationships are established between the data items and

unnecessary data items are removed. Normalization is done to get an

internal consistency of data and to have minimum redundancy and

maximum stability. This ensures minimizing data storage required,

minimizing chances of data inconsistencies and optimizing for updates.

The SQlite database has been chosen for developing the relevant

databases.
Student Result Management System contains 3 SQlite tables :

Course table Structure : This table store the course details like course

name, its duration, description.

Table 1

Student table Structure : This table store the details of the student like

roll number, name, email, course selected, etc.

Table 2
Result table Structure : This table store the students results of

educational organization which includes marks obtained, total marks

and percentage.

Table 3
Class Diagram
The class diagram shows a set of classes, interfaces, collaborations and
their relationships.
Student Course Result

-roll no: int -course name: string -roll no: int

-name: string -duration: string -name: string

-email: string -charges: int -marks obtained: int

-gender: string -description: text -total marks: int

-state: string -percentage: int

-address: string

-d.o.b: date

-contact: int

-city: string

-pin: int
System Testing

SOFTWARE TESTING TECHNIQUES:

Software testing is a critical element of software quality assurance and

represents the ultimate review of specification, designing and coding.

TESTING OBJECTIVES:
1. Testing is process of executing a program with the intent of
finding an error.

2. A good test case design is one that has a probability of finding an

as yet undiscovered error.

3. A successful test is one that uncovers an as yet undiscovered

error.
These above objectives imply a dramatic change in view port.
Testing cannot show the absence of defects, it can only show that

software errors are present.

There are three types of testing strategies

1. Unit test
2. Integration test
3. Performance test
Unit Testing:

Unit testing focuses verification efforts on the smallest unit of software

design module. The unit test is always white box oriented. The tests that
occur as part of unit testing are testing the module interface, examining
the local data structures, testing the boundary conditions, execution all
the independent paths and testing error-handling paths.

Integration Testing:

Integration testing is a systematic technique or construction the

program structure while at the same time conducting tests to uncover
errors associated with interfacing. Scope of testing summarizes the
specific functional, performance, and internal design characteristics that
are to be tested. It employs top-down testing and bottom-up testing
methods for this case.

Performance Testing:

Timing for both read and update transactions should be gathered to

determine whether system functions are being performed in an
acceptable timeframe.
Output Screen of Project

Home Page
Login Page for student

View Result
Login Page for admin

Dashboard
Course Page

Student Page
Add Result
Conclusion

The project titled as Student Result Management System was deeply

studied and analyzed to design the code and implement. It was done

under the guidance of the experienced project guide. All the current

requirements and possibilities have been taken care during the project

time.

Student Result Management System can be used by any small institutes

to maintain the results of students easily. Achieving this objective is
difficult using a manual system as the information is scattered, can be
redundant and collecting relevant information may be very time
consuming. All these problems are solved using this project.
Bibliography

For PHP

 https://www.w3schools.com/php/default.asp
 https://www.sitepoint.com/php/
 https://www.php.net/

For MySQL

 https://www.mysql.com/
 http://www.mysqltutorial.org

For XAMPP

 https://www.apachefriends.org/download.html