Star schema - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.

Submitted by Francis C. (xxchen74 @ hotmail . com )

star schema is less normalization,query complexity is less,transaction speed is high.
snow flake is very good in normalization,query complexity is very high and the transaction speed is medium.

Star schema:
1)In star schema the fact table connected by one or more dimensions with primary key and foreign key relationship.
2)in star schema a dimension table will not have any parent table.
3)It contain less no.of joins.
4)It is de-normalized
Snow flake schema:
1)In star schema the fact table connected by one or more dimensions with primary key and foreign key relationship.
2)In snow flake a dimension table will have one or more parent tables.
3)It is used more joins.
4)It is normalized.

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question