|
ASQLAG - Automated SQL Assignment Grading System for Multiple DBMSs |
|---|---|
| รหัสดีโอไอ | |
| Creator | Areerat Trongratsameethong |
| Title | ASQLAG - Automated SQL Assignment Grading System for Multiple DBMSs |
| Contributor | Pakpoom Vichianroj |
| Publisher | Text and Journal Publication |
| Publication Year | 2561 |
| Journal Title | Journal of Technology and Innovation in Tertiary Education Siam technology College |
| Journal Vol. | vol.1 |
| Journal No. | no.1 |
| Page no. | no.42-62 |
| Keyword | Automated SQL Grader, Assignment Management Database, SQLines, Object-Oriented Design, Model-View-Controller. |
| URL Website | http://jti.siamtechno.ac.th |
| Website title | Journal of Technology and Innovation in Tertiary Education Siam technology College |
| ISSN | 2630-0540 |
| Abstract | Manual grading Structure Query Language (SQL) assignment is laborious and time consumed. Furthermore, one question may have many SQL statement styles having the same SQL result(s). Moreover, different Database Management Systems (DBMSs) may have different SQL statement syntaxes. This may cause error-prone and students may get feedback too late. Rapid feedback has significant on learning performance. If students and instructors get feedback faster they will have an opportunity to improve their practice and their teaching, respectively. The automated SQL assignment grading system was developed using Object-Oriented Design (OOD) technique and Model-View-Controller (MVC) framework. The system consists of two main parts: assignment management and automated SQL grader. Instructors can manage their assignment and student information conveniently anytime and anywhere via internet network. The automated SQL grader is designed to support four DBMSs: MariaDB, MySQL, PostgreSQL, and Microsoft SQL Server. Students can choose one of four supported DBMSs arbitrary to practice their SQL skills and their assignments can be submitted in one of the supported DBMS syntaxes. The automated SQL grader was implemented and tested. The results reveal that grading time compared to manual grading is reduced from many hours to a few seconds per one assignment. Studentsโ scores are a good indicator for students and instructors to improve their learning and teaching, respectively. The system is continued to run in next semester to collect more comments and requirements from database instructors. The automated SQL grader will be extended to enable to perform partial marking SQL statement in future. |
