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 109
- Downloads 0
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...
E-waste Management in Portugal: Legislation, Practices and Recommendations
The use of electrical and electronic devices has grown exponentially in the last years thanks to technological advances and its wide dissemination. Consequently, the number of obsolete equipment (electronic waste or e-wa...
Receivables Management and Possible Use of Information Technologies
This paper is focused on receivables management and possibilities how to use available information technologies. The use of information technologies should make receivables management easier on one hand and on the other...
Using the Characteristics of Documents, Users and Tasks to Predict the Situational Relevance of Health Web Documents
Relevance is usually estimated by search engines using document content, disregarding the user behind the search and the characteristics of the task. In this work, we look at relevance as framed in a situational context,...
A knowledge federation architecture for rare disease patient registries and biobanks
Patient registries are a source of standardized electronic patient information. These records are vital to identify and coordinate a proper cohort, especially for the rare disease domain. Likeness, biobanks are currently...