Relational Algebra and SQL: Better Together
Kirby McMaster, Samuel Sambasivam, Steven M. Hadfield, Stuart L Wolthuis · 2013
In this paper, we describe how database instructors can teach Relational Algebra and Structured Query Language together through programming. Students write query programs consisting of sequences of Relational Algebra operations vs. Structured Query Language SELECT statements. The query programs can then be run interactively, allowing students to compare the results of Relational Algebra and equivalent Structured Query Language commands. In this way, students better understand both Relational Algebra and Structured Query Language—by writing code and watching it run.