Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

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

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question