Implementation of Code Runner for SQL tasks in Database Course

Abstract

The primary objective of this thesis was to improve database course learning and teaching techniques and deliver the model in a way that would benefit both teachers and students. The research questions were about enhancing learning and teaching methods, the benefits and limitations of the model, and practical implantation. These tasks were accomplished with the help of CodeRunner and SQL, and how we use them in tandem to construct tasks are the primary theoretical topics, and that is where research questions are also addressed. A practical section that explains the steps taken to complete the work is then included, which covers the last research question of beneficial implantation. This thesis only considers the SQL component of creating tasks using Code Runner, all other languages that can be used with CodeRunner is purposefully left out as this thesis is primarily concerned with using SQL. The practical work supported the entire procedure's theoretical component as this thesis's primary method. The model's database was created using SQLite, built using CodeRunner, and then deployed on the Moodle platform. Online-supported documents, articles, books, and videos were the main research tools. The case study concludes that this model is advantageous in many aspects of learning and teaching practices. It will enable the user to utilize time-saving strategies and integrate all available tools and approaches to building an auto-grading SQL-based Database course.