The Design and Implement of Automatic SQL Exercise System for MS SQL Server
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.
Index Terms-SQL automatic exercise system computer network instruct
Xueyan ZHANG
Department of Information Technology Ningbo TV & Radio University, China
国内会议
浙江金华
英文
59-69
2014-08-17（万方平台首次上网日期，不代表论文的发表时间）