Carleton University - School of Computer Science Honours Project
Winter 2020
SQL Automatic Grader System
Emmanuel Dairo
SCS Honours Project Image
ABSTRACT
The Automatic SQL Grade System allows you to calculate the F-1 score of given candidate query. The problem is there are different methods to execute insert/delete and select query. You have to identify the query type to execute it properly. This system allows you to give a file of queries including candidate queries and model answer queries. You can select multiple candidate files in order to calculate the score of queries by using F-1 Score formula, listed in these files. A candidate query is executed and compared against the execution of same query in model answer queries file. The score is calculated and saved in a csv file. Result.csv file contains the columns of filename and number of queries in that file. Each row contains the record of a file including filename and score of each query of that file. You are only required to select candidate file or multiple candidate files and one answer file, the system will automatically calculate the score and save the score in a csv file. So it is easy to execute queries and find their score.