Question: Put the data into 3NF (Third Normal Form) 1 B D E F G 1 Row ID Order ID Order Date Ship Date Ship Mode
Put the data into 3NF (Third Normal Form)

1 B D E F G 1 Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name 2 32298 CA-2012-124891 31-07-2012 31-07-2012 Same Day RH-19495 Rick Hansen 3 26341 IN-2013-77878 5/2/2013 7/2/2013 Second Class JR-16210 Justin Ritter 4 25330 IN-2013-71249 17-10-2013 18-10-2013 First Class CR-12730 Craig Reiter 5 13524 ES-2013-1579342 28-01-2013 30-01-2013 First Class KM-16375 Katherine Murray 6 47221 SG-2013-4320 5/11/2013 6/11/2013 Same Day RH-9495 Rick Hansen 7 22732 IN-2013-42360 28-06-2013 1/7/2013 Second Class JM-15655 Jim Mitchum 8 30570 IN-2011-81826 7/11/2011 9/11/2011 First Class TS-21340 Toby Swindell 9 31192 IN-2012-86369 14-04-2012 18-04-2012 Standard Class MB-18085 Mick Brown 10 40155 CA-2014-135909 14-10-2014 21-10-2014 Standard Class JW-15220 Jane Waco 11 40936 CA-2012-116638 28-01-2012 31-01-2012 Second Class JH-15985 Joseph Holt 12 34577 CA-2011-102988 5/4/2011 9/4/2011 Second Class GM-14695 Greg Maxwell 13 28879 ID-2012-28402 19-04-2012 22-04-2012 First Class AJ-10780 Anthony Jacobs 14 45794 SA-2011-1830 27-12-2011 29-12-2011 Second Class MM-7260 Magdelene Morse 15 4132 MX-2012-130015 13-11-2012 13-11-2012 Same Day VF-21715 Vicky Freymann 16 27704 IN-2013-73951 6/6/2013 8/6/2013 Second Class PF-19120 Peter Fuller 17 13779 ES-2014-5099955 31-07-2014 3/8/2014 Second Class BP-11185 Ben Peterman 18 36178 CA-2014-143567 3/11/2014 6/11/2014 Second Class TB-21175 Thomas Boland 19 12069 ES-2014-1651774 8/9/2014 14-09-2014 Standard Class PJ-18835 Patrick Jones 20 22096 IN-2014-11763 31-01-2014 1/2/2014 First Class JS-15685 Jim Sink 21 49463 TZ-2014-8190 5/12/2014 7/12/2014 Second Class RH-9555 Ritsa Hightower 22 46630 PL-2012-7820 8/8/2012 10/8/2012 First Class AB-600 Ann Blume H Segment City 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 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 Paris
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
