Blogs (5) >>

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.

Fri 28 Feb

Displayed time zone: Eastern Time (US & Canada) change

15:45 - 17:00
Database Courses and Inclusive ComputingPapers at Meeting Room 406
Chair(s): Kyrie Zhixuan Zhou University of Illinois Urbana-Champaign
15:45
18m
Talk
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
18m
Talk
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
18m
Talk
A critical approach to ChatGPT: an experience in SQL learning
Papers
Laura Farinetti Politecnico di Torino, Luca Cagliero Politecnico di Torino
16:41
18m
Talk
Supporting Inclusive Computing: A Graduate Course to Prepare Future Faculty
Papers
Kari George University of Illinois at Urbana-Champaign