Efficient Database Design and Implementation of Students Academic Results Processing System (SARPS)

Taiwo Olusegun Ojeyinka*, Matthew Olusegun Afolabi **
* Department of Computer Science, Adekunle Ajasin University, Akungba-Akoko, Ondo, Nigeria.
** Department of Physics & Electronics, Adekunle Ajasin University, Akungba-Akoko, Ondo, Nigeria.
Periodicity:December - February'2020
DOI : https://doi.org/10.26634/jcom.7.4.16849

Abstract

A huge amount of time is spent on manual vetting of processed results to resolve errors in the output generated from the computerization of students academic results for higher institutions in Nigeria. This is not only for salient errors that can be discovered during the verification of results, but also for inconspicuous errors that pass through computed results unnoticed. Such errors can be attributed to errors associated with technical designs of the database and non- compliance of results processing with the institution's rules and study requirements, especially when such rules and requirements are violated. Currently, such errors, in most cases, are often resolved by manual vetting after processing. Some technical issues need to be resolved for reliable computerization of student results. This study provides design solutions that guarantee the correctness and responsiveness of result outputs without manual intervention in computerizing the academic results of the students. The results show that such design approaches save the time spent on manual vetting of computerized results and ensure the reliability of the processing system. Some technical issues are identified and corrected in the development of the system, in addition to the computations of the semester and cumulative GPAs.

Keywords

Database Design, Design Errors, Normalisation, Results Processing.

How to Cite this Article?

Ojeyinka, T. O., & Afolabi, M. O. (2020). Efficient Database Design and Implementation of Students Academic Results Processing System (SARPS). i-manager's Journal on Computer Science, 7(4), 1-23. https://doi.org/10.26634/jcom.7.4.16849

References

[1]. Alameri, I. A., & Radchenko, G. (2017). Development of student information management system based on cloud computing platform. Journal of Applied Computer Science & Mathematics, 11(2), 4-19. https://doi.org/10. 4316/JACSM.201702001
[2]. Amare, S., Yirgalem, T., Tesfamaryam, T., Samirawit, A., Dagimawit, G., Mentesinot, T., & Prince T. (2018). Centralized school management system for government schools in ethiopia using distributed database. International Journal of Engineering Trends and Technology (IJETT). 60(2), 97-101. https://doi.org/10.1 4445/ 22315381/ IJE TT-V60P213
[3]. Añulika, E. A., Bala, E., & Nyap, C. D. (2014). Design and Implementation of result processing system for public secondary schools in Nigeria. International Journal of Computer and Information Technology, 3(01), 120-127. Retrieved from https://www.ijcit.com/ archives/ volume3/issue1/ Paper030119.pdf
[4]. Boparai, G. S., & Kumar, S. (2014). Analysis of query using join and semi-join analysis. International Journal of Advanced Research in Computer and Communication Engineering, 3(11), 8379-8383.
[5]. Bowers, K. (2017). The Disadvantages of Manual Document Filing Processes. Retrieved from https:// blog.mesltd.ca/the-disadvantages-of-manual-document-filing-processes
[6]. Cadar, C., Teytelman, L., & Trusova, E. (2013). Secure and Convenient Computerized Transcript System: 6.033 Design Project. Retrieved from http://citeseerx. ist.psu. edu/viewdoc/download?doi=10.1.1.2.2320&rep= rep1&type=pdf
[7]. Codd, E. F. (1971). Further Normalization of the Data Base Relational Model. Published in IBM Research Report, San Jose, California (pp. 33-64).
[8]. Coronel, C., & Morris S. (2016). Database Systems: Design, Implementation, & Management. Cengage Learning (12th Ed.). Cengage Learning.
[9]. Currim, S., Ram, S., Durcikova, A., & Currim, F. (2014). Using a knowledge learning framework to predict errors in database design. Information Systems, 40, 11-31. https://doi.org/10.1016/j.is.2013.08.001
[10]. Dar, S. A. (2018). Result processing: Issues and solutions. International Journal of Engineering Sciences & Research Technology, 7 (4), 267-269.
[11]. Eludire, A. A. (2011). The design and implementation of student academic record management system. Research Journal of Applied Sciences, Engineering and Technology, 3(8), 707-712.
[12]. Harrington J. L. (2016). Relational Database Design and Implementation (4th ed.). Morgan Kaufmann. https://doi.org/10.1016/B978-0-12-804399-8.00041-7
[13]. IBM Corporation (October 2013). IBM Information Management System (IMS) 13 Transaction and Database Servers delivers high performance and low total cost of ownership. Retrieved from https://www-01.ibm.com/ common/ssi/cgi-bin/ssialias?infotype=an&subtype= ca&appname=gpateam&supplier=897&letternum=EN US213-381
[14]. James, A. (2014). Automated students result management system using Oracle's database, forms and reports. Journal of Information Engineering and Applications, 4(11), 1-11.
[15]. Lambert, J., & Frye, C., (2015). Microsoft Office 2016 st Step-by-Step Learning Kit (1 Ed.). Microsoft Press.
[16]. Lawal, I. B. (2018). Development of Computerized Students' Results Processing System. International Journal of Scientific & Engineering Research, 9(4), 730-740.
[17]. Mallig, N. (2010). A relational database for bibliometric analysis. Journal of Informetrics, 4(4), 564- 580. https://doi.org/10.1016/j.joi.2010.06.007
[18]. Matemilayo, D. O., Kamaldeen, R. A., Samson, O. F., Tajudeen, Y. I., & Olarenwaju, S. T. (2017). Design and implementation of an integrated result processing system in a networked environment. Biomedical Statistics and Informatics, 2(4), 131-137.
[19]. Nicolaos, P., & Katerina, T. (2015). Simple-talking database development: Let the end-user design a relational schema by using simple words. Computers in Human Behavior, 48: 273-289. https://doi.org/ 10.1016/j. chb.2015.02.002
[20]. Olivera L. (2019). Everything you Need to Know about (Relational) Databases. Retrieved from https://dev.to/lmolivera/everything-you-need-to-knowabout- relational-databases-3ejl
[21]. Omilabu, A. A., Usman, O. L., Alaba, O. B., & Adedeji, O. B. (2015). Digital repository and automated result processing system: An implementation. Journal of Science Education and Research, 1(2), 107-122. Retrieved from https://ghanjol.org.gh/index.php/ jser/article/view/427
[22]. Sinthusan P. (2019). Best Practice Guide for Microsoft SQL Server with ONTAP. Technical Report. Retrieved from https://www.netapp.com/us/media/tr- 4590.pdf
[23]. TechTarget (n.d). Entity Relationship Diagram. Retrieved from https://searchdatamanagement. techtarget.com/definition/entity-relationship-diagram-ERD
[24]. Teorey T., Lightstone S., Nadeau T. & Jagadish H, V. (2011). Database Modeling and Design, Logical Design. (5th Ed.) Elsevier. https://doi.org/ 10.1016/C2009-0-62960- 3
[25]. Tutorialspoint. (2019a). Database Management System Tutorial. Retrieved from https://www.tutorial spoint.com/dbms/dbms_data_ recovery.htm
[26]. Tutorialspoint.(2019b). Structured Query Language (SQL). Retrieved from https://www.tutorial spoint.com/sql/ index.htm
[27]. Udeze C. L., Umoren P. U., Oheri H. E. and Attah H. H. (2017). Automated students' results management information system (SRMIS). Journal of Multidisciplinary Engineering Science and Technology, 4(10), 8587-8601.
[28]. Ukem, E. O., & Ofoegbu, F. A. (2012). A software application for university students results processing. Journal of Theoretical and Applied Information Technology, 35(1), 34-43.
[29]. Wang W. (2001). Storage Management in RDBMS. Department of Computer Science. The University of Saskatchewan.
[30]. Waqas, A., Mahessar, A. W., Mahmood, N., Bhatti, Z., Karbasi, M., & Shah, A. (2015). Transaction Management Techniques and Practices In Current Cloud Computing Environments: A Survey. International Journal of Database Management Systems, 7(1), 41-59. https://doi.org/ 10.5121/ijdms.2015.7104
[31]. Watt A. (2018). Classification of database management systems. In Database Design (2nd Ed.). Retrieved from https://opentextbc.ca/dbdesign01/ chapter/chapter-6-classification-of-database-systems/
If you have access to this article please login to view the article or kindly login to purchase the article

Purchase Instant Access

Single Article

North Americas,UK,
Middle East,Europe
India Rest of world
USD EUR INR USD-ROW
Pdf 35 35 200 20
Online 35 35 200 15
Pdf & Online 35 35 400 25

Options for accessing this content:
  • If you would like institutional access to this content, please recommend the title to your librarian.
    Library Recommendation Form
  • If you already have i-manager's user account: Login above and proceed to purchase the article.
  • New Users: Please register, then proceed to purchase the article.