Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 1 of 1
Full-Text Articles in Business
Mapping Relational Algebra Operators Into Sql Queries: A Database Case Study, John N. Dyer, Camille F. Rogers
Mapping Relational Algebra Operators Into Sql Queries: A Database Case Study, John N. Dyer, Camille F. Rogers
Department of Enterprise Systems and Analytics Faculty Publications
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 …