Published: 2024-12-01
Development of a Web-Based SQL Query Online Examination System with Automated Grading Using the MVC Design Pattern
DOI: 10.35870/ijsecs.v4i3.3285
Downloads
Abstract
In this study, the Researchers provide the design, development, and evaluation of a web-based SQL exam system that utilizes the Model-View-Controller (MVC) architectural pattern to enhance automated grading functionality and ease of maintenance. The main objectives of the system are to simplify the process of administering SQL exams, to make it user-friendly for students to enter their SQL statements, and as a means for teachers to automate the grading process. This allows a clear separation between three separate modules: Model to manage data, View to present the application to users, and Controller to manage the application logic. This separation allows for modular development, easier maintenance, and code reuse. The fundamental aspect of the system lies in its automated grading mechanism, which intelligently compares the SQL queries submitted by students with the corresponding validated answer keys stored in the database. Extensive black-box testing was conducted to ensure the reliability and accuracy of the system with various test cases to assess its ability to assess responses and provide real-time feedback to students, in addition to smooth and intuitive navigation within the system. All testing criteria yielded successful results with 100% agreement proving the robustness of the system with all possible locations that could potentially be used in higher education structures. The system provides a scalable and flexible approach to address the challenges associated with SQL assessment in academic institutions, thereby facilitating uniform, efficient, and objective evaluation standards. The system uses data up to October 2023 to prevent the model from becoming obsolete
Keywords
Web-based SQL Examination System ; Automated Grading ; Model-View-Controller (MVC) Design Pattern ; Online Assessment ; SQL Query Evaluation
Article Information
This article has been peer-reviewed and published in the International Journal Software Engineering and Computer Science (IJSECS). The content is available under the terms of the Creative Commons Attribution 4.0 International License.
-
Issue: Vol. 4 No. 3 (2024)
-
Section: Articles
-
Published: %750 %e, %2024
-
License: CC BY 4.0
-
Copyright: © 2024 Authors
-
DOI: 10.35870/ijsecs.v4i3.3285
AI Research Hub
This article is indexed and available through various AI-powered research tools and citation platforms. Our AI Research Hub ensures that scholarly work is discoverable, accessible, and easily integrated into the global research ecosystem. By leveraging artificial intelligence for indexing, recommendation, and citation analysis, we enhance the visibility and impact of published research.
Yoppy Yunhasnawa
D4 Informatics Engineering, Politeknik Negeri Malang, Malang City, East Java Province, Indonesia
Atif Windawati
D4 Islamic Banking, Politeknik Negeri Semarang, Semarang City, Central Java Province, Indonesia
Toga Aldila Cinderatama
D4 Informatics Engineering, Politeknik Negeri Malang, Malang City, East Java Province, Indonesia
Candra Bella Vista
D4 Informatics Engineering, Politeknik Negeri Malang, Malang City, East Java Province, Indonesia
Moch. Zawaruddin Abdullah
D4 Informatics Engineering, Politeknik Negeri Malang, Malang City, East Java Province, Indonesia
-
Revathi, D. A. R., Bhuvaneswaran, R., Arshath, K. M., Prakash, U. H., & Aravinth, M. L. (2020). OVERVIEW OF DATABASE EVOLUTION AND ELEVATION. International Journal of Advance Research and Innovative Ideas in Education, 6, 422–428.
-
Ambasana, J., Sahasrabudhe, S., & Iyer, S. (2023, December). SQL-Wordle: Gamification of SQL Programming Exercises. In Proceedings of the ACM Conference on Global Computing Education Vol 2 (pp. 190-190). https://doi.org/10.1145/3617650.3624949
-
Teate, R. M. P. (2021). The SELECT statement. In SQL for data scientists: A beginner's guide for building datasets for analysis (pp. 15-32). John Wiley & Sons. https://doi.org/10.1002/9781119669388.ch2
-
Kidman, G., & Chang, C. H. (2022). Assessment and evaluation in geographical and environmental education. International Research in Geographical and Environmental Education, 31(3), 169-171. https://doi.org/10.1080/10382046.2022.2105499
-
Cladera, M. (2021). An application of importance-performance analysis to students’ evaluation of teaching. Educational Assessment, Evaluation and Accountability, 33(4), 701-715. https://doi.org/10.1007/s11092-020-09338-4
-
Butler-Henderson, K., & Crawford, J. (2020). A systematic review of online examinations: A pedagogical innovation for scalable authentication and integrity. Computers & Education, 159, 104024. https://doi.org/10.1016/j.compedu.2020.104024
-
Du-xiang, W. (2009). Using ASP and SQL Server 2000 the Development of Online Examination System. Computer Knowledge and Technology.
-
Wongtanuwat, W., & Senivongse, T. (2020, July). Detection of Violation of MVVM Design Pattern in Objective-C Programs. In Proceedings of the 8th International Conference on Computer and Communications Management (pp. 54-58). https://doi.org/10.1145/3411174.3411193
-
Freeman, A., & Freeman, A. (2015). The singleton pattern. Pro Design Patterns in Swift, 113-136. https://doi.org/10.1007/978-1-4842-0394-1_6
-
McDonough, J. E., & McDonough, J. E. (2017). Factory Design Patterns. Object-Oriented Design with ABAP: A Practical Approach, 173-190. https://doi.org/10.1007/978-1-4842-2838-8_14
-
Freeman, A., & Freeman, A. (2015). The Observer Pattern. Pro Design Patterns in Swift, 447-472. https://doi.org/10.1007/978-1-4842-0394-1_22
-
McDonough, J. E., & McDonough, J. E. (2017). Observer Design Pattern. Object-Oriented Design with ABAP: A Practical Approach, 155-171. https://doi.org/10.1007/978-1-4842-2838-8_13
-
Zhou, K. (2020). Application Method of Struts Framework Based on MVC Design Pattern. https://doi.org/10.25236/ictmic.2020.133
-
Haitao, L. (2011). Application of MVC Design Pattern in JSP Development. Computer Programming Skills & Maintenance.
-
Wanjiru, B., van Bommel, P., & Hiemstra, D. (2022). Dynamic and Partial Grading of SQL Queries. Journal of Emerging Network and Research Systems. [Online]. Available: https://www.jenrs.com/publications/JENRS_0308001.pdf
-
Kovacic, Z. J., & Green, J. (2012). Automatic grading of spreadsheet and database skills. Journal of information Technology Education. Innovations in practice, 11, 53.
-
Al-Salmi, A. (2019). Semi-automatic assessment of basic SQL statements (Doctoral dissertation, Loughborough University). Available: https://core.ac.uk/download/pdf/288353187.pdf
-
Kleiner, C., & Heine, F. (2024). Enhancing Feedback Generation for Autograded SQL Statements to Improve Student Learning. In Proceedings of the 2024 on Innovation and Technology in Computer Science Education V. 1 (pp. 248-254). Available: https://dl.acm.org/doi/abs/10.1145/3649217.3653579
-
Kleerekoper, A., & Schofield, A. (2018, July). SQL tester: an online SQL assessment tool and its impact. In Proceedings of the 23rd annual ACM conference on innovation and technology in computer science education (pp. 87-92). Available: https://e-space.mmu.ac.uk/620119/1/SQL
-
Rushby, J. (1993). Formal methods and the certification of critical systems (Vol. 37). SRI International, Computer Science Laboratory. Available: http://www.csl.sri.com/~rushby/papers/csl-93-7.pdf
-
Yang, Y., Xia, X., Lo, D., & Grundy, J. (2022). A survey on deep learning for software engineering. ACM Computing Surveys (CSUR), 54(10s), 1-73. https://doi.org/10.1145/3505243.
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.