Automated Grading of SQL Statements

Automated Grading of SQL Statements<br> =================================== #### Introduction All experimental data are stored in Submission.sqlite, which is an SQLite<br> database file. It is recommended to use software such as DB browser or SQLite<br> expert to explore the database. Tables related to SQL statements submitted by students<br> ------------------------------------------------------ Tables with names beginning with 'exercise_' are all related to SQL statements,<br> and two of them are most important. One is the exercise_result table, which<br> records most of the information related to the SQL statements submitted by<br> students, and the other is the exercises_exercise table, which records most of<br> the information related to exercises. **The student submissions are stored in<br> the 'submitted_answer' field of the exercise_result data table.** Table 1 Description of exercise_result table. | Field | comment | datatype |<br> |------------------|--------------------------------------------|----------|<br> | submission_id | Submission ID | INT |<br> | submitted_answer | SQL statement submitted by student | TEXT |<br> | submitted_time | Time of submission | NUM |<br> | answer | Reference statement provided by tutors | TEXT |<br> | exercise_id | Exercise ID | INT |<br> | is_correct | Mark whether the statement is correct | INT |<br> | student_id | Student ID | INT |<br> | type | Classification of statement | TEXT |<br> | difficulty | The difficulty coefficient of the exercise | INT | Table 2 Description of exercises_exercise table. | Field | comment | datatype |<br> |-------------|---------------------------------|----------|<br> | id | Exercise ID | INT |<br> | short_title | short title of exercise | TEXT |<br> | preamble | description of exercise | TEXT |<br> | difficulty | coefficient of difficulty | integer |<br> | visible | whether the exercise is visible | boolean |<br> | priority | the priority of exercise | integer | Table 3 Description of exercises_benchmark table. | Field | comment | datatype |<br> |---------------|-------------------------|----------|<br> | Submission_id | Submission ID | INT |<br> | grade | grade provided by tutor | REAL |<br> | tutor | tutor name | TEXT | Table 4 Description of exercises_grade table. | Field | comment | datatype |<br> |------------------|---------------------------------------------|----------|<br> | submission_id | Submission ID | INT |<br> | submitted_answer | SQL statement submitted by student | TEXT |<br> | grade | provided by different approach | REAL |<br> | approach | approach name | TEXT |<br> | most_similar | most similar statement to current statement | TEXT | ------------------------------------------------------ Please refer to db_schema.pdf for the database schema used in the experiment.<br>