IMPLEMENTATION OF A STUDENT INFORMATION DATABASE FOR DIGITAL BRIDGE INSTITUTE

ABSTRACT

Effective  management  of large amount and different types of data encountered  in daily operations is a major challenge facing academic institutions. Traditional paper based operation is not only costly, but also ineffective. Based on the requirements of the Student  Records  Office,  a student  information  management  system  (SIMS)  is designed and implemented for Digital Bridge Institute (DBI) in this work. The system is developed to provide DBI with a means to effectively manage its information. It minimizes the need to maintain hard copy files as it stores, sorts and compares data relevant to all DBI students. The DBI SIMS also provides a secure interface for DBI Staff  to  directly  access  all  aspects  of  students’  academic  records.  The  SIMS  is designed using Microsoft’s Structured Query Language Server 2005 (MSSQL Server

2005). A generic database system was first designed using the five standard phases of Systems  Development  Life  Cycle  (SDLC),  definition,  requirements,  evaluation, design  and  implementation  phases.  The  DBI  SIMS  database  was  subsequently developed  from  the  designed  generic  database  system  using  web  utility  classes developed specifically for the database. DBI Students Record Office staff were used to confirm the viability of SIMS following a test run of the system. KEY WORDS: DBI, SIMS, Information, System, Management, Database.

CHAPTER ONE

INTRODUCTION

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].

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.

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.

₦5,000.00 – DOWNLOAD FULL PROJECT DOWNLOAD FULL PROJECT Added to cart

---

---

---

---

---

Related Project Topics :