Dekeyser, Stijn and de Raadt, Michael and Lee, Tien Yu (2007) Computer assisted assessment of SQL query skills. In: 18th Australasian Database Conference (ADC 2007), 29 Jan-2 Feb 2007, Ballarat, Australia.
PDF (Published Version)
Structured Query Language (SQL) is the dominant language for querying relational databases today, and is an essential topic in introductory database courses in higher education. Even though the language is syntactically simple, relatively concise, and highly structured, students experience many difficulties while learning to express queries in SQL. In recent years a small number of software tools have been proposed to help students learn to write query statements and to assess their querying skills. In this paper we compare and evaluate existing tools mainly from the perspective of database theory and practice, but also from a pedagogical perspective. Addressing the deficiencies and opportunities uncovered by the evaluation, we then introduce SQLify, a new tool that extends the current state of the art by incorporating semantic feedback, enhanced automatic assessment based on database theory, and peer review to arrive at a richer learning experience for students, as well as consistent assessment results and reduced marking for instructors.
|Item Type:||Conference or Workshop Item (Commonwealth Reporting Category E) (Paper)|
|Additional Information:||Deposited in accordance with the copyright policy of the publisher. Copyright c 2007, Australian Computer Society, Inc. This paper appeared at Eighteenth Australasian Database Conference (ADC2007), Ballarat, Australia. Conferences in Research and Practice in Information Technology, Vol. 63. James Bailey and Alan Fekete, Ed. Reproduction for academic, not-for profit purposes permitted provided this text is included.|
|Uncontrolled Keywords:||computer assisted learning and assessment; SQL; conjunctive queries; query equivalence|
|Subjects:||280000 Information, Computing and Communication Sciences|
|Depositing User:||Dr. Stijn Dekeyser|
|Date Deposited:||11 Oct 2007 00:36|
|Last Modified:||02 Jul 2013 22:36|
Actions (login required)
|Archive Repository Staff Only|