论文部分内容阅读
When learning SQL language,students must practice to improve their practical ability to grasp it.It is important to judge the students practices and to give timely feedback for improving students learning motivation and ability.This system mainly designs an SQL language automatic exercise system for MS SQL SERVER database.The main difficulty is to determine the correctness of the SQL statements.This automatic evaluation algorithm performs in two steps : (1) execute SQL statements directly;(2)compare the two execution results, if consistent,judge correct or not.The successful implementation of the algorithm must ensure the implementation of the reference results not to be empty.This system will execute the reference answer when adding a problem, and automatically judge whether the related table existed or not.If not existed, the system will let the teacher user create the table and input related records.Or the problem can not be saved to the problem bank.There are two groups of students in the experiment, one group practice in the system, and the other do not.Students practicing in the system get a better mastery of knowledge than those who do not practice in the system.