ISEDJ

Information Systems Education Journal

Volume 23

V23 N2 Pages 29-44

Mar 2025


Using LEGO Brick Data to Teach SQL and Relational Database Concepts


James Wolf
Illinois State University
Normal, IL USA

Abstract: This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with 633,250 rows of data on 11,673 LEGO® sets sold between 1950 and 2017. As a guiding example, I introduce an example group project assignment designed to provide students hands-on experience with database management and SQL queries. I also discuss tips, suggestions, and lessons learned from using the data for group projects over the past five years. While LEGO® bricks have been widely used in educational settings, including college and computer classrooms, this is the first work to discuss the use of LEGO® data in a college database course.

Download this article: ISEDJ - V23 N2 Page 29.pdf


Recommended Citation: Wolf, J.R., (2025). Using LEGO Brick Data to Teach SQL and Relational Database Concepts. Information Systems Education Journal 23(2) pp 29-44. https://doi.org/10.62273/FYXC7105