Star schema: A fact table in the middle connected to a set of dimension tables
Snowflake schema: A refinement of star schema where some dimensional hierarchy is normalized into a set of smaller dimension tables, forming a shape similar to snowflake
Galaxy Schema (Fact constellations): Multiple fact tables share dimension tables, viewed as a collection of stars, therefore called galaxy schema or fact constellation