Can you help me with the normalization and model for part A and B?

Sample Sales Data for The Queen Anne Curiosity Shop Price Tax Total Phone 206-524-2433 LastName FirstName Shire Robert Shire Robert Goodyear Katherine 206-524-2433 InvoiceDate Invoiceltem 14-Dec-17 Antique Desk 14-Dec-17 Antique Desk Chair 15-Dec-17 Dining Table Linens 15-Dec-17 Candles 23-Dec-17 Candles 3,000.00 249.00 3,249.00 500.00 41.50 541.50 1,000.00 83.00 1,083.00 206-524-3544 Bancroft 425-635-9788 4.15 54.15 Chris John 50.00 45.00 Griffith 206-524-4655 3.74 48.74 Shire Robert 206-524-2433 5-Jan-18 Desk Lamp 250.00 20.75 270.75 425-635-8677 750.00 62.25 812.25 360-538-7566 270.75 Tierney Doris Anderson Donna Goodyear Katherine Goodyear Katherine 10-Jan-18 Dining Table Linens 12-Jan-18 Book Shelf 15-Jan-18 Antique Chair 15-Jan-18 Antique Chair 25-Jan-18 Antique Candle Holders 250.00 20.75 1,250.00 103.75 206-524-3544 1,353.75 206-524-3544 1,750.00 145.25 1,895.25 Tierney Doris 425-635-8677 350.00 29.05 379.05 Purchaseltem Purchase Price Phone Antique Desk 1,800.00 206-325-7866 Antique Desk 1,750.00 206-325-7866 206-325-7866 210.00 200.00 206-325-7866 Antique Candle Holders Antique Candle Holders Dining Table Linens Candles 600.00 206-325-6755 30.00 206-325-6755 150.00 206-325-8977 Purchase Date Vendor 7-Nov-17 European Specialties 7-Nov-17 European Specialties 7-Nov-17 European Specialties 7-Nov-17 European Specialties 14-Nov-17 Linens and Things 14-Nov-17 Linens and Things 14-Nov-17 Lamps and Lighting 14-Nov-17 Lamps and Lighting 21-Nov-17 Linens and Things 21-Nov-17 Linens and Things 21-Nov-17 Harrison, Denise 28-Nov-17 Lee, Andrew 28-Nov-17 Lee, Andrew 28-Nov-17 New York Brokerage 28-Nov-17 New York Brokerage 300.00 Desk Lamp Floor Lamp Dining Table Linens Candles Book Shelf 206-325-8977 450.00 206-325-6755 27.00 206-325-6755 150.00 425-746-4322 Antique Desk 1,000.00 425-746-5433 300.00 425-746-5433 Antique Desk Chair Antique Chair 750.00 206-325-9088 Antique Chair 1,050.00 206-325-9088 Question 23. Part A & B A. Normalize these tables to arrive at a fully normalized table structure and write the normalized tables in the same format. *Note that the data includes information about customers, orders, items in the orders, purchased items that are sold, and vendors who sell those items*. B. Draw an E-R model diagram as a conceptual design for the normalized data. For entities with sub-optimal identifiers, create a surrogate id field (for e.g., CustomerID). Make sure you have the correct entities, identifiers, fields, and the relationships between the entities, including minimum and maximum cardinalities, and whether any entities are id dependent or not. You may use pen and paper, or any drawing tool to render the E-R model, including Visio and ERWin