Relational Algebra Teaching Support Tool
Jonathas Jivago de Almeida Cruz 1 * , Kleber Kroll de Azevedo Silva 2
More Detail
1 Federal Institute of Education, Science and Technology of Piauí, Campus Corrente, Piauí, BRAZIL
2 Federal Institute of Education, Science and Technology of Rio Grande do Norte, Campus Ipanguaçu, Rio Grande do Norte, BRAZIL
* Corresponding Author

Abstract

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.

License

This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Article Type: Research Article

https://doi.org/10.20897/jisem.201708

J INFORM SYSTEMS ENG, 2017 - Volume 2 Issue 2, Article No: 8

Publication date: 30 Mar 2017

Article Views: 2746

Article Downloads: 1878

Open Access References How to cite this article