97 Integrating SAP to Information Systems Curriculum: Design and Delivery (original) (raw)
Related papers
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.
RELAX — the relational algebra pocket calculator project
ACM SIGCSE Bulletin, 2000
Database courses benefit from the abundance of commercial SQL systems available today. Unfortunately, the same cannot be said about the relational algebra query language. This article considers a lab experience to integrate the learning of these two important topics. In the process of implementing the project, the student acquires practical knowledge in areas such as database programming, parsing and compiling, dynamic SQL code generation, object linking and embedding technologies (OLE), and problem solving skills using the framework of relational algebra. This activity is applied to a traditional second semester database theory course and appears to be very beneficial to the student.
A System to Support Teaching and Learning Relational Database Query Languages and Query Processing
The importance of relational algebra in a database course is widely recognized to facilitate teaching and learning of SQL. From our experience we have also found it very useful for the students to understand the basics of query processing in terms of execution plans. However currently there are no specific tools to make the process of learning relational algebra and execution plans an interesting and stimulating activity. The features of the JRS (Java Relational System) graphical editors of query plans are presented. The graphical editors are used to define and execute queries on a database represented by two kinds of trees: A logical plan of relational algebra, and a physical plan that describes an algorithm to execute a query using the physical operators of the relational DBMS developed in Java as a teaching tool.
Relational Algebra Interpreter
Proceedings of the 2014 International Conference on Advanced ICT (ICAICTE 2014), 2014
Relational Algebra is a procedural language that defines database in terms of algebraic expressions. It is used to explain query execution and optimization in a relational DBMS. However, the tools available to teach the concepts of Relational Algebra are limited. Most of the tools that teach database concepts are concentrated around SQL. In this paper, we introduce an application that implements five different relational operators (select, project, union, intersect and difference) by using Irony technology. This .NET web is a tool that transforms a Relational Algebraic expression into SQL queries. The resultant SQL then is used to query a database.
Relational Algebra Interpreter in Context of Query Languages
International Journal of Computer Theory and Engineering, 2011
Relational database systems have succeeded commercially because of their openness and sturdy theoretical groundwork. The contribution of this title "Relational Algebra Interpreter in context of query languages" is presentation of new implementation in such a way so that queries written in relational algebra can be compiled into SQL and executed on a relational database system. It takes a relational algebra statement as key, does syntactic and lexical parsing on it. In the event of an error in the syntax of the expression it will forward the error to user. If the syntax is correct the relational algebra expression is converted into a SQL statement and executed on an RDBMS. This work can serve up as a basis learning Relational Algebra for different class of users, as they will be given immediate feedbacks about their queries.
Mapping Relational Algebra Operators into SQL Queries: A Database Case Study
2015
Relational algebra operators and mapping to resulting structured query language (SQL) queries are among the most important concepts and skills for students taking a course in database design and implementation, especially those majoring in IS/IT. The most typical relational algebra operators mapped to foundational SQL include unions and intersections, as well as other relational operators applied to these operators, including differences and various joins. Unfortunately, few textbooks or external resources provide ample opportunity for students to apply the full set of most common relational algebra operators mapped to resulting SQL over a single unified case. Most database textbooks exemplify each separate relational algebra construct to a single, sparse (although visually-stimulating) example, wherein the full set of operators is not near fully exemplified. This paper presents an overview of a case example that exemplifies and maps a more complete set of relational algebra operato...
Relational Algebra and SQL Query Visualisation
2010
Abstract Relational algebra and the industry standard SQL are core topic covered in undergraduate database courses. Database management systems translate SQL statements into a procedural query plan composed with operations similar to those that arise in relational algebra. Learning relational algebra makes students familiar with this process. Moreover they understand the difference between procedural and declarative query languages.
A Computer-Based Environment for the Study of Relational Query Languages
2003
In this paper, we describe an environment developed to support a rich learning experience in which practice and theory in relational databases are better integrated, enabling students from various backgrounds to appreciate the significance of relational theory and the logical flaws in SQL. Our lightweight open source software includes the aspects of a commercial database system that are most relevant to teaching relational databases and can be run on several platforms.
Use of software tools in teaching relational database design
Computers & Education, 1995
This paper discusses our experiences in using state-of-the-art software tools in teaching an advanced relational database design course (a previous graduate course in database is the prerequisite for this course), which is taken as an elective by graduate students in the Department of Computer and Information Science at Cleveland State University. As an experiment, the class material was slightly modified to include student exposure to a prototype of current software that uses expert systems information technology (IT) to automate relational database design for microcomputer users at the management level. Surprisingly, the results in terms of student interest, involvement, and inquisitiveness were far better than expected considering the minor changes to the course that were involved. Typically in the past, students in Computer and Information Science departments have approached the study of relational database design solely from the point of view of learning normalization theory. This approach was used to train graduate students to become database administrators. However, more and more the needs of today are for students to be able to understand and certainly be able to use and deal with the latest expert system software in the database area including database design. We feel that database design courses should reflect these needs.