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
1.0 CHAPTER ONE
1.1INTRODUCTION
1.2Statement of the Problem
1.3Research Objectives
1.4Signification Of The Study
1.5Research Methodology
1.6Organization of the project
1.7General methodology
1.8Definition Of Terms
CHAPTER TWO
2.0 REVIEW OF RELEVANT LITERATURE
CHAPTER THREE
3.0 DESCRIPTION AND ANALYSIS OF THE PRESENT SYSTEM
3.1 Methodology
3.2 General Overview of student centralized database system approach
3.3 System Analysis
3.3.1 Analysis of the Existing System
3.3.2 Problem of the Existing System
3.3.3 Analysis of the proposed System
3.4 System Design
3.5 Input Layout
3.6 Data Flow Diagram
3.7 Database Structures
3.8 Database Structures
3.9 Centralized database design
CHAPTER FOUR
4.0 DESIGN AND IMPLEMENTATION
SYSTEM IMPLEMENTATION AND DOCUMENTATION
4.0 Introduction
4.1 Program Design
4.2 Choice of Programming Language
4.3 Programming Environment
4.4 Hardware Requirements
4.5 Hardware Requirements
4.6Implementation Codes and Design
4.7Program Flowchart
4.8Software testing
CHAPTER FIVE – SUMMARY, CONCLUSION AND RECOMMENDATION
5.0 Introduction
5.1 Constraints of the Study
5.2 Summary
5.3 Conclusion
5.4 Recommendation
CHAPTER FIVE
5.0 SUMMARY, RECOMMENDATION AND CONCLUSION
5.1 Summary
5.2 Recommendation
5.3 Conclusion
References
Appendix/source code
CHAPTER ONE
1.1 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 ?eld 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 ef?cient system (Terry Halpin, 2011)
Achievements in database research underpin fundamental advances in
communications systems, transportation and logistics, ?nancial
management, knowledge-based systems, accessibility to scienti?c
literature, and a host of other civilian and defense applications. They
also serve as the foundation for considerable progress in the basic
science ?elds 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
1.2 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 ?le. In contrast, thecentralized student information database
systemapproach attempts to eliminate the redundancy by integrating the
?les 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.
1.3 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.
1.4SIGNIFICANCE 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.
1.5 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.
1.6ORGANISATION 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, i.e. the software requirements, the hardware
requirements are specified
Chapter Five: contains summary, conclusion and recommendations for further studies.
1.7 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.
1.8 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: