The discount table contains the discount type, store ID, quantity, and percentage discount.
discounts is defined as:
create table discounts (discounttype varchar(40) not null, stor_id char(4) null references stores(stor_id), lowqty smallint null, highqty smallint null, discount float not null)