DESIGN AND DEVELOPMENT A DATABASE MANAGEMENT SYSTEM FOR STUDENT REGISTRATION IN FACULTY OF SCIENCE OF NATIONAL OPEN UNIVERSITY OF NIGERIA. A RESEARCH PROJECT MATERIAL ON COMPUTER SCIENCE EDUCATION
1.1 BACKGROUND TO THE STUDY
Database Management System for students registration deals with all kind of student details, academic related reports, college details, course details, curriculum, batch details and other resource related details too (Vecchioli, 1999). It tracks all the details of a student from the day one to the end of his course which can be used for all reporting purpose, tracking of attendance, progress in the course, completed semesters years, coming semester year curriculum details, exam details, project or any other assignment details, ﬁnal exam result etc. The design can facilitate the exploration all the activities happening in the college, even to get to know which faculty is assigned to which course, the current status of a student, attendance percentage of a student and upcoming requirements of a student. The database management system for student registration is an automated version of manual database management system for student registration. It can handle all details about a student (Wright, 1990). The details include college details, subject details, student personal details, academic details, exam details etc. In case of manual system they need a lot of time, manpower etc. Here almost all work is computerized. So the accuracy is maintained. Maintaining backup is very easy. It can do within a few minutes. The system has two type of accessing modes, administrator and user. Database management system for student registration is managed by an administrator. It is the job of the administrator to insert update and monitor the whole process. When a user log in to the system. He/she would only view details of the student. He/she can’t perform any changes (Connors & Valesky, 2006).
The data generated by organizations are usually created in files for use by different departments/units within the organization. If the data contained in these files are not carefully delineated it is very likely that the same data will appear on several of these files. That is these files would contain redundant data e.g. the University registry file and college or department file would contain the name and address of a student. This would mean that a simple change of address has to be processed in two and probably three or four places, depending on the number of other files on which these data appears. As noted in Vecchioli (1999) organizing and managing student records into a cohesive and efficient system might seem like an impossible task.
The National Open University of Nigeria is a Federal Open and Distance Learning (ODL) institution, the first of its kind in the West African sub-region. It is Nigeria’s largest tertiary institution in terms of student numbers and is popularly referred to as ‘NOUN’. NOUN does not provide lectures to students in normal classrooms except some certain study centres, primarily due to constraints known to the University alone and the challenges usually faced by a developing tertiary institution. The study centre in Lagos for instance provides lectures to all its Law undergraduates and supplies necessary course materials to all students after the payment of tuition fees. All courses offered have been accredited by the National Universities Commission (NUC)