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 - Star Schema

The star schema is the simplest style of data warehouse schema. The star schema consists of a few fact tables (possibly only one) referencing any number of dimension tables.

Star Schema Format 1:

Star Schema Format 2:

Star Schema Format 3:

Star Schema Format 4: