摘要
只有在具体的数据库环境中进行练习才能真正学会SQL语言。主要针对MS SQL SERVER数据库管理系统环境设计了一个基于B/S结构的SQL语言的自动练习及测试系统,该系统在学生练习完毕后能及时自动评判并给出反馈。自动评判的实现分两步执行:(1)在数据库环境中执行参考答案与学生给出的练习答案,比较执行结果,执行结果非空,则直接判断正误;(2)否则,在(1)基础上辅以简单的语法分析来判断。实际运行结果表明,本系统能较好满足SQL语言的教学需求。
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 a SQL language automatic exercise system for SQL SERVER database. Its main difficulty is to determine the correctness of the SQL statements. This automatic evaluation algorithm performed in two steps: (1) execute SQL statements directly, if the result set is not empty, then judge directly; (2) if the execution result set is empty, using a simple syntax analysis auxiliary judge. Thus issues get a satisfactory solution.
出处
《宁波工程学院学报》
2013年第4期67-72,共6页
Journal of Ningbo University of Technology
基金
全国教育技术课题(项目编号:136241033)
浙江省远程教育课题(项目编号:DES-12Y04)
宁波市教育规划课题(项目编号:YGH078)