Article

Free access

Computer assisted assessment of SQL query skills

Authors:

Stijn Dekeyser,

Michael de Raadt,

Tien Yu LeeAuthors Info & Claims

ADC '07: Proceedings of the eighteenth conference on Australasian database - Volume 63

Pages 53 - 62

Published: 30 March 2007 Publication History

Abstract

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.

References

[1]

Serge Abiteboul, Richard Hull and Victor Vianu. Foundations of Database Systems. Addison Wesley, 1997.

[2]

B. Bloom. Taxonomy of Educational Objectives. Edwards Bros., Ann Arbor, Michigan, 1956.

[3]

C. Brook and R. Oliver. Online learning communities: Investigation a design framework. Australian Journal of Educational Technology, Volume 19, Number 2, pages 139--160, 2003.

[4]

Ashok Chandra and Philip Merlin. Optimal implementation of conjunctive queries in relational data bases. In Proceedings of the ninth annual ACM symposium on Theory of computing, pages 77--90, Boulder, Colorado, 1977.

Digital Library

[5]

Thomas Connolly and Carolyn Begg. Database Systems -- A Practical Approach to Design, Implementation, and Management. Addison Wesley, fourth edition, 2005.

Digital Library

[6]

Michael de Raadt, Mark Toleman and Richard Watson. Electronic peer review: A large cohort teaching themselves? In Proceedings of the 22nd Annual Conference of the Australasian Society for Computers in Learning in Tertiary Education (ASCILITE'05), pages 159--168, Brisbane, December 2005.

[7]

Michael de Raadt, Mark Toleman and Richard Watson. An effective system for electronic peer review. International Journal of Business and Management Education, Volume 13, Number 9, pages 48--62, 2006.

[8]

Stijn Dekeyser, Michael de Raadt and Tien Yu Lee. SQLify project website. Technical report, 2006. http://www.sci.usq.edu.au/projects/sqlify/.

[9]

Suzanne Dietric, Eric Eckert and Kevin Piscator. WinRDBI -- a Windows-based relational database educational tool. In Proceedings of SIGCSE '97, pages 126--130, San Jose, California, March 1997.

Digital Library

[10]

R. Kearns, S. Shead and A. Fekete. A teaching system for SQL. In Proceedings of ACSE '97, pages 224--231, Melbourne, July 1997.

Digital Library

[11]

Claire Kenny and Claus Pahl. Automated tutoring for a database skills training environment. In Proceedings of SIGCSE'05, pages 59--62, St. Louis, Missouri, February 2005.

Digital Library

[12]

Michael Kiefer, Arthur Bernstein and Philip Lewis. Database Systems -- An Application-Oriented Approach. Addison Wesley, second edition, 2006.

Digital Library

[13]

J. Kurhila, M. Miettinen, P. Nokelainen, P. Floreen and H. Tirri. Peer-to-peer learning with open-ended writable web. In Proceedings of the 8th Annual Conference on Innovation and Technology in Computer Science Education, pages 173--178, Thessaloniki, Greece, June 2003.

Digital Library

[14]

Antonija Mitrovic. Learning SQL with a computerized tutor. In Proceedings of SIGCSE'98, pages 307--311, Atlanta, Georgia, February 1998.

Digital Library

[15]

Miguel Penabad. General Procedure to Test Conjunctive Query Containment. Ph.D. thesis, Universidade da Coruña, 2002.

[16]

Julia Prior and Raymond Lister. The backwash effect on SQL skills grading. In Proceedings of ITiCSE'04, pages 32--36, Leeds, UK, June 2004.

Digital Library

[17]

Shazia Sadiq, Maria Orlowska, Wasim Sadiq and Joe Lin. SQLator---an online SQL learning workbench. In Proceedings of ITiCSE'04, pages 223--227, Leeds, UK, June 2004.

Digital Library

[18]

D. Saunders. Peer tutoring in higher education. Studies in Higher Education, Volume 17, Number 2, pages 211--218, 2006.

[19]

Ben Shneiderman. Improving the human factors aspect of database interactions. ACM Transactions on Database Systems, Volume 3, Number 4, pages 417--439, 1978.

Digital Library

[20]

Abraham Silberschatz, Henry Korth and S. Sudarshan. Database System Concepts. McGraw-Hill, fifth edition, 2006.

Digital Library

Cited By

Kleerekoper ASchofield APolycarpou IRead JAndreou PArmoni M(2018)SQL tester: an online SQL assessment tool and its impactProceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education10.1145/3197091.3197124(87-92)Online publication date: 2-Jul-2018
https://dl.acm.org/doi/10.1145/3197091.3197124
Kawash JRutherfoord BLi LVan de Ven SSettle ASteinbach T(2014)Formulating second-order logic conditions in SQLProceedings of the 15th Annual Conference on Information technology education10.1145/2656450.2656452(115-120)Online publication date: 14-Oct-2014
https://dl.acm.org/doi/10.1145/2656450.2656452
Kleiner CTebbe CHeine FLaakso MSimon (2013)Automated grading and tutoring of SQL statements to improve student learningProceedings of the 13th Koli Calling International Conference on Computing Education Research10.1145/2526968.2526986(161-168)Online publication date: 14-Nov-2013
https://dl.acm.org/doi/10.1145/2526968.2526986
Show More Cited By

Index Terms

Computer assisted assessment of SQL query skills
1. Theory of computation

Index terms have been assigned to the content through auto-classification.

Recommendations

SQL tester: an online SQL assessment tool and its impact
ITiCSE 2018: Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education

Learning SQL can be surprisingly difficult, given the relative simplicity of its syntax. Automated tools for teaching and assessing SQL have existed for over two decades. Early tools were only designed for teaching and offered increased feedback and ...
Equivalence of SQL queries in presence of embedded dependencies
PODS '09: Proceedings of the twenty-eighth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

We consider the problem of finding equivalent minimal-size reformulations of SQL queries in presence of embedded dependencies [1]. Our focus is on select-project-join (SPJ) queries with equality comparisons, also known as safe conjunctive (CQ) queries, ...
Translating SQL Into Relational Algebra: Optimization, Semantics, and Equivalence of SQL Queries

In this paper, we present a translator from a relevant subset of SQL into relational algebra. The translation is syntax-directed, with translation rules associated with grammar productions; each production corresponds to a particular type of SQL ...

Comments

Information & Contributors

Information

Published In

cover image DL Hosted proceedings

ADC '07: Proceedings of the eighteenth conference on Australasian database - Volume 63

March 2007

158 pages

ISBN:1920682449

Publisher

Australian Computer Society, Inc.

Australia

Publication History

Published: 30 March 2007

Author Tags

Qualifiers

Article

Conference

ADC '07

ADC '07: Australasian database

January 30 - February 2, 2007

Victoria, Ballarat, Australia

Acceptance Rates

Overall Acceptance Rate 98 of 224 submissions, 44%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

5
Total Citations
View Citations
694
Total Downloads

Downloads (Last 12 months)49
Downloads (Last 6 weeks)9

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Kleerekoper ASchofield APolycarpou IRead JAndreou PArmoni M(2018)SQL tester: an online SQL assessment tool and its impactProceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education10.1145/3197091.3197124(87-92)Online publication date: 2-Jul-2018
https://dl.acm.org/doi/10.1145/3197091.3197124
Kawash JRutherfoord BLi LVan de Ven SSettle ASteinbach T(2014)Formulating second-order logic conditions in SQLProceedings of the 15th Annual Conference on Information technology education10.1145/2656450.2656452(115-120)Online publication date: 14-Oct-2014
https://dl.acm.org/doi/10.1145/2656450.2656452
Kleiner CTebbe CHeine FLaakso MSimon (2013)Automated grading and tutoring of SQL statements to improve student learningProceedings of the 13th Koli Calling International Conference on Computing Education Research10.1145/2526968.2526986(161-168)Online publication date: 14-Nov-2013
https://dl.acm.org/doi/10.1145/2526968.2526986
Langeveldt WLink S(2010)Empirical evidence for the usefulness of Armstrong relations in the acquisition of meaningful functional dependenciesInformation Systems10.1016/j.is.2009.11.00235:3(352-374)Online publication date: 1-May-2010
https://dl.acm.org/doi/10.1016/j.is.2009.11.002
de Raadt MLai DWatson RLister R(2007)An evaluation of electronic individual peer assessment in an introductory programming courseProceedings of the Seventh Baltic Sea Conference on Computing Education Research - Volume 8810.5555/2449323.2449330(53-64)Online publication date: 15-Nov-2007
https://dl.acm.org/doi/10.5555/2449323.2449330

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents