Student Management System Database Design

While retrieving data error and data tracking are the main problem that has been experiencing for a long time by the department of Swasa. It leads to the need of the this system as it provides the capability of processing, storing and giving out information with lots of accuracy.

Our student management system is an improved system that can handle the details about a student which includes details of subjects, lectures and personal details of students etc. in the present system a lot of time is required as well as manpower. But in this case the entire work is more or less computerized which means the 100 % accuracy can be maintained. Administrator maintained the student management system and it is the job of the administration to monitor and insert updating of the entire process. Three modules made up this system and they are:

Subject details
Lecturer details
Student details

The school where social science is taught make use of this system for tracking the personal data of the students who are registered with the departments. This system is used almost every year to maintain the records. Presently Microsoft excel is used to track data but with the increase in uses the speed of data retrievement using this form has slowed down. So after a preliminary investigation I found that there is a need for a much better system.

The system that is used presently is a system of semi computerized where at the end of all the semesters dates are printed out followed by new data entries. The systems that are in Microsoft excel cannot even compute the questions that are maintained by the Microsoft access. The objective of this project is to design a system of database that can easily retrieve, update as well as store data. There are specific objectives behind the proposed theory.