• Using LEGO® Brick Data to...

Treffer: Using LEGO® Brick Data to Teach SQL and Relational Database Concepts

Title:
Using LEGO® Brick Data to Teach SQL and Relational Database Concepts
Language:
English
Authors:
James R. Wolf
Source:
Information Systems Education Journal. 2025 23(2):29-44.
Availability:
Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
Peer Reviewed:
Y
Page Count:
16
Publication Date:
2025
Document Type:
Fachzeitschrift Journal Articles<br />Reports - Research
Education Level:
Higher Education
Postsecondary Education
Descriptors:
Higher Education, Databases, Data Analysis, Web Sites, Data Science, Tables (Data), Programming
ISSN:
1545-679X
Entry Date:
2025
Accession Number:
EJ1468081
Database:
ERIC

Weitere Informationen

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.

As Provided