This illustrates a typical snowflake schema. In it, the tables are:
Also, sales is used, and contains columns amount_sold and quantity_sold.