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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Codd, E.F.: A relational Model of Data for Large Shared Data Banks. Communications of the ACM (1970)
Robbert, M., Ricardo, C.M.: Trends in the evolution of the Database Curriculum. In: Innovation and Technology in Computer Science Education ITiCSE, pp. 139–143 (2003)
Elmasri, R., Navathe, B.: Fundamentals of Database Systems, 3rd edn. Addison-Wesley, Reading (2000)
Connolly, T., Begg, C.: A Practical Approach to Design, Implementation, and Management, 4th edn. Addison-Wesley, Reading (2005)
Date, C.J.: An Introduction to Database Systems, 8th edn. Addisson Wesley, Reading (2004)
Silberschatz, A., et al.: Database System Concepts, 5th edn. McGraw-Hill, New York (2005)
Dietrich, S.W., Eckert, E., Piscator, K.: WinRDBI- a Windows-based Relational Database Educational Tool. In: Proceedings of the 28th ACM SIGCSE Technical Symposium on Computer Science Education, pp. 126–130. ACM Press, New York (1997)
Davis, M., Fitzpatrick, M.: Virtura - A virtual tutor for relational algebra. LTSN: Teaching, Learning and Assessment of Databases, pp. 25–29 (2003)
Appel, A., Da Quintino, S. E., Traina, C., Machado, A.: iDFQL - A query-based tool to help the teaching process of the relational algebra. In: World Congress on Engineering and Technology Education. WCETE (2004)
Beynon, M., Bhalerao, A., Roe, C., Ward, A.: A Computer-based environment for the study of relational query languages. LTSN Teaching, Learning and Assessment of Databases, pp. 104–108 (2003)
McMaster, K., Anderson, N., Blake, A.: Teaching Relational Algebra and Relational Calculus: A Programming Approach. In: Proceedings ISECON (2006)
Soler, J., Poch, J., Barrabes, E., Juher, D., Ripoll, J.: A tool for the continuous assessment and improvement of the student’s skills in a mathematics course. In: Technology of Information and Communication in Education for engineering and industry. TICE, pp. 105–110 (2002)
Boada, I., Prados, F., Soler, J., Poch, J.: A teaching/learning support tool for introductory programming courses. In: International Conference on Information Technology Based higher Education and Training, ITHET, pp. 604–609 (2004)
Prados, F., Boada, I., Soler, J., Poch, J.: Automatic Generation and Correction of Technical Exercices. In: International Conference on Engineering and Computer Education: ICECE (2005)
Prados, F., Boada, I., Soler, J., Poch, J.: An Automatic Correction Tool for relational Database Schemas. In: International Conference on Information Technology based higher Education and Training, ITHET, vol. S3C, pp. 9–14 (2005)
Prados, F., Boada, I., Soler, J., Poch, J.: A Web Based-Tool for Entity-Relationship Modeling. In: Gavrilova, M., Gervasi, O., Kumar, V., Tan, C.J.K., Taniar, D., Laganà, A., Mun, Y., Choo, H. (eds.) ICCSA 2006. LNCS, vol. 3980, pp. 364–372. Springer, Heidelberg (2006)
Soler, J., Prados, F., Boada, I., Poch, J.: A Web-based tool for teaching and learning SQL. In: International Conference on Information Technology Based Higher Education and Training, ITHET (2006)
Soler, J., Boada, I., Prados, F., Poch, J.: A web-based problem-solving environment for Database Normalization. In: Simposio Internacional de Informatica Educativa. SIIE (2006)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Soler, J., Boada, I., Prados, F., Poch, J., Fabregat, R. (2007). An Automatic Correction Tool for Relational Algebra Queries. In: Gervasi, O., Gavrilova, M.L. (eds) Computational Science and Its Applications – ICCSA 2007. ICCSA 2007. Lecture Notes in Computer Science, vol 4706. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-74477-1_77
Download citation
DOI: https://doi.org/10.1007/978-3-540-74477-1_77
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-74475-7
Online ISBN: 978-3-540-74477-1
eBook Packages: Computer ScienceComputer Science (R0)