The Design and Implementation of Student Academic Record Management System

摘要

A number of problems associated with student academic record management include improper course registration, late release of students' results, inaccuracy due to manual and tedious calculation and retrieval difficulties/inefficiency. In most cases the data generated by academic institutions are usually created in non-delineated files for use by different departments/units within the institutions with the same data appearing on several of these files. This means that a simple change of address would have to be processed in two and probably three or four places, depending on the number of other files on which these data appears. The development of database concept is the answer to these problems where the amount of redundant data is reduced and the possibility that data contained on a file might be inaccurate because they were never updated. This paper discusses the design and implementation of a student registration and course management database application with Microsoft Access 2003. It also discusses the issues of selecting appropriate database model, interface design, system deployment and maintenance. A projection of record growth in relation to student population and system requirement was carried out in the study. Finally it discusses the applicability of the system in academic institutions.