Student Record Keeping System Database Project Abstract

Student Record Keeping System Database Project Abstracteducation Ins

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:

• Add Student: Allow Administrator to add student details like Name, Enrolment ID, Contact Number, Address, Course Enrolled, Subjects, Date of Birth, Gender, etc.
• Manage Student: Allow Administrator to view student record, delete existing student record, edit or update any existing student record.
• Allow the Administrator to add marks, manage marks and generate results.
• Allow the Administrator to generate lists of students who have not paid fees and those who have availed scholarships.
• Allow the Administrator to manage user records and change passwords.

Students can do the following:

• The application should allow students to register.
• The application should allow students to view and download results.

Conceptual Diagram Tables

Student Table

This table stores personal details of students, including Student ID, Name, Date of Birth, Gender, Contact Number, and Address.

Course Table

This table maintains information about courses available, including Course ID, Course Name, and Description.

Enrollment Table

This table links students to courses, with fields like Enrollment ID, Student ID, Course ID, and Enrollment Date.

Subject Table

Contains details about subjects associated with courses, including Subject ID, Subject Name, and Course ID.

Grades Table

Records the grades of students in various subjects, with fields like Grade ID, Student ID, Subject ID, Exam Scores, and Final Grade.

Fees Table

Tracks fee payments, including Fee ID, Student ID, Amount Paid, Payment Date, and Payment Status.

Scholarship Table

Holds scholarship information, including Scholarship ID, Student ID, Scholarship Type, Awarded Amount, and Validity Period.

User Management Table

Maintains data about system users, including User ID, Username, Password (encrypted), Role (Admin/Student), and Last Login.

Conclusion

The student record-keeping system is designed to streamline the management of educational data, improve access control through role-based permissions, and enhance security by encrypting sensitive data. The system's modular design allows administrators to efficiently manage student information, generate essential reports, and ensure data security, thereby significantly reducing the administrative burden and improving data accuracy.

References

• Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Pearson.
• Database Design and Implementation. Cengage Learning.
Communications of the ACM, 13(6), 377–387. Proceedings of the 9th Python in Science Conference, 51-56. Database Systems: The Complete Book. Pearson. Database System Concepts (6th Edition). McGraw-Hill. Database Applications for Data-Driven Web Sites. Pearson. Journal of Information Security, 10(3), 124–133. International Journal of Cyber Security, 15(2), 87–96. Computers & Security, 92, 101733.