Development of a Web-Based SQL Query Online Examination System with Automated Grading Using the MVC Design Pattern
DOI:
https://doi.org/10.35870/ijsecs.v4i3.3285Keywords:
Web-based SQL Examination System, Automated Grading, Model-View-Controller (MVC) Design Pattern, Online Assessment, SQL Query EvaluationAbstract
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
Downloads
References
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.
Downloads
Published
Issue
Section
Categories
License
Copyright (c) 2024 Yoppy Yunhasnawa, Atif Windawati, Toga Aldila Cinderatama, Candra Bella Vista, Moch. Zawaruddin Abdullah
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.
