Relational Algebra Teaching Support Tool

• Published in: Journal of Information Systems Engineering & Management
• Main Authors: Jonathas Jivago de Almeida Cruz, Kleber Kroll de Azevedo Silva
• Format: Article in Journal/Newspaper
• Language: English
• Published: IADITI 2017
• Subjects: relational algebra; digital learning object; Computer & Communication Sciences; Educational Science; Engineering; edu; lang; DML
• Online Access: https://doi.org/10.20897/jisem.201708; https://doaj.org/article/f62b9af3787849adadb9f786c37cd3bb

In recent years, there has been an increasing supply of digital, pedagogical tools, known as Digital Learning Objects (DLO) – digital resources (image, film, animation, etc.) and software developed specifically for educational purposes. In the area of Computer Science, teaching Databases present a particular challenge because of a lack of quality tools to work with Relational Algebra. The present study proposes a web-based tool to support teaching and learning Relational Algebra – an important subject that is particularly difficult for students to understand. The purpose of the proposed tool is to provide an alternative method for teaching Relational Algebra operations, such as: selection, projection, union, set difference, rename, intersection, Cartesian product, natural join, division and some aggregate functions. In addition, we propose a graphic definition of a database schema (using features such as drag and drop, column highlights, lines, fields, etc.), so students can use the tool easily, and in conjunction with the theory taught regarding the definition languages (DDL) and data manipulation (DML). We intend for this tool to serve as an appropriate means for teaching and learning Relational Algebra, contributing to the development of new teaching skills, as well motivating the students in the process of learning.