American Journal of Software Engineering and Applications

| Peer-Reviewed |

Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana

Received: 05 September 2014    Accepted: 16 September 2014    Published: 21 April 2015
Views:       Downloads:

Share This Article

Abstract

The success of any organization such as School of Public Health, University of Ghana hinges on its ability to acquire accurate and timely data about its operations, to manage this data effectively, and to use it to analyze and guide its activities. Integrated student database system offer users (Student, Registrar, HOD) with a unified view of data from multiple sources. To provide a single consistent result for every object represented in these data sources, data fusion is concerned with resolving data inconsistency present in the heterogeneous sources of data. The main objective of this project is to build a rigid and robust integrated student database system that will track and store records of students. This easy-to-use, integrated database application is geared towards reducing time spent on administrative tasks. The system is intended to accept process and generate report accurately and any user can access the system at any point in time provided internet facility is available. The system is also intended to provide better services to users, provide meaningful, consistent, and timely data and information and finally promotes efficiency by converting paper processes to electronic form. The system was developed using technologies such as PHP, HTML, CSS and MySQL. PHP, HTML and CSS are used to build the user interface and database was built using MySQL. The system is free of errors and very efficient and less time consuming due to the care taken to develop it. All the phases of software development cycle are employed and it is worthwhile to state that the system is very robust. Provision is made for future development in the system.

DOI 10.11648/j.ajsea.20150402.11
Published in American Journal of Software Engineering and Applications (Volume 4, Issue 2, April 2015)
Page(s) 23-34
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

Relational Database, Interoperability, Database Management System, phpMyAdmin, MySQL Server, Data Redundancy, Middleware

References
[1] Connolly, T.M. and C.E. Begg, 2004. Database System: A Practical Approach to Design, Implementation and Management. 4rd Edn., Addison Wesley; ISBN: 10: 0321210255, pp: 1236
[2] Adams, C., Beath, C. M, Bolan, R., Branin, J., D’Elia, G., Rhode, N.L. & Straub, D. 1991. Issues Relating to the Implementation and Management of an Integrated Information Centre. Journal of the American Society for Information Science.
[3] Adman, P. & Warren, L. 1996. Information systems management: Perspectives for Higher Education. Lancs: Mir Press
[4] Angell, I. O. & Smithson, S. 1991. Information Systems management: Opportunities and Risks. London: Macmillan Education Ltd.
[5] Association for the Development of Education in African. 2001. Technology as a Management Tool: A New Approach and Implementation. http//www.technologia.org/ [accessed on 23rd May 2011].
[6] Greenwald, R., R. Stackowiak, G. Dodge, D. Klein, B. Shapiro and C.G. Ghelliah, 2005. Professional Oracle Programming. Wrox, ISBN: 10: 0764574825, pp: 790
[7] Blaha M Rumbaugh 2005 (2nd ed.) Object-Oriented Modeling and Design with UML. [Basically this is the second edition of Rumbaugh et al 1991]. Prentice Hall
[8] Fry B. G. 1997. The Family Educational Rights and Privacy Act of 1974. In Student Records Management, edited by M Theresa Ruzicka and Beth Lee WeckMulle. London: Greenwood Press, 43-76.
[9] Higgins, J.C. 1976. Information Systems for Planning and Control: Concepts and Cases. London: Edward Arnold.
[10] Husain, K.M. 1977. Information Systems: Basic Concepts, Management Information Systems for Higher Education. Paris: The Organization for Economic Co-operation and Development.
[11] Gerald, C.O. 2009. Database Management System. Nigeria National Open University.
[12] Kroenke, D. & Hatach, R. 1994. Management Information Systems, 3rd edition. New York: McGraw-Hill.
[13] Oliver, R. (2000). Creating Meaningful Contexts for Learning in Web-based Settings. Proceedings of Open Learning 2000. (pp 53-62). Brisbane: Learning Network, Queensland.
[14] Jonassen, D. & Reeves, T. (1996). Learning with technology: Using computers as cognitive tools. In D. Jonassen (Ed.), Handbook of Research Educational on Educational Communications and Technology (pp 693-719). New York: Macmillan.
[15] Lebow, D. (1993). Constructivist values for instructional systems design: Five principles toward a new mind set. Educational Technology, Research and Development, 41(3), 4-16.
[16] Berners-Lee, T. J. 1992. "World-Wide Web: Information Universe", Electronic: Research, Applications and Policy. www.w3.org/People/Berners-Lee/Longer.html [accessed on 24th May 2011]
[17] Collis, B. (2002). Information technologies for education and training. In Adelsberger, H., Collis, B, & Pawlowski, J. (Eds.) Handbook on Technologies for Information and Training. Berlin: Springer Verlag.
Author Information
  • Department of Epidemiology and Biostatistics, School of Public Health, University of Health and Allied Sciences, Ho, Ghana

  • Department of Biostatistics, School of Public Health, University of Ghana, Accra, Ghana

Cite This Article
  • APA Style

    Wisdom Kwami Takramah, Wisdom Kwasi Atiwoto. (2015). Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana. American Journal of Software Engineering and Applications, 4(2), 23-34. https://doi.org/10.11648/j.ajsea.20150402.11

    Copy | Download

    ACS Style

    Wisdom Kwami Takramah; Wisdom Kwasi Atiwoto. Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana. Am. J. Softw. Eng. Appl. 2015, 4(2), 23-34. doi: 10.11648/j.ajsea.20150402.11

    Copy | Download

    AMA Style

    Wisdom Kwami Takramah, Wisdom Kwasi Atiwoto. Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana. Am J Softw Eng Appl. 2015;4(2):23-34. doi: 10.11648/j.ajsea.20150402.11

    Copy | Download

  • @article{10.11648/j.ajsea.20150402.11,
      author = {Wisdom Kwami Takramah and Wisdom Kwasi Atiwoto},
      title = {Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana},
      journal = {American Journal of Software Engineering and Applications},
      volume = {4},
      number = {2},
      pages = {23-34},
      doi = {10.11648/j.ajsea.20150402.11},
      url = {https://doi.org/10.11648/j.ajsea.20150402.11},
      eprint = {https://download.sciencepg.com/pdf/10.11648.j.ajsea.20150402.11},
      abstract = {The success of any organization such as School of Public Health, University of Ghana hinges on its ability to acquire accurate and timely data about its operations, to manage this data effectively, and to use it to analyze and guide its activities. Integrated student database system offer users (Student, Registrar, HOD) with a unified view of data from multiple sources. To provide a single consistent result for every object represented in these data sources, data fusion is concerned with resolving data inconsistency present in the heterogeneous sources of data. The main objective of this project is to build a rigid and robust integrated student database system that will track and store records of students. This easy-to-use, integrated database application is geared towards reducing time spent on administrative tasks. The system is intended to accept process and generate report accurately and any user can access the system at any point in time provided internet facility is available. The system is also intended to provide better services to users, provide meaningful, consistent, and timely data and information and finally promotes efficiency by converting paper processes to electronic form. The system was developed using technologies such as PHP, HTML, CSS and MySQL. PHP, HTML and CSS are used to build the user interface and database was built using MySQL. The system is free of errors and very efficient and less time consuming due to the care taken to develop it. All the phases of software development cycle are employed and it is worthwhile to state that the system is very robust. Provision is made for future development in the system.},
     year = {2015}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Student Database System for Higher Education: A Case Study at School of Public Health, University of Ghana
    AU  - Wisdom Kwami Takramah
    AU  - Wisdom Kwasi Atiwoto
    Y1  - 2015/04/21
    PY  - 2015
    N1  - https://doi.org/10.11648/j.ajsea.20150402.11
    DO  - 10.11648/j.ajsea.20150402.11
    T2  - American Journal of Software Engineering and Applications
    JF  - American Journal of Software Engineering and Applications
    JO  - American Journal of Software Engineering and Applications
    SP  - 23
    EP  - 34
    PB  - Science Publishing Group
    SN  - 2327-249X
    UR  - https://doi.org/10.11648/j.ajsea.20150402.11
    AB  - The success of any organization such as School of Public Health, University of Ghana hinges on its ability to acquire accurate and timely data about its operations, to manage this data effectively, and to use it to analyze and guide its activities. Integrated student database system offer users (Student, Registrar, HOD) with a unified view of data from multiple sources. To provide a single consistent result for every object represented in these data sources, data fusion is concerned with resolving data inconsistency present in the heterogeneous sources of data. The main objective of this project is to build a rigid and robust integrated student database system that will track and store records of students. This easy-to-use, integrated database application is geared towards reducing time spent on administrative tasks. The system is intended to accept process and generate report accurately and any user can access the system at any point in time provided internet facility is available. The system is also intended to provide better services to users, provide meaningful, consistent, and timely data and information and finally promotes efficiency by converting paper processes to electronic form. The system was developed using technologies such as PHP, HTML, CSS and MySQL. PHP, HTML and CSS are used to build the user interface and database was built using MySQL. The system is free of errors and very efficient and less time consuming due to the care taken to develop it. All the phases of software development cycle are employed and it is worthwhile to state that the system is very robust. Provision is made for future development in the system.
    VL  - 4
    IS  - 2
    ER  - 

    Copy | Download

  • Sections