Computer assisted assessment of sql query skills

Conferences in Research and Practice in Information Technology Series

Volumn 63, Issue , 2007, Pages 53-62

  Dekeyser, Stijn ^a   de Raadt, Michael ^a   Lee, Tien Yu ^a  

^a UNIVERSITY OF SOUTHERN QUEENSLAND   (Australia)

Author keywords

Computer assisted learning and assessment; Conjunctive queries; Query equivalence; SQL

Indexed keywords

AUTOMATIC ASSESSMENT; COMPUTER ASSISTED ASSESSMENT; COMPUTER ASSISTED LEARNING; CONJUNCTIVE QUERIES; DATA BASE THEORY; DATABASE COURSE; HIGHER EDUCATION; LEARNING EXPERIENCES; PEER REVIEW; QUERY EQUIVALENCE; QUERY STATEMENTS; RELATIONAL DATABASE; SQL; SQL QUERY; STATE OF THE ART; STRUCTURED QUERY LANGUAGES;

COMPUTER AIDED INSTRUCTION; QUERY PROCESSING; SEMANTICS; STUDENTS; TEACHING;

QUERY LANGUAGES;

EID: 84872844972     PISSN: 14451336     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Article

References (20)

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.
5. Thomas Connolly and Carolyn Begg. Database Systems - A Practical Approach to Design, Implementation, and Management. Addison Wesley, fourth edition, 2005.
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.
10. R. Kearns, S. Shead and A. Fekete. A teaching system for SQL. In Proceedings of ACSE '97, pages 224-231, Melbourne, July 1997.
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.
12. Michael Kiefer, Arthur Bernstein and Philip Lewis. Database Systems - An Application-Oriented Approach. Addison Wesley, second edition, 2006.
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.
14. Antonija Mitrovic. Learning SQL with a computerized tutor. In Proceedings of SIGCSE'98, pages 307-311, Atlanta, Georgia, February 1998.
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.
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.
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.
20. Abraham Silberschatz, Henry Korth and S. Sudarshan. Database System Concepts. McGraw-Hill, fifth edition, 2006.