Designing a Star Schema

Problem

You are building a data warehouse database. You want to split the structure into business metrics (facts) and context details (dimensions). Write a query that outputs design with the value: "A star schema consists of a central fact table containing foreign keys and quantitative measurements, surrounded by dimension tables containing descriptive attributes."

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