Relational Algebra Teaching Support Tool
Journal Title: Journal of Information Systems Engineering & Management - Year 2017, Vol 2, Issue 2
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.
Authors and Affiliations
Jonathas Jivago de Almeida Cruz, Kleber Kroll de Azevedo Silva
Keywords
Related Articles
- EP ID EP349885
- DOI 10.20897/jisem.201708
- Views 100
- Downloads 0
Scrum as a Platform to Manage Students in Projects of Technological Development and Scientific Initiation: A Study Case Realized at UNIT/SE
This paper deals with the Scrum methodology as an alternative to pedagogical practices and managing of the software projects, presenting an investigation with the students of scientific initiation of an university from t...
A Case Study on the Strategy of Maintaining Commercial Software with a Large Number of Users
Software maintenance is the activity in which changes occur in the artifacts of a software after delivery, with the purpose of keeping it available, correcting its failures, improving its performance and adapting it to n...
Products Recommendation for Mobile Devices
The mobile application market and e-commerce sales have grown steadily, along with the growth of studies and product recommendation solutions implemented in e-commerce systems. In this context, this paper proposes a reco...
Short Term Load Forecasting in Smart Grids: Case Study of the City of Évora
Currently, load forecasting is a fundamental task for planning, operation and exploration of the electric power systems. The importance of forecasting has become more evident with the restructuring of the national energy...
E-banking services: Why fraud is important?
The purpose of this paper is to answer the importance of fraud that arise from the use of e-banking services more ethical behavior applied to everyday moral problems. On the one hand, the theoretical framework of this pa...