Quiz Generating for SQL Command and Checking Answer Automatically

Abstract

Structure Query Language (SQL) Command is a basic outstanding statement for developing application program. In a class room, variety of quiz examples is necessary for practice creating command and searching answer. Students can use the product of Database Management System (DBMS) as self-learn tutorial. However, they put incorrect command and cannot edit by themselves because DBMS shows only the first error. Thus, this research aims to develop 2 systems, 1) quiz generating system for SQL Command from quiz master as examples for practice, and then 2) answer checking system for searching each part (SELECT, FROM, WHERE, GROUP BY, ORDER BY) and show each error in order to let student know the correct command.  The eight quiz masters were tried out with 43 students with 2 times per a student and 11 quizzes per time as well as create individual 946 quizzes. Average creating a quiz time was 2.56 seconds and checking answer time was 12.85 seconds.