ORDERS A table containing information about orders

ordno number(6) unique identifier

month char(3) three character abreviation for month order was placed

cid customer placing order

aid agent handling customers order

pid product ordered

qty number(6) quantity of product (pid) on this order

dollars number(6,2) cost in dollars of this order

PRODUCTS A table containing information about products for sale

pid char(3) unique identifier

pname up to 13 characters descriptive name of product

city up to 20 characters city where this product is warehoused

quantity number(10) quantity on hand for sale

price number(3,2) wholesale price of each product

AGENTS A table containing information about agent employees

aid char(3) unique identifier

aname up to 13 characters last name of agent

city up to 20 characters city where agent is based

percent number(3) percentage commission agent receives on a sale

CUSTOMERS A table containing information about customers

cid char(4) unique identifier

cname up to 13 characters name of a customer

city up to 20 characters city where customers headquarters is located

disnct number(4,2) customers discount