Snowflake Schema

A refinement of the Star Schema where some of the dimension tables are normalized into smaller tables.

Example