Question: We want to store the following data about our mattress store's revenue (sales) activity: item number item description item cost item commission % customer number

 We want to store the following data about our mattress store's

We want 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. Table Name PK FKS? Other attributes We want 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. Table Name PK FKS? Other attributes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!