Blogs (1) >>

This program is tentative and subject to change.

Fri 28 Feb 2025 16:03 - 16:22 at Meeting Room 406 - Database Courses

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 Feb

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

15:45 - 17:00
Database CoursesPapers at Meeting Room 406
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