A star schema is a type of relational database
schema that is composed of a single, central fact table that is surrounded
by dimension tables.
The following figure shows a star schema with a single fact table
and four dimension tables. A star schema can have any number of dimension
tables. The branches at the end of the links connecting the tables
indicate a many-to-one relationship between the fact table and each
dimension table.
Figure 1. Star schema with a single fact table with
links to multiple dimension tables