Relational algebra programming with Microsoft access databases

Abstract

In this paper, we describe a custom Relational Algebra Query software environment that enables database instructors to teach relational algebra programming. Instead of defining query operations using mathematical notation (the approach commonly taken in database textbooks), students write query programs as sequences of relational algebra function calls. The data to be queried can be in any Microsoft Access MDB file. The query processor software executes relational algebra Instructions interactively, allowing students to view intermediate result tables. Thus, students can learn relational algebra the same way they learn SQL-through programming.