Star Schema

Snowflake Schema

The fact tables and dimension tables are both contained in the star schema.

The fact tables, dimension tables, and sub dimension tables are all contained in the snowflake schema.

The star schema is a top-down model.

While it is a bottom-up model.

The star schema takes up more space.

While it takes up less space.

Queries are executed in less time.

Here query execution takes longer than with the star schema.

Normalization is not employed in the star schema.

Both normalisation and denormalization are employed in this.

It has a very simple design.

While its design is complex.

Star schema has a low query complexity.

Snowflake schema has a higher query complexity than star schema.

It contains fewer foreign keys.

It has a larger number of foreign keys.

It has a high level of data redundancy.

While it has a minimal level of data redundancy.