STUDENT RECORD-KEEPING
SYSTEM DATABASE PROJECT
ABSTRACT
Education institutes can simply maintain the records of their students by using the
student record-keeping system. Using a manual system makes it challenging to
accomplish this goal because the information is dispersed, often redundant, and
gathering relevant information can take a lot of time. Using this project, all these
issues are resolved.
PROJECT OBJECTIVES
Such a database management system is intended to maintain student records in an
appropriate and ordered manner, enable data and information flow across various
activities related to processing student information, and safeguard student data.
The scope of this project is as follows:
1. The application will assist in adding student records like their personal
information, information about fees, information about scholarships,
information about courses, and information about grades.
2. Depending on approved authority, the application shall allow editing or deleting
of any student record.
3. The application should allow the generation of reports such as mark statistics,
student fees duelist, etc.
4. Role-based authorization must be enabled for read and write processes for the
application to have access based on authorization.
5. For security reasons, sensitive data must be maintained in encrypted form, like
payment and password information.
REQUIREMENT ANALYSIS
The application should allow Administrator to do the following:
1. Add Student: Allow Administrator to add student details like Name,
Enrolment ID, Contact Number, Address, Course Enrolled, Subjects, Date of
Birth, Gender, etc.
2. Manage Student: Allow Administrator to view student record, delete existing
student record, edit or update any existing student record.
3. Allow the Administrator to add marks, manage marks and generate results.
4. Allow the Administrator to generate lists of students who have not paid fees
and those who have availed scholarships.
5. Allow the Administrator to manage user records and change passwords.
Student can do the following:
1. The application should allow student to register
2. The application should allow students to view and download result.
CONCEPTUAL DIAGRAM
TABLES
