The schema design resembles a star, with dimensions radiating from a fact table

It is mainly used for online transaction processing (OLTP)

It has a central fact table connected to multiple dimension tables

It is commonly used in data warehousing for analytical queries

It only uses normalized tables to reduce redundancy