RE: What is the difference between star flake and snow...
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.
RE: What is the difference between star flake and snow...
Star schema In the star schema design a single object (the fact table) sits in the middle and is radically connected to other surrounding objects (dimension lookup tables) like a star. A star schema can be simple or complex. A simple star consists of one fact table; a complex star can have more than one fact table.Snowflake schema In this a Dimension can have multiple Levels within multiple Hierarchies. From each hierarchy of levels any one Level can be attached to Fact Table. Mostly Lowest Level is attached to Fact Table.
RE: What is the difference between star flake and snow...
If someone asks about a star flake schema you will know they are not a data modeler since there is no such thing. There are star schemas sno flake schemas and there are even data vaults but there is no star flake schema.
1 
0