Data Dive

A third party designed a database of products. You’ll notice the database isn’t normalized particularly well, so you’ll have to convert the database schema to third normal form for products, prices per size, categories, and any lookup tables you might add.

ID Name Categories Size Price
123 Desk Lamp Home Décor NULL 10
234 Logo Tee Clothing S 10
234 Logo Tee Clothing M 10
345 Hand Soap Personal Care 20oz 5
456 Hand Soap Personal Care 40oz 8
567 Database Design Books -> Computers NULL 25

Once you’ve done that, how many rows are there in the products table?

Skip to main navigation