Star schema is a well-known modeling technique used by relational data warehouses. It necessitates that modellers categorise their model tables as dimension or fact.
Business entities—the items you model—are described in dimension tables. Products, people, places, and concepts, even time itself, are examples of entities. A date dimension table is the most consistent table in a star schema. A dimension table is made up of descriptive columns and a key column (or columns) that acts as a unique identifier.