Data Modeling Interview Questions and Answers

 

What is the difference between star flake and snow flake schema?

Star Schema:




Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.






SnowFlake:




Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

Posted by:Richards