This graphic describes the tables in the SH schema and their dependencies.

• The costs table has the columns prod_id, time_id, unit_cost, and unit_price. Each product in the costs table may be associated with one time_id in the times table and with one product in the products table.

• The products table has the columns prod_id (primary key), prod_name, prod_desc, prod_subcategory, prod_subcat_desc, prod_category, prod_category_desc, prod_weight_class, prod_unit_of_measure, prod_pack_size, supplier_id, prod_status, prod_list_price, and prod_min_price. Each product may be related to one or more costs in the cost table and to one or more sales in the sales table.

• The promotions table has the columns promo_id (primary key), promo_category, promo_cost, promo_begin_date, and promo_end_date. Each promotion may be related to one or more sales in the sales table.

• The sales table has the columns prod_id, cust_id, time_id, channel_id, promo_id, quantity_sold, and amount_sold. Each sale may have one association with a promotion, a channel, a product, a time, and a customer.

• The channels table has the columns channel_id (primary key), channel_description, and channel_class. Each channel may be associated with one or more sales.

• The customers table has the columns customer_id (primary key), cust_first_name, cust_last_name, cust_gender, cust_year_of_birth, cust_marital_status, cust_street_address, cust_postal_code, cust_city, cust_state_province, cust_main_phone_number, cust_income_level, cust_credit_limit, and cust_email. Each customer may be associated with one or more sales and with one country.

• The times table has the columns time_id (primary key), day_name, day_number_in_week, day_number_in_month, calendar_week_number, fiscal_week_number, week_ending_day, calendar_month_number, fiscal_month_number, calendar_month_desc, fiscal_month_desc, days_in_cal_month, days_in_fis_month, end_of_cal_month, end_of_fis_month, calendar_month_name, fiscal_month_name, calendar_quarter_desc, fiscal_quarter_desc, days_in_cal_quarter, days_in_fis_quarter, end_of_cal_quarter, end_of_fis_quarter, calendar_quarter_number, fiscal_quarter_number, calendar_year, fiscal_year, days_in_cal_year, days_in_fis_year, end_of_cal_year, end_of_fis_year. Each time may be associated with one or more cost and one or more sale.

• The countries table has the columns country_id (primary key), country_name, country_subregion, and country_region. Each country may be associated with one or more customers.