A snowflake schema is a far more complicated Variation of a star schema. With this design and style, only one simple fact table connects to one or more dimension tables, which may connect with added dimension http://www.etsy.com/listing/1768449150