Put the following data into 3NF (Third Normal Form). Data has 24 columns and 22 rows (it is one data set cut into 4 images).

City Row ID Order ID 32298 CA-2012-124891 26341 IN-2013-77878 25330 IN-2013-71249 13524 ES-2013-1579342 47221 SG-2013-4320 22732 IN-2013-42360 30570 IN-2011-81826 31192 IN-2012-86369 40155 CA-2014-135909 40936 CA-2012-116638 34577 CA-2011-102988 28879 ID-2012-28402 45794 SA-2011-1830 4132 MX-2012-130015 27704 IN-2013-73951 13779 ES-2014-5099955 36178 CA-2014-143567 12069 ES-2014-1651774 22096 IN-2014-11763 49463 TZ-2014-8190 46630 PL-2012-7820 Order Date Ship Date Ship Mode 31-07-2012 31-07-2012 Same Day 5/2/2013 7/2/2013 Second Class 17-10-2013 18-10-2013 First Class 28-01-2013 30-01-2013 First Class 5/11/2013 6/11/2013 Same Day 28-06-2013 1/7/2013 Second Class 7/11/2011 9/11/2011 First Class 14-04-2012 18-04-2012 Standard Class 14-10-2014 21-10-2014 Standard Class 28-01-2012 31-01-2012 Second Class 5/4/2011 9/4/2011 Second Class 19-04-2012 22-04-2012 First Class 27-12-2011 29-12-2011 Second Class 13-11-2012 13-11-2012 Same Day 6/6/2013 8/6/2013 Second Class 31-07-2014 3/8/2014 Second Class 3/11/2014 6/11/2014 Second Class 8/9/2014 14-09-2014 Standard Class 31-01-2014 1/2/2014 First Class 5/12/2014 7/12/2014 Second Class 8/8/2012 10/8/2012 First Class Customer ID RH-19495 JR-16210 CR-12730 KM-16375 RH-9495 JM-15655 TS-21340 MB-18085 JW-15220 JH-15985 GM-14695 AJ-10780 MM-7260 VF-21715 PF-19120 BP-11185 TB-21175 PJ-18835 JS-15685 RH-9555 AB-600 Customer Name Rick Hansen Justin Ritter Craig Reiter Katherine Murray Rick Hansen Jim Mitchum Toby Swindell Mick Brown Jane Waco Joseph Holt Greg Maxwell Anthony Jacobs Magdelene Morse Vicky Freymann Peter Fuller Ben Peterman Thomas Boland Patrick Jones Jim Sink Ritsa Hightower Ann Blume Segment Consumer New York City Corporate Wollongong Consumer Brisbane Home Office Berlin Consumer Dakar Corporate Sydney Consumer Porirua Consumer Hamilton Corporate Sacramento Consumer Concord Corporate Alexandria Corporate Kabul Consumer Jizan Home Office Toledo Consumer Mudanjiang Corporate Corporate Henderson Corporate Prato Corporate Townsville Consumer Uvinza Corporate Bytom State New York New South Wales Queensland Berlin Dakar New South Wales Wellington Waikato California North Carolina Virginia Kabul Jizan Parana Heilongjiang Ile-de-France Kentucky Tuscany Queensland Kigoma Silesia Paris Postal Code Market 10024 US APAC APAC EU Africa APAC APAC APAC 95823 US Country United States Australia Australia Germany Senegal Australia New Zealand New Zealand United States United States United States Afghanistan Saudi Arabia Brazil China France United States Italy Australia Tanzania Poland 28027 US 22304 US APAC EMEA LATAM APAC Region East Oceania Oceania Central Africa Oceania Oceania Oceania West South South Central Asia EMEA South North Asia Central South South Oceania Africa EMEA Product ID TEC-AC-10003033 FUR-CH-10003950 TEC-PH-10004664 TEC-PH-10004583 TEC-SHA-10000501 TEC-PH-10000030 FUR-CH-10004050 FUR-TA-10002958 OFF-BI-10003527 FUR-TA-10000198 OFF-SU-10002881 FUR-TA-10001889 TEC-CIS-10001717 FUR-CH-10002033 OFF-AP-10003500 OFF-AP-10000423 TEC-AC-10004145 OFF-AP-10004512 TEC-CO-10000865 OFF-KIT-10004058 FUR-HON-10000224 Category Sub-Category Technology Accessories Furniture Chairs Technology Phones Technology Phones Technology Copiers Technology Phones Furniture Chairs Furniture Tables Office Supplies Binders Furniture Tables Office Supplies Supplies Furniture Tables Technology Phones Furniture Chairs Office Supplies Appliances Office Supplies Appliances Technology Accessories Office Supplies Appliances Technology Copiers Office Supplies Appliances Furniture Tables EU 42420 US EU APAC Africa EMEA Quantity Discount 7 0 9 0.1 Sales 2309.65 3709.395 5175.171 2892.51 2832.96 Profit 762.1845 -288.765 919.971 -96.54 9 0.1 5 0.1 8 0 311.52 2862.675 5 0.1 763.275 1822.08 4 0 564.84 5244.84 6 0 996.48 5083.96 5 0.2 1906.485 4297.644 13 0.4 Product Name Plantronics CS510 - Over-the-Head monaural Wireless Headset System Novimex Executive Leather Armchair, Black Nokia Smart Phone, with Caller ID Motorola Smart Phone, Cordless Sharp Wireless Fax, High-Speed Samsung Smart Phone, with Caller ID Novimex Executive Leather Armchair, Adjustable Chromcraft Conference Table, Fully Assembled Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind Chromcraft Bull-Nose Wood Oval Conference Tables & Bases Martin Yale Chadless Opener Electric Letter Opener Bevis Conference Table, Fully Assembled Cisco Smart Phone, with Caller ID Harbour Creations Executive Leather Armchair, Adjustable KitchenAid Microwave, White Breville Refrigerator, Red Logitech diNovo Edge Keyboard Hoover Stove, Red Brother Fax Machine, High-Speed KitchenAid Stove, White Hon Computer Table, with Bottom Storage 4164.05 5 0 5 0 -1862.3124 83.281 647.55 1151.4 622.02 4 0 7 0 0 12 1036.08 4 0.1 4626.15 2616.96 2221.8 3701.52 1869.588 2249.91 7958.58 2565.594 3409.74 1977.72 9 0 186.948 517.4793 3979.08 28.404 14 0 9 9 0.1 6 0 818.28 276.84 4 0 Shipping Cost Order Priority 933.57 Critical 923.63 Critical 915.49 Medium 910.16 Medium 903.04 Critical 897.35 Critical 894.77 Critical 878.38 High 867.69 Low 865.74 Critical 846.54 High 835.57 High 832.41 Critical 810.25 Critical 804.54 Critical 801.66 Critical 780.7 Critical 778.32 Low 766.93 Critical 763.38 High 759.47 Critical