Design and Development a Database Management System for Student Registration

Design and Development a Database Management System for Student Registration

Project / Seminar Material
Reference ID: PS-5465-TM

DEDICATION

This research material titled “Design and Development a Database Management System for Student Registration” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Development a Database Management System for Student Registration” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”


    Design and Development a Database Management System for Student Registration

    CHAPTER ONE


    Introduction

    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, final 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)


    1.2 Statement Of The Problem

    The major problems associated with database management system for student registration include improper registration, late release of students’ results, inaccuracy due to manual and tedious calculation, retrieval difficulties /inefficiency. Hence, it is importance to identify whether the organization of administrative functions in the faculty of science, national Open University of Nigeria is best suited for computerization. However, this study is examining the design and development of a database management system for student registration in faculty of science, National Open University of Nigeria.


    1.3 Objectives Of The Study

    The following are the objectives of this study:

    1. To design and develop a database management system for student registration in faculty of science, National Open University of Nigeria.
    2. To examine the advantages of database management system for student registration.
    3. To identify the limitations in the development of database management system for student registration.

    1.4 Research Questions

    1. What is the process of designing and developing a database management system for student registration in faculty of science, National Open University of Nigeria?
    2. What are the advantages of database management system for student registration?
    3. What are the limitations in the development of database management system for student registration?

    1.6 Significance Of The Study

    The following are the significance of this study:

    The outcome of this study will educate on the design and development of a database management system for student registration in faculty of science, National Open University of Nigeria.

    This research will be a contribution to the body of literature in the area of the effect of personality trait on student’s academic performance, thereby constituting the empirical literature for future research in the subject area.


    1.7 Scope/Limitations Of The Study

    This study will cover the process of designing and developing a database management system for student registration in faculty of science, National Open University of Nigeria

    Limitation Of Study
    Financial constraint

    Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet, questionnaire and interview).

    Time constraint

    The researcher will simultaneously engage in this study with other academic work. This consequently will cut down on the time devoted for the research work.

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Development a Database Management System for Student Registration