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

• 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.