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.
Related Book For
Business Statistics A First Course
ISBN: 978-0321979018
7th edition
Authors: David M. Levine, Kathryn A. Szabat, David F. Stephan
Posted Date: