A Centralized Student Information Database System (CSIDS)
(A Case study of Elizade University)
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
Table of contents vii
1.0 CHAPTER ONE
1.2Statement of the Problem
1.4Signification Of The Study
1.6Organization of the project
1.8Definition Of Terms
2.0 REVIEW OF RELEVANT LITERATURE
3.0 DESCRIPTION AND ANALYSIS OF THE PRESENT SYSTEM
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
4.0 DESIGN AND IMPLEMENTATION
SYSTEM IMPLEMENTATION AND DOCUMENTATION
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
CHAPTER FIVE – SUMMARY, CONCLUSION AND RECOMMENDATION
5.1 Constraints of the Study
5.0 SUMMARY, RECOMMENDATION AND CONCLUSION
CHAPTER ONE 1.1 BACKGROUND TO THE STUDY
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:A CENTRALIZED STUDENT INFORMATION DATABASE SYSTEM