Managing and analyzing the LEGO Database with SQL

Photo by Xavi Cabrera on Unsplash

Lego is one of the most popular commercial product in the world. In this assignment, you will be working with a database containing information about LEGO - the sets, parts, themes, and inventories - about sets that were released in the past.

Due Date

• Assignment 1 is due on 11:59 PM, Monday, October 20.

Dataset Overview

The database ”Lego Database” from Kaggle consists of 8 tables with the following relationships:

• themes (614 rows): LEGO themes and sub-themes
• sets (11,673 rows): LEGO set information
• parts (25,993 rows): Individual LEGO parts
• part_categories (57 rows): Categories for parts
• colors (135 rows): Available LEGO colors
• inventories (11,681 rows): Inventory versions for sets
• inventory_sets (2,846 rows): Sets included in other sets
• inventory_parts (580,251 rows): Parts included in each inventory