An Automatic Correction Tool for Relational Algebra Queries

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.

[1]  Carolyn E. Begg,et al.  Database Systems: A Practical Approach to Design, Implementation and Management , 1998 .

[2]  Kirby McMaster,et al.  Teaching Relational Algebra and Relational Calculus : A Programming Approach , 2008 .

[3]  Abhir Bhalerao,et al.  A computer-based environment for the study of relational query languages , 2003 .

[4]  Abraham Silberschatz,et al.  Database System Concepts , 1980 .

[5]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[6]  Ramez Elmasri,et al.  Fundamentals of database systems (2nd ed.) , 1994 .

[7]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[8]  David Taniar,et al.  Computational Science and Its Applications - ICCSA 2006, International Conference, Glasgow, UK, May 8-11, 2006, Proceedings, Part I , 2006, ICCSA.

[9]  J. Soler,et al.  An automatic correction tool for relational database schemas , 2005, 2005 6th International Conference on Information Technology Based Higher Education and Training.

[10]  Ferran Prados,et al.  A Web-Based Tool for Entity-Relationship Modeling , 2006, ICCSA.

[11]  Abraham Silberschatz,et al.  Database Systems Concepts , 1997 .

[12]  Jordi Ripoll,et al.  A tool for the continuous assessment and improvement of the student's skills in a mathematics course , 2002 .

[13]  F. E..  A Relational Model of Data Large Shared Data Banks , 2000 .

[14]  Mary Ann Robbert,et al.  Trends in the evolution of the database curriculum , 2003, ITiCSE '03.

[15]  Suzanne W. Dietrich,et al.  WinRDBI: a Windows-based relational database educational tool , 1997, SIGCSE '97.

[16]  J. Soler,et al.  A teaching/learning support tool for introductory programming courses , 2004, Information Technology Based Proceedings of the FIfth International Conference onHigher Education and Training, 2004. ITHET 2004..

[17]  Ferran Prados,et al.  A web-based problem-solving environment for database normalization , 2006 .