Data Modeling Question:

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

Answer:

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.

Download Data Modeling PDF Read All 36 Data Modeling Questions
Previous QuestionNext Question
Give us a non-computer example of preemptive and non-preemptive scheduling?What is data sparsity and how it effect on aggregation?