RAPT: Relational Algebra Parsing Tools

Many database courses rely on relational algebra (RA) to provide a theoretical foundation for database query languages such as SQL. However, few tools exist to support students in learning RA. To fill this need, we created RAPT. RAPT uses a syntactic and semantic understanding of RA to transform input statements into a variety of outputs, including LATEX formatted queries, parse tree diagrams, and executable SQL statements. The translation to SQL is particularly important, as it enables the creation of automatically tested exercises and allows students to view the result of executing an RA statement. RAPT-supported exercises have been integrated into PCRS, a system for creating online learning modules, and deployed to a third year databases course with over 350 students.