The table below shows all information stored for an order entry system. It keeps track of customer information, order date and item/quantity, as well as MSRP (Manufacturer's Suggested Retail Price) and manufacturer for each item. CustomerNo is the unique identifier for customer.

Business Rules: A customer can place multiple orders, but each order contains at most one item (multiple quantities are allowed), and the customer cannot order the same item again during the same day..

CustomerNo	CustomerName	CustomerCity	CustomerPhone	OrderDate	Item	Quantity	Manufacturer	ManufacturerPhone	MSRP
S1011 S1011 S1024 S1024 S1032 S1032	James Bond James Bond Andrew Joe Andrew Joe Kevin King Kevin King	DC DC LA LA New York New York	1238888, 1239999 1238888, 1239999 7778888, 7779999 7778888, 7779999 9998888 9998888	1/9/05 1/9/05 1/9/05 2/7/05 3/1/05 3/1/05	ipad iphone kindle kindle iphone Pixel 2	1 2 3 5 1 8	Apple Apple Amazon Amazon Apple Google	8888999 8888999 7773333 7773333 8888999 3338899	888 999 333 333 999 777

Evaluate if the table shown above is normalized, if not, describe and illustrate the process of normalizing the table shown above to third normal form. State any assumptions you make about the data shown in this table. (20 Points)

Is the table in 1NF, 2NF, or 3NF?

If not, describe and illustrate the process of normalizing it to 3NF. Identify functional dependencies before each conversion.

Show the final tables with data after normalization.