Global star schema with UNITS_HISTORY_FACT
as the central fact table with a primary key consisting of four foreign keys: MONTH_ID
, ITEM_ID
, SHIP_TO_ID
, and CHANNEL_ID
. These foreign keys are related to four dimension tables: TIME_MONTH_DIM
, PRODUCT_DIM
, CUSTOMER_DIM
, and CHANNEL_DIM
.