Relational Database Courses with CodeRunner in Moodle: Extending SQL Programming Assignments to Client-Server Database EnginesGlobal
This program is tentative and subject to change.
Students practice Data Query, Manipulation, and Definition Language statements in a standard introductory relational database course. When teaching large classes, the teacher needs to review many student solutions. Doing it by hand is laborious. However, this task can be quickly and accurately completed using a learning management system (LMS). Moodle is a widely used LMS that can be enhanced with the CodeRunner plugin to facilitate the evaluation of programming tasks. Unfortunately, a basic setup supports only the embedded database engine SQLite, which often is not the preferred choice for a course of this type. We present an open-source implementation that extends CodeRunner with popular client-server database engines, i.e., Microsoft SQL Server, MySQL, and PostgreSQL. Our method checks the correctness of a student’s query in terms of output and validates the query by investigating the parse tree derived from the grammar of a given Structured Query Language (SQL) dialect. We present the system’s evaluation results during a database course along with the implementation.
This program is tentative and subject to change.
Fri 28 FebDisplayed time zone: Eastern Time (US & Canada) change
15:45 - 17:00 | |||
15:45 18mTalk | Understanding the Impact of Using Generative AI Tools in a Database Course Papers Valeria Ramirez Osorio University of Toronto Mississauga, Angela Zavaleta Bernuy University of Toronto, Bogdan Simion University of Toronto Mississauga, Michael Liut University of Toronto Mississauga | ||
16:03 18mTalk | Relational Database Courses with CodeRunner in Moodle: Extending SQL Programming Assignments to Client-Server Database EnginesGlobal Papers Andrzej Wójtowicz Adam Mickiewicz University in Poznań, Maciej Prill Adam Mickiewicz University in Poznań | ||
16:22 18mTalk | A critical approach to ChatGPT: an experience in SQL learning Papers |