The Design And Implementation Of An Automatic Marking System For SQL Server Test

With the continuous improvement of social information, training and assessment of thepopularity of computer application ability has become an industry. In the examination, theautomatic marking system is replacing the traditional manpower marking system gradually.Now the automatic marking system may finish the marking task of objective problemssuccessfully. But there still exist some difficulties in the marking task of operationproblems.Now, with the development of enterprises the database technology has been widelyapplied and thus become an important part of computer literacy training and assessment. Alarge number of small and medium-sized enterprises and home users to use SQL Server infuture trainingwill occupy an increasingly important position. SQL Server evaluationAutomatic Marking System for the purpose of the assessment of the achievement of theSQL Server program automatically Review to reduce marking workload, reduce the impactof subjective factors in the manual scoring, improve the fairness of the Review process andassociate. Article on the system design ideas, methods and technology used in a systematicexposition of the exploration and feasibility study of the Word and Excel automaticallymarking.Automatic marking system is a strong theoretical and practical issue which adapts thepopularity of computer application development, training and assessment, taking intoaccount the syntax analysis, human-computer interaction, information response and manyother technical problems. With the improvement of the level of social information, in theenterprise database technology is playing an increasingly important role. For enterprises,database not only means data storage, but also often more represent of the decision aid andsupport tools. With the continuous improvement of business needs, database technology hasmade rapid development, from early-level database, network database, to the still widelyused relational database, to object database and object-relational hybrid database, databasetechnology has a bright future. Therefore, in the computer skills training, to join theteaching of the database part is very meaningful.In the evaluation process, marking the examination papers is a crucial part and the workload is very huge. In the Computer Proficiency Test, in order to test the candidate’sknowledge and mastery, the form of the operation questions is more appropriate than themultiple-choice questions, which can more objectively reflect the actual operating capacity.But unfortunately, the work of marking papers in the operation questions is still finished largelythrough the traditional manual scoring, which not only needs to pay a great human andmaterial resources, bus also can not obtain satisfactory results. Its drawbacks are a longcycle time of marking and poor real-time, prone to error and relatively large scoring error.Meantime, this method can not avoid the personnel subjective impact, and it is difficult toguarantee the fairness of grading.If we can realize the automatic computer assessment marking, it can not only greatlyreduce the marking workload, but also can improve the accuracy of scoring process,objectivity and timeliness. Therefore, the automatic marking system has good social values,and it is bound to become a future trend of assessment evaluation.In the evaluation of "SQL Server" and "foreign trade e-business applications ", notonly theoretical knowledge are taught, also students’ practical ability are trained. So, it isnecessary to test trainees’ practical ability by operating question. Therefore, under theguidance of my teacher, the automatic marking system for SQL Server test was developed.Through the research on the automatic scoring of titles of operating SQL Server, from thetheoretical and practical, this subject was carried out a detailed analysis and in-depthresearch.There is variety of existing database systems, ranging from high-end Oracle, to the endof the Mysql, and then to low-end SQL Server, although their operation interfaces aredifferent and one’s actual performance is different from others’, the concept of database isthe same. In the future, it will provide very valuable reference to other automatic scoringissues of database systems through developing the automatic marking system of SQLServer test.This system is designed and developed for automatically marking the SQL Server test,its design goals is to design a common database for automatic marking system of SQLServer test.In this paper, the sources, background and research significance of the topic wereintroduced. Then a general overview of the system was described, the feasibility of thissystem was discussed, including object-oriented systems analysis, analysis method andcharacteristics of the system. Then the domino effect, the demarcation of knowledge pointand prevention of the domino effect were introduced. The feasibility of automatic marking system for SQL Server test was analyzed, and the basic idea and design method weredetermined. Then in this paper, needs analysis of this system was presented, includingdevelopment tools needs, functional requirements analysis and system workflowdescription. After the demand analysis was given in the paper, the mainly design of thissystem was described, including the SQL Server DMO object analysis, system moduledivision and analysis of marking methods. Finally, the system design in detail andimplementation were given, including analysis of the characteristics of each object,marking method of each object and the ways to judge.