This illustrates a typical star schema with some columns and relationships detailed. In it, the dimension tables are:

• times
• channels
• products, which contains prod_id
• customers, which contains cust_id, cust_last_name, cust_city, and cust_state_province

The fact table is sales, which contains cust_id and prod_id.
This example is from the sh sample schema used in the Data Warehousing Guide