LEGO is a popular brand of toy building bricks. They are often sold in sets with in order to build a specific object. Each set contains a number of parts in different shapes, sizes and colors. This database contains information on which parts are included in different LEGO sets.

Inventory Management

RStudio

• colors.csv - This file contains information on LEGO colors, including a unique ID for each color, its name, and approximate RGB value, and whether it's transparent

• sets.csv - This file contains information on LEGO sets, including a unique ID number, the name of the set, the year it was released, its theme and how many parts it includes

• part_categories.csv - This dataset includes information on the part category (what type of part it is) and a unique ID for that part category

• parts.csv – This dataset includes information on Lego parts, including a unique ID number, the name of the part, and what part category it's from

• inventory_parts.csv – This table contains information part inventories, including a unique ID number, the part number, the color of the part, how many are included and whether it's a spare

• themes.csv – This file includes information on lego themes. Each theme is given a unique ID number, a name, and (if it's part of a bigger theme) which theme it's part of