Difference Between Star Schema and Snowflake Schema

Star Schema	Snowflake Schema
De-Normalized Data Structure	Normalized Data Structure
Category wise Single Dimension Table	Dimension table split into many pieces
More data dependency and redundancy	less data dependency and No redundancy
No need to use complicated join	Complicated Join
Query Results Faster	Some delay in Query Processing
No Parent Table	It May contain Parent Table
Simple DB Structure	Complicated DB Structure
View Star Schema Structure	View Snowflake Schema Structure

BI: Dimensional Model - Snowflake schema architecture

Snowflake schema architecture is a more complex variation of a star schema design. The main difference is that dimensional tables in a snowflake schema are normalized, so they have a typical relational database design.