<P> In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts . The star schema consists of one or more fact tables referencing any number of dimension tables . The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries . </P> <P> The star schema gets its name from the physical model's resemblance to a star shape with a fact table at its center and the dimension tables surrounding it representing the star's points . </P>

Relation between fact table and dimension table in star schema