Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

e Search More Complex Normalization practice . Protected View - Saved - m Layout References Mailings Review View Help Internet can contain viruses. Unless you

image text in transcribed
e Search More Complex Normalization practice . Protected View - Saved - m Layout References Mailings Review View Help Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 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 FK(s)? Other attributes PK Table Name W e Search More Complex Normalization practice . Protected View - Saved - m Layout References Mailings Review View Help Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 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 FK(s)? Other attributes PK Table Name W

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Scientist Audits The Earth

Authors: Stuart L Pimm

1st Edition

0813535409, 978-0813535401

More Books

Students also viewed these Accounting questions

Question

e. What difficulties did they encounter?

Answered: 1 week ago