· In Star Schema all dimensional tables are related with One Fact table.
· The dimension table contains the set of attributes. Each Dimension table has a one to many relationship with Fact table.
· Simple Star Schema contains only one Fact Table where as a complex star schema contains more than one Fact table.
· Star schemas are denormalized that reason it retrieve data faster than highly normalized schemas.
The above diagram explains Simple Star Schema. There is a fact table at the center of location and it contains the keys to four dimensions.