Star Schema

A Star Schema is basically a single Fact Table connected to dimension tables and often resemble a star. Now you might be wondering "what is a fact table?"

Well a Fact table is the centralized table in a Star Schema. It only contains numeric values like ID, Salary, cost, etc. It also contains Foreign Keys to the Dimension tables.

A Dimension Table stores atrributes that describe the objects in the Fact Table.