To store the following data about our mattress stores revenue (sales) activity item number item description item cost item commission customer number customer name customer address sales order number date of sale quantity sold price per unit extended amount salesperson number salesperson name total...

Table 1 Inventory Item Number Item Description Item Cost Item Co ...

To store the following data about our mattress stores revenue (sales) activity: item number item description item

Fantastic news! We've Found the answer you've been seeking!

Question:

To store the following data about our mattress store’s revenue (sales) activity:

item number
item description
item cost
item commission %
customer number
customer name
customer address
sales order number
date of sale
quantity sold
price per unit
extended amount
salesperson number
salesperson name
total amount of sale
commission $$ on sale

Each inventory item pays a different commission %, and the items are generic, not specific or unique. Some customers buy several mattresses at a time, and some come back to buy more. Also, price is “negotiable” between the salesperson and the customer. Normalize these data items.