An automatic correction tool for relational algebra queries

Authors:
Josep Soler;Imma Boada;Ferran Prados;Jordi Poch;Ramon Fabregat
Affiliations:
Departament Informàtica i Matemàtica Aplicada, Universitat de Girona, Spain;Departament Informàtica i Matemàtica Aplicada, Universitat de Girona, Spain;Departament Informàtica i Matemàtica Aplicada, Universitat de Girona, Spain;Departament Informàtica i Matemàtica Aplicada, Universitat de Girona, Spain;Institut d'Informàtica i Aplicacions, Universitat de Girona, Spain
Venue:
ICCSA'07 Proceedings of the 2007 international conference on Computational science and Its applications - Volume Part II
Year:
2007

Citing 6
Cited 1

WinRDBI: a Windows-based relational database educational tool

SIGCSE '97 Proceedings of the twenty-eighth SIGCSE technical symposium on Computer science education
A relational model of data for large shared data banks

Communications of the ACM
Trends in the evolution of the database curriculum

Proceedings of the 8th annual conference on Innovation and technology in computer science education
Database Systems Concepts

Database Systems Concepts
Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)

Database Systems: A Practical Approach to Design, Implementation and Management (4th Edition)
A web-based tool for entity-relationship modeling

ICCSA'06 Proceedings of the 6th international conference on Computational Science and Its Applications - Volume Part I

Ideas in Teaching, Learning and Assessment of Databases: A Communication of the 7thInternational Workshop on Teaching, Learning and Assessment of Databases (TLAD 2009)

BNCOD 26 Proceedings of the 26th British National Conference on Databases: Dataspace: The Final Frontier

Quantified Score

Hi-index	0.00

Visualization

Abstract

Relational algebra is one of the main topics covered in undergraduate computer science database courses. In this paper, we present a web-based tool designed to automatically correct relational algebra queries. The tool is integrated in a more general e-learning environment and is used to reinforce teaching and learning on introductory database courses. A teacher enters relational algebra problems into the system and it generates personalized workbooks with different relational algebra exercises for each student. Students solve these exercises using a specifically designed interface. They enter relational algebra expressions to solve the assigned queries and the system provides immediate feedback and, when there are errors, advise about how to correct them. Only a web browser is required to use the tool, which has been used in our university with very promising results.