Abstract

One of the major challenges facing prisons service especially in the developing countries like Nigeria is how to accurately and efficiently analyze the growing volume of prison inmate data. Nigerian Paramilitaries particularly the Nigerian Prison Service (NPS) Adamawa State command keep volumes of inmate data and information. Despite the enormously volume of data which is on the increase, the recordkeeping process remains manual; this does not assure proper safe keeping of inmate records. This study designed a database framework for the NPS Adamawa State command. The study analyzed the existing system of recordkeeping adopted by NPS which is the manual method of record keeping; developed a prototype database model; and designed a web application that would interact with the database. Before the main design, a comprehensive analysis of the existing system was carried out. 16 staff were interviewed for the exercise and the result showed the need for Nigerian Prison Service (NPS) Adamawa State command to have such robust database framework for accurate and efficient tracking of inmate data. The system was designed using Microsoft SQL server, MS Visual Studio. The researcher also used agile software development methodology and accomplished the development by the use of C-sharp, JavaScript, HTML 5 and Bootstrap CSS as tools. The system was tested using a workable prototype, and major recommendations were made. The researcher believes such a database framework should be deployed to Nigerian Prison Service (NPS) Adamawa State Command for full implementation. Findings of this work suggest that similar paramilitaries like the Nigerian Prison Services (NPS) should also incorporate a centralized database system into their process. Though further research needs to be conducted regarding the introduction of bio-metric fingerprinting as a means of tracking prison inmates in such organizations; this work is of the opinion that data warehousing of all prison data for the Nigerian Prison Service (NPS) as a whole is a necessary/vital way forward.

Highlights

  • Background of the StudyAs the technology evolution is taking place, there arose a need for centralization of prisoners’ record to facilitate information exchange and data sharing among prisons’ authorities

  • The house and every other structure located within the institution used for the purpose of detention. This led to the establishment of the first prison administration modeled on British tradition, and staffed by officers trained in the same tradition when the Governor, H

  • The Nigerian Prison Service, Yola Provincial Prison was established in the year 1914

Read more

Summary

Background of the Study

As the technology evolution is taking place, there arose a need for centralization of prisoners’ record to facilitate information exchange and data sharing among prisons’ authorities. This reduces administrative overheads, speed up responsiveness to users, reduce risks involved in inmates’ custody, eliminated obsolete processes and reap cost- cutting benefits. A comprehensive analysis of the existing system was carried out where 16 staff were interviewed for the exercise and the result showed the need for Nigerian Prison Service (NPS) Adamawa State command to have such robust database framework for accurate and efficient tracking of inmate data

Literature Review
Major Properties of Databases
Challenges in Database Technology
Database Models
Relational Model
Database Normalization
Data Query Language
Non-relational Database
Database Management Systems
Database Structure and Design
User Interface
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call