Put the fact table in the middle, join each dimension to it by one surrogate key, and the diagram looks like a star: every dimension is one join from the facts.

Stars suit people and engines. Analysts see one table of numbers and a few tables of words. PostgreSQL 1,289 hashes each small dimension and probes it during one fact scan; DuckDB 61,228 and ClickHouse 29,491 also push a dimension filter (region = 'Europe') down into that scan. Repeating a genre group in a small dimension costs little.