My team and I are planning to do an online course exam database platform, The main task is judge SQL statements, but the question is How system judge the correctness of SQL statements submitted by students?
Especially for how to judge the establishment of a database structure, or stored procedures?
the system uses ASP.NET + SqlServer because it is an internal system so that you can ignore some efficiency issues; We mainly consider the judgment capacity of the system.
I hope you can give me some ideas, thank you.
Here is an example:
Q: Please Create a stored procedure to query all of the records in the table.
Students then enter SQL statements and submit, and the system will return the result of the judgement.