Database schema:
salesRep( salesRepKeyId (as key), repNumber, repFirstName, repLastName, repAddress, repComissionTotal, repComissionRate )
customer( customerId (as key), customerNumber, customerName, customerAddress, customerBalance, customerCreditLimit, repNumber )
inventoryItem( itemId (as key), itemNumber, itemDescription, itemUnitsInStock, itemClass (as AZ), itemWarehouseLocation, itemUnitPrice )
orderCustomerRecord( orderId (as key), orderNumber, orderDate, customerNumber )
orderInventoryRecord( orderInvId (as key), orderInvNumber, orderInvTotalUnits, orderInvQuotedPrice )