Global snowflake 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. The TIME_MONTH_DIM dimension table has the primary key MONTH_ID and all attributes for the month level, and has a foreign key PARENT_ID. The TIME_QUARTER_DIM dimension table has the primary key QUARTER_ID and all attributes for the quarter level, and has a foreign key PARENT_ID. The YEAR_DIM dimension table has the primary key YEAR_DIM and all attributes for the year level. The other three dimensions are not shown in their expanded snowflake format.