What is the difference between star flake and snow flake schema?
Submitted by: AdministratorStar 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Data Modeling Job Interview Questions And Answers
Top Data Modeling Questions
| ☺ | What is ERD? |
| ☺ | Why are recursive relationships are bad? How do you resolve them? |
| ☺ | What is second normal form? |
| ☺ | What is third normal form? |
| ☺ | What is an artificial (derived) primary key? When should it be used? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
