A Simpler (and Better) SQL Approach to Relational Division

Authors

Victor M. Matos, Cleveland State University
Rebecca Grasser, Lakeland Community College

Abstract

A common type of database query requires one to find all tuples of some table that are related to each and every one of the tuples of a second group. In general those queries can be solved using the relational algebra division operator. Relational division is very common and appears frequently in many queries. However, we have found that the phrasing of this operator in SQL seems to present an overwhelming challenge to novice and experienced database programmers. Furthermore, students seem to have the most problems with the SQL version commonly recommended in the database literature. We present an alternative solution that is not only more intuitive and easier to deliver in the classroom but also exhibits a better computational performance.

Recommended Citation

Matos, Victor M. and Grasser, Rebecca (2002) "A Simpler (and Better) SQL Approach to Relational Division," Journal of Information Systems Education: Vol. 13 : Iss. 2 , 85-88.
Available at: https://aisel.aisnet.org/jise/vol13/iss2/2