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
)