RSQLG: The Reverse SQL Question Generation Algorithm

Abstract

Nowadays, the people who learn and teach SQL commands require to get a hand-on practice with real environment to make the learning effective. The creating SQL exercise is a time-consuming task for instructors. As a result, students might not get enough questions to meet their demands. The reverse SQL question generation algorithm (RSQLG) is developed to solve this problem. The RSQLG has ability to automatically generate SQL exercise for students. The RSQLG can reverse the manual question creation process which starts from creating question to start creating query answer first instead. The RSQLG considers the existing data and database structure by using various constraints. The instructors also can specify the language, format and explanation of the questions. The RSQLG supports DML commands - SELECT, INSERT, UPDATE and DELETE - and support data retrieval from multiple tables which perform by JOIN and subquery operations. The algorithm has ability to generate bulk questions with less effort. The instructor is not required to writing requirements and validating the queries. The RSQLG can be implemented in e-learning to enhance sustainable practices and improve learning outcome for students.