TABLE OF CONTENTS
Title Page……………………………………………………………………i
Approval Page……………………………………………………………….ii
Certification…………………………………………………………………iii
Declaration…………………………………………………………………..iv
Dedication……………………………………………………………………v
Acknowledgement……………………………………………………………vi
Abstract……………………………………………………………………….vii
Table of contents……………………………………………………………..viii
List of figures…………………………………………………………………xi
List of tables…………………………………………………………………..xii
CHAPTER ONE: INTRODUCTION
1.1 Introduction……………………………………………………………….1
1.2 Problem Statement…………………………………………………………2
1.3 Aim and Objectives……………………………………………………….2
1.4 Scope of the study…………………………………………………………3
1.5 Outline of Thesis……………………………………………………………3
3
CHAPTER TWO: THEORETICAL BACKGROUND
2.1 Introduction………………………………………………………………..4
2.2 Evolution of Database Technology…………………………………………6
2.3 The Database Management System………………………………………..9
2.4 Classification of Database Systems…………………………………………12
2.4.1 Hierarchical Database Model…………………………………….12
2.4.2 Network Database Model…………………………………………15
2.4.3 Relational Database Model……………………………………….17
2.4.4 Object Oriented Database Model…………………………………20
2.5 Comparison of Database System Model……………………………………21
2.6 Information Management Systems…………………………………………25
2.7 Types of Information Management Systems……………………………….25
2.7.1. Electronic Document Management System (EDMS)…………….25
2.7.2. Enterprise Resource Planning (ERP)…………………………….26
2.7.3. Product Lifecycle Management (PLM)………………………….26
2.7.4. Building Information Modeling (BIM)………………………….26
2.8 Justification of Database Structure Used in Thesis…………………………27
CHAPTER THREE: METHODOLOGY
3.1 Overview………….………………………………………………………..28
3.2 System Investigation Process……..…………………………………………30
3.3 Data Collection, Logical Analysis and Design……………………………..31
3.4 System Design and Implementation of DBI SIMS………………………..44
4
CHAPTER FOUR: TESTING AND RESULTS
4.1 System Testing………………………………………………………………….52
4.2 Results…………………………………………………………..………………52
4.3 Pilot Strategy and System Maintenance……………………………………..54
CHAPTER FIVE: SUMMARY AND CONCLUSIONS
5.1 Summary……………………………………………………………………..55
5.2 Contribution to Research……………………………………………………..55
5.3 Suggestions for Future Work…………………………………………………56
5.4 Conclusions…………………………………………………………………..57
REFERENCE………………………………………………………………………………………..58
Appendix A Coding for the Database and Application………………………………….60
5
CHAPTER ONE
1.1 Introduction
A major challenge facing academic institutions is the effective management of large
and varied data encountered in their day to day operations. These range from personal
data to various other types of documents. These data, with differing access privileges
and restrictions, are usually obtained from a variety of sources. The sources range
from the individuals themselves – for example a current student, applicant, a member
of the faculty, a member of the departmental administration, to data from transcripts,
or test scores for a student or an applicant. A good database will obviously be of great
advantage in managing the enormous information encountered and generated by such
institutions.
Data have been recognized as a valuable resource. This has led to an increased use of
database systems. A wide variety of models and techniques are available to aid in the
analysis and logical stages of developing appropriate database systems. Once a system
is defined at the logical stage, many other decisions have to be made to define the
design, operation and maintenance of the database system at the physical stage. A
good design, at the logical or physical stage is a major determinant in the organization
of a good database [1].
8
1.2 Problem Statement
Effective management of large amount and different types of data encountered in
daily operations is a major challenge facing academic institutions.
1. Presently, Digital Bridge Institute (DBI) Student Records Office uses a manual,
paper-based filing system as data repository.
2. Accessing/Retrieving information manually is difficult and time consuming.
3. Human error during the process of manually collecting, analyzing, updating and
reporting data is also a problem in using this system.
1.3 Aim and Objectives
Aim
This work aims to develop an electronic database system, free from the shortcomings
of a manual paper-based filing system, for Digital Bridge Institute, Abuja.
Objectives
The specific objectives are:
1. To develop an application prototype for displaying, managing, retrieving, and
processing information for users.
2. To develop a database that enables information to be updated or deleted by
authorized users.
3. To develop an application that can be used to search for information in the
database.
4. To develop a user authentication security system enforced by login name and
password.
9
1.4 Scope of the study
This work focuses on the development and implementation of a fully functional SIMS
for DBI Student Record Office. Details of the system are outlined below:
1. The architecture of the system is client-server architecture.
2. Student’s information can be added, updated, deleted only by authorized users.
3. Information about a student can be searched for.
4. Views that allow each user to see and access only the data that they have
authorization for, can be displayed.
5. All information on the student can be displayed via the application interface on the
client computer.
6. System security is enforced by login name and password to ensure that only
authorized users can access this database system.
1.5 Outline of Thesis
Chapter 1 has outlined the Introduction, Aims and Objectives, Problem Statement,
and Study Scope of this work. Chapter 2 explains the theoretical concept of database.
Different database systems are defined, compared and contrasted. The evolution of
database technology is also outlined. The chapter ends with a justification of the
database system used in this thesis. Chapter 3 outlines the methodology used to
implement the SIMS. Chapter 4 details the testing of the developed system and
results. Chapter 5, the conclusion, provides a summary of this work.
Recommendations on possible areas of future research are also outlined in this final
chapter.
IF YOU CAN'T FIND YOUR TOPIC, CLICK HERE TO HIRE A WRITER»
