Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Can you help me normalize the following data?
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