Database Framework for Nigerian Prison Service, Adamawa State, Command
American Journal of Computer Science and Technology
Volume 3, Issue 3, September 2020, Pages: 38-45
Received: Jan. 14, 2020; Accepted: Feb. 3, 2020; Published: Jun. 9, 2020
Views 273      Downloads 104
Emeje Gideon Daniel, Department of Computer Science, Modibbo Adama University of Technology, Yola, Nigeria
Thomas Labiga Laban, Department of Computer Science, Modibbo Adama University of Technology, Yola, Nigeria
Shallmombol Gabriel Ldutsi, Department of Information Technology, Modibbo Adama University of Technology, Yola, Nigeria
Article Tools
Follow on us
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.
Database Framework, Relational Model, Normalization
To cite this article
Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi, Database Framework for Nigerian Prison Service, Adamawa State, Command, American Journal of Computer Science and Technology. Vol. 3, No. 3, 2020, pp. 38-45. doi: 10.11648/j.ajcst.20200303.11
Copyright © 2020 Authors retain the copyright of this article.
This article is an open access article distributed under the Creative Commons Attribution License ( which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Onyekachi J (2016). Problems and Prospects of Administration of Nigerian Prison: Need for Proper Rehabilitation of the Inmates in Nigeria Prisons. J Tourism Hospit 5: 228. doi: 10.4172/2167-0269.1000228.
Oye, N. D. and Ibrahim Inuwa. (2015). Prison Inmate Information System: The Case of Yola Central Prison, Nigeria. West African Journal of Industrial and Academic Research April 2015 Vol. 13 No. 1.
Chen, H., Chung, W., Xu, J. J., Wang, G., Qin, Y., and Chau, M. (2004). Crime Data Mining: A General Framework and Some Examples. Computer, 37 (4), 50-56.
Paul, B. (2013). Database Management System 3rd Edition. Published by Palgrave Houndmills, Basingstoke, Hampshire, RG216XS. New York.
Obunadike G. N. and R. K. (2013) “A Frame Work For Data Warehouse For Nigerian Police Force” Department of Mathematical Sciences and IT, Federal University, Dutsin-ma, Katsina State, Nigeria.
Sani H. M. and Yabo M. M. (2015), A Database System Security Framework. International Journal of Computer Science & Information Technology (IJCSIT) Vol 7, No 6. DOI: 10.5121/ijcsit.2015.7614.
Hitest. K. S., Shastri A. and Ranjit B. (2012) “AFramework for Automated Database Tuning using Dynamic SGA Parameters and Basic Operating System Utilities”. Database Systems Journal”, Academy of Economic Studies-Bucharest, Romania.
Obunadike G. N. and Ume A. (2014) “Leveraging Data Mining and Data Warehouse to Improve Prison Services and Operations in Nigeria” Department of Mathematical Sciences and IT, Federal University, Dutsin-ma, Katsina State, Nigeria.
Royce, W. (1970), "Managing the Development of Large Software Systems", Proceedings of IEEE WESCON.
Amol G. C., Prashant V. B., Swapnil N. C. and Priyanka V. G. (2010), Prison Management System. J. T. Mahajan College of Engineering, Faizpur. Maharashtra. Retrieved from 05- 439a-be58-c1252ca742ae/document/0f84d12d-35bd-4681-8b79-fe42e1e2638a/media on 12/01/2020.
Murugan, R. (2008). Prison File Monitoring System. International Journal of Recent Engineering Research and Development (IJRERD), 1 (5), 5-8.
Akpojaro, J. and Omogbhemhe, M. I. (2017), A Conceptual Design of Information System for Prison Management in Nigeria. Asian Journal of Mathematics and Computer Research 15 (2): 131-140, 2017 ISSN: 2395-4205 (P), ISSN: 2395-4213 (O).
Ahishakiyea, E., Taremwab, D. and Elisha O. O. (2017). A Secure Web Based Records Management System for Prisons: A Case of Kisoro Prison in Uganda International Journal of Computer (IJC) ISSN 2307-4523 (Print & Online)
Dittrich, K. (2000). “Databases in Software Engineering: A Roadmap,” Department of Information Technology, University of Zurich, Winterthurerstr. 190 CH-8057 Zurich, Switzerland.
Ebel, F., et al. (2008). “Festo Learning Systems: Automation Technology”, Festo Corporation, United States of America, 2008.
Parawee, P. (2015). Database centric software test management framework for test metrics. Faculty of Computer Science, Department of Computer Engineering Technische University ät Chemnitz, June 2015.
Ballard, C. (1998). “Data Modeling Techniques for Data Warehousing,” IBM Corporation, International Technical Support Organization, California, February 1998.
Stajano, F. (1998). “A Gentle Introduction to Relational and Object Oriented Databases,” ORL Technical Report TR-98-2, Cambridge, United Kingdom, 1998.
Tatamcgraw-Hill (2006) “Introduction to database management systems,” Tata McGraw-Hill Publishing Company Limited, Delhi, 2006, ISBN: 0-07-059119-9.
Ferreira C. & Cohen J. (2008), Agile systems development and stakeholder satisfaction: a South African empirical study, retrieved from
Alam, F. (2015). Data Migration: Relational Rdbms To Non-Relational Nosql. M. Sc. Thesis, Ryerson University, Toronto, Ontario, Canada.
Harrington, J. (2009). Relational Database Design and Implementation: Clearly Explained. Burlington: Morgan Kaufmann Publishers, 2009.
Kavanagh, D. “Relating to Amazon SimpleDB.” March 4, 2008. Web. 28 April 2011. .
Science Publishing Group
1 Rockefeller Plaza,
10th and 11th Floors,
New York, NY 10020
Tel: (001)347-983-5186