This illustrates a typical star schema. In it, the dimension tables are:



The fact table is sales. sales shows columns amount_sold and quantity_sold.