Question

Difference between star snowflake and fact constellation schema

Answer 1

Star Schema

A single large central fact table and one table for each dimensionEvery fact points to one tuple in each of the dimensions and has additional attributesDoes not capture hierarchies directly.

Snowflake Schema

Variant of star schema model.A single, large and central fact table and one or more tables for each dimension.Dimension tables are normalized split dimension table data into additional tables.

Hope this helps!