Table Data:
Un-normalized data:
Customer:Customer ID (PK), Last Name, First Name, Street Address, City, State, Zip Code, Current Balance, Credit Limit, Sales Rep ID
Sales Representative:Sales Rep ID (PK), Last Name, First Name, Street Address, City, State, Zip Code, Region, Region Description, Total Commission, Commission Rate
Order:Order ID (PK), Order Date, Customer, Shipping Date
Order Lines: Part ID (PK), Number Ordered, Quoted Price
Parts: Part ID (PK), Part Description, Units on Hand, Class, Warehouse Number, Unit Price
Normalization
an
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
