Database Framework for Nigerian Prison Service, Adamawa State, Command

Emeje Gideon Daniel; Thomas Labiga Laban; Shallmombol Gabriel Ldutsi

doi:doi:10.11648/j.ajcst.20200303.11

| Peer-Reviewed

Database Framework for Nigerian Prison Service, Adamawa State, Command

Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi

Published in American Journal of Computer Science and Technology (Volume 3, Issue 3)

Received: 14 January 2020 Accepted: 3 February 2020 Published: 9 June 2020

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

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.

Published in	American Journal of Computer Science and Technology (Volume 3, Issue 3)
DOI	10.11648/j.ajcst.20200303.11
Page(s)	38-45
Creative Commons	This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.
Copyright	Copyright © The Author(s), 2024. Published by Science Publishing Group

Keywords

Database Framework, Relational Model, Normalization

References

[1]	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.
[2]	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.
[3]	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.
[4]	Paul, B. (2013). Database Management System 3rd Edition. Published by Palgrave Houndmills, Basingstoke, Hampshire, RG216XS. New York.
[5]	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.
[6]	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.
[7]	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.
[8]	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.
[9]	Royce, W. (1970), "Managing the Development of Large Software Systems", Proceedings of IEEE WESCON.
[10]	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 https://www.ibm.com/developerworks/community/files/basic/anonymous/api/library/94bf907e-ea 05- 439a-be58-c1252ca742ae/document/0f84d12d-35bd-4681-8b79-fe42e1e2638a/media on 12/01/2020.
[11]	Murugan, R. (2008). Prison File Monitoring System. International Journal of Recent Engineering Research and Development (IJRERD), 1 (5), 5-8.
[12]	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).
[13]	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) http://ijcjournal.org/.
[14]	Dittrich, K. (2000). “Databases in Software Engineering: A Roadmap,” Department of Information Technology, University of Zurich, Winterthurerstr. 190 CH-8057 Zurich, Switzerland.
[15]	Ebel, F., et al. (2008). “Festo Learning Systems: Automation Technology”, Festo Corporation, United States of America, 2008.
[16]	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.
[17]	Ballard, C. (1998). “Data Modeling Techniques for Data Warehousing,” IBM Corporation, International Technical Support Organization, California, February 1998.
[18]	Stajano, F. (1998). “A Gentle Introduction to Relational and Object Oriented Databases,” ORL Technical Report TR-98-2, Cambridge, United Kingdom, 1998.
[19]	Tatamcgraw-Hill (2006) “Introduction to database management systems,” Tata McGraw-Hill Publishing Company Limited, Delhi, 2006, ISBN: 0-07-059119-9.
[20]	Ferreira C. & Cohen J. (2008), Agile systems development and stakeholder satisfaction: a South African empirical study, retrieved from https://dl.acm.org/doi/10.1145/1456659.1456666.
[21]	Alam, F. (2015). Data Migration: Relational Rdbms To Non-Relational Nosql. M. Sc. Thesis, Ryerson University, Toronto, Ontario, Canada.
[22]	Harrington, J. (2009). Relational Database Design and Implementation: Clearly Explained. Burlington: Morgan Kaufmann Publishers, 2009.
[23]	Kavanagh, D. “Relating to Amazon SimpleDB.” March 4, 2008. Web. 28 April 2011. .

Cite This Article

Plain Text BibTeX RIS

APA Style

Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi. (2020). Database Framework for Nigerian Prison Service, Adamawa State, Command. American Journal of Computer Science and Technology, 3(3), 38-45. https://doi.org/10.11648/j.ajcst.20200303.11

Copy | Download

ACS Style

Emeje Gideon Daniel; Thomas Labiga Laban; Shallmombol Gabriel Ldutsi. Database Framework for Nigerian Prison Service, Adamawa State, Command. Am. J. Comput. Sci. Technol. 2020, 3(3), 38-45. doi: 10.11648/j.ajcst.20200303.11

Copy | Download

AMA Style

Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi. Database Framework for Nigerian Prison Service, Adamawa State, Command. Am J Comput Sci Technol. 2020;3(3):38-45. doi: 10.11648/j.ajcst.20200303.11

Copy | Download

@article{10.11648/j.ajcst.20200303.11,
  author = {Emeje Gideon Daniel and Thomas Labiga Laban and Shallmombol Gabriel Ldutsi},
  title = {Database Framework for Nigerian Prison Service, Adamawa State, Command},
  journal = {American Journal of Computer Science and Technology},
  volume = {3},
  number = {3},
  pages = {38-45},
  doi = {10.11648/j.ajcst.20200303.11},
  url = {https://doi.org/10.11648/j.ajcst.20200303.11},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajcst.20200303.11},
  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.},
 year = {2020}
}

Copy | Download

TY  - JOUR
T1  - Database Framework for Nigerian Prison Service, Adamawa State, Command
AU  - Emeje Gideon Daniel
AU  - Thomas Labiga Laban
AU  - Shallmombol Gabriel Ldutsi
Y1  - 2020/06/09
PY  - 2020
N1  - https://doi.org/10.11648/j.ajcst.20200303.11
DO  - 10.11648/j.ajcst.20200303.11
T2  - American Journal of Computer Science and Technology
JF  - American Journal of Computer Science and Technology
JO  - American Journal of Computer Science and Technology
SP  - 38
EP  - 45
PB  - Science Publishing Group
SN  - 2640-012X
UR  - https://doi.org/10.11648/j.ajcst.20200303.11
AB  - 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.
VL  - 3
IS  - 3
ER  -

Copy | Download

Author Information

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

Download PDF

Sections

Plain Text BibTeX RIS

APA Style

Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi. (2020). Database Framework for Nigerian Prison Service, Adamawa State, Command. American Journal of Computer Science and Technology, 3(3), 38-45. https://doi.org/10.11648/j.ajcst.20200303.11

Copy | Download

ACS Style

Emeje Gideon Daniel; Thomas Labiga Laban; Shallmombol Gabriel Ldutsi. Database Framework for Nigerian Prison Service, Adamawa State, Command. Am. J. Comput. Sci. Technol. 2020, 3(3), 38-45. doi: 10.11648/j.ajcst.20200303.11

Copy | Download

AMA Style

Emeje Gideon Daniel, Thomas Labiga Laban, Shallmombol Gabriel Ldutsi. Database Framework for Nigerian Prison Service, Adamawa State, Command. Am J Comput Sci Technol. 2020;3(3):38-45. doi: 10.11648/j.ajcst.20200303.11

Copy | Download

@article{10.11648/j.ajcst.20200303.11,
  author = {Emeje Gideon Daniel and Thomas Labiga Laban and Shallmombol Gabriel Ldutsi},
  title = {Database Framework for Nigerian Prison Service, Adamawa State, Command},
  journal = {American Journal of Computer Science and Technology},
  volume = {3},
  number = {3},
  pages = {38-45},
  doi = {10.11648/j.ajcst.20200303.11},
  url = {https://doi.org/10.11648/j.ajcst.20200303.11},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ajcst.20200303.11},
  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.},
 year = {2020}
}

Copy | Download

TY  - JOUR
T1  - Database Framework for Nigerian Prison Service, Adamawa State, Command
AU  - Emeje Gideon Daniel
AU  - Thomas Labiga Laban
AU  - Shallmombol Gabriel Ldutsi
Y1  - 2020/06/09
PY  - 2020
N1  - https://doi.org/10.11648/j.ajcst.20200303.11
DO  - 10.11648/j.ajcst.20200303.11
T2  - American Journal of Computer Science and Technology
JF  - American Journal of Computer Science and Technology
JO  - American Journal of Computer Science and Technology
SP  - 38
EP  - 45
PB  - Science Publishing Group
SN  - 2640-012X
UR  - https://doi.org/10.11648/j.ajcst.20200303.11
AB  - 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.
VL  - 3
IS  - 3
ER  -

Copy | Download