A Centralized Student Information Database System

By

Author

Presented To

Department of Computer Science

A Centralized Student Information Database System (CSIDS)

(A Case study of Elizade University)

ABSTARCT

Student centralized database system is a system designed to computerize the process of student information records considering the problems faced by doing this manually. The system was studied and relevant officials were interview to acquire the required data. This designed system allows easily information retrieval of accurate information for effective and efficient allocations and also for easy maintenance of information integrity as well as time saving and reduction in operation. The centralized database system design in Mysql is interactive, menu- driven and user friendly. It provides timely information about students. Most students information operations are recorded and stored in the computer and retrieved at willed. It ensures security as students must logo to the systems before they see information concerning them.

TABLE OF CONTENTS

Title page                                                                                i

Certification         Page                                                                    ii

Approval Page                                                                        iii

Dedication                                                                               iv

Acknowledgement                                                                            v

Abstract                                                               vi

Table of contents                                                                     vii

10 CHAPTER ONE

11INTRODUCTION                                                             

12Statement of the Problem                                                  

13Research Objectives                                                           

14Signification Of The Study                                                

15Research Methodology                                            

16Organization of the project

17General methodology                                     

18Definition Of Terms                                                          

CHAPTER TWO

20     REVIEW OF RELEVANT LITERATURE                            

CHAPTER THREE

30     DESCRIPTION AND ANALYSIS OF THE PRESENT SYSTEM

31            Methodology                                                                

32            General Overview of  student centralized database        system approach

33            System Analysis

331     Analysis of the Existing System                   

332    Problem of the Existing System                                         

333    Analysis of the proposed System                                    

34            System Design                                                                

35            Input Layout

36            Data Flow Diagram

37            Database Structures      

38            Database Structures      

39 Centralized database design

CHAPTER FOUR

40     DESIGN AND IMPLEMENTATION

SYSTEM IMPLEMENTATION AND DOCUMENTATION

40     Introduction        

41     Program Design

42   Choice of Programming Language     

43     Programming Environment    

44 Hardware Requirements

45 Hardware Requirements

46Implementation Codes and Design

47Program Flowchart  

48Software testing       

CHAPTER FIVE " SUMMARY, CONCLUSION AND RECOMMENDATION

50     Introduction        

51     Constraints of the Study 

52     Summary

53     Conclusion

54     Recommendation                                       

CHAPTER FIVE

50     SUMMARY, RECOMMENDATION AND CONCLUSION

51     Summary                                                                      

52     Recommendation                                                          

53     Conclusion                                                                    

References                     

Appendix/source code  

CHAPTER ONE 11            BACKGROUND TO THE STUDY

INTRODUCTION

The history of Student Information Database Systemover the past 20 years is one of exceptional productivity that has led to the database system becoming arguably the most important development in the field of software engineering(Thomas Connolly, 2010)

The database is now the underlying framework of the information system, and has fundamentally changed the way many organizations operate In particular, the developments in this technology over the last few years have produced systems that are more powerful and more intuitive to use (Tony Morgan, 2011) This has resulted in database systems becoming increasingly available to a wider variety of users Unfortunately, the apparent simplicity of these systems has led to users creating databases and applications without the necessary knowledge to produce an effective and efficient system (Terry Halpin, 2011)

Achievements in database research underpin fundamental advances in communications systems, transportation and logistics, financial management, knowledge-based systems, accessibility to scientific literature, and a host of other civilian and defense applications They also serve as the foundation for considerable progress in the basic science fields ranging from computing to biology (LinLin Wang, 2011)

It is a student information database system for education establishments to manage student data Student Information Database Systems (often abbreviated as SIDS systems) manage many other student-related data needs in the Universities like Maintenance and reporting of student data, handling inquiries from prospective students, handling the admissions process, Enrolling new students and enabling online scheduling, student accounts and financial aid processing, Handling records of examinations, assessments, marks, grades and academic progression Maintaining records of absences and attendance, Recording communications with students, Maintaining discipline records, Providing statistical reports,Housing, dorms and facilities details, assignments and tasks, Student health records, Fees Management, Inventory and Assets of the school

12     STATEMENT OF THE PROBLEM

The type of database used to keep student records is void of data redundancy which waste space by storing the same information in more than one file In contrast, thecentralized student information database systemapproach attempts to eliminate the redundancy by integrating the files so that multiple copies of the same data are not stored However, the database approach does not eliminate redundancy entirely, but controls the amount of redundancy inherent in the database By eliminating or controlling redundancy, we reduce the risk of inconsistencies occurring If a data item is stored only once in the database, any update to its value has to be performed only once and the new value is available immediately to all users Unfortunately, many of the student information databases do not automatically ensure this type of consistency

This current work presents a new approach for storing and manipulating student information to bring about consistency and reduce redundancy in our database

13     RESEARCH OBJECTIVES           AIM AND OBJECTIVES OF RESEARCH

The aim of this Research is to present acentralized student information database system

The objectives to achieve this aim are:

·        To review recent literatures on database systems

·        To do a site survey of Elizade University

·        To design a centralized student information database system

14SIGNIFICANCE OF THE STUDY

The shifts from traditional flat files to database system are not merely a technological evolution, but require a change in the paradigm by which people access and use the database system

The database system has the following advantages over the traditional flat file

·        Databases can handle querying tasks, so you don't have to walk over files manually

·        Databases can handle multiprocessors/multithreaded access

·        Databases can handle access from network

·        Databases can watch for data integrity

·        Databases can update data easily

·        Databases are reliable

·        Databases can handle transactions and concurrent access

·        Databases + ORMs let you manipulate data in very programmer friendly way

15 RESEARCH METHODOLOGY

The methods that will be involved in carrying out this research include:

·        Background research on database systems

·        Review of pertinent articles, journals and publications as regards to database, student’s information systems, and so on

·        Develop a centralised student information database based on the gathered facts and improve on them

·        The proposed system is designed using MySQL console for ensuring consistency etc

16ORGANISATION OF THE PROJECT

The project is organized into five chapters in the following layouts:

Chapter one:provides the background to the research and an introduction to the research, along with a definition of the problem statement, methodology, research objectives

Chapter Two:This chapter contains a literature review of books, articles, published papers, and electronic resources used during this research It provides an overview of the relevant information available related to all the topics covered during the research

Chapter Three: covers requirement gathering This entails the methodology, which is the analysis and specification of database development

Chapter Four:In this chapter, implementation of the system will be defined, ie the software requirements, the hardware requirements are specified

Chapter Five: contains summary, conclusion and recommendations for further studies

17     GENERAL METHODOLOGY

The project is carried out following the appropriate stages involved in design and development of student centralized database software The stages are briefly discussed below

v    Problem identification:  The problems associated with the student database are first identified This is done by critically analysis of the existing system

v    Data collection: The data required for this student centralized database is obtained by interviewing staff, students and other personnel Also vital information was also obtained from the internet especially on the technicality in designing and developing a student database

v    System modelling: Using relevant facts obtained from relevant sources, the student database system is designed

v    System Development and implementation: The conceptual design is development and implemented as computer program After the development and implementation, the system is tested to ensure that it fulfills the objectives of the project

v    System installation: The developed clinical database system software is installed on the computer system and made ready     for use

18           DEFINITION OF TERMS

Automation: This is the use of control system such as computer to control and process data, reducing the need for human intervention

Database: This refers to a large store of related data on a computer that can be access and modified by the user

Password: This is a secret code that a user must type into a computer to enable him access it or its applications This is made up of numbers, letter, special character or a combination of any of the above categories

Record System: The act of using a computer system to store and update information/data sequentially in order to keep file security

Computerized: To convert a based system to start using a computer system to control, organize and automate something

Centralized Database: A centralized database system consists of a single processor together with its associated data storage devices and other peripherals

Data Entry: This is the standard input device through which the system gets more of the instructions and commands

Research: A careful study of something, especially to discover new facts or information about it

System