Snowflake Schema Design

Problem

Your lead architect wants to normalize the dimension tables in your star schema to save storage space, converting it into a snowflake schema. Write a query that outputs trade_off with the value: "Snowflaking normalizes dimension tables, saving storage space and improving integrity, but increases query complexity due to additional JOINs."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution