[Solved]Use Attached File Normalize Data Create New Tab Normal Form Start Unnormalized Data Normal Q37023107
Use the attached file tonormalize the data. Create a new tab for each normal form. Startwith Unnormalized data. Normalize the data to 1st Normal Form andput the data in its own tab. Be sure and label the Primary keys.Now move the data to 2nd Normal Form with the appropriate primarykeys and tables identified. Move the data to 3rd Normal form andshow appropriate primary keys.
NormalizationCompany-Revised Compatibility Mode Excel AutoSave ( Insert Page Layout Formulas Data Review View Help Team ell me what you want to do File Σ AutoSum . A Cut Wrap Text 11A A Calibri General Fill Clear , Copy ?m eo .no Conditional Format as Cel Insert Delete Format Sorti&Find & Filter Select B 1 u . -. 2-A. Merge & Cente . $ . % , . y’r Pan. o Formatting- TableStyles Cells Clipboard Alignment Styles Editing G19 1 Order Nur OrderDat ustomer Nu CompanyName ContactName Contcle Addss City 2 125658 23-Nov-13 236589 Jones Ultimate Sy John Hery Salesan 1259 East Licolrn NE 3 125658 11/23/2013 236589 Jones Ultimate Sy John Henry Salesman 1259 East Fremont NE 4 1756 78-Now-13 5 125659 24-Nov-13 236596 Jones Ultimate Sy Lee Johnson Salesnan 4568 VaniGalvaston TX 6 125660 25-Nov-13 236588 Utility Supplies Susan Gordon Operations M 2319 Wes Yuma AZ 7 | 12566, 29-Nov-13 236 79Я Western Systems Megan Hirschi Receptionist 1345 Sava Salt Flat wy 8 125663 30-Nov-13 236850 Bear County Inn Rhonda Ingran Order Adnini 846 East 7 Salt Lake CUT 9 125663 11/30/2013 236850 Bear County Inn Rhonda Ingram Order Admini 846 East 7 Salt Lake CUT Region Postalcde Country Phone Fax 65987 USA 65987 USA 65987 USA ProductiD ProductName SupplierCon SupplierContacN Sup 2.59E092.59E+09 1254788 Miracle Sleep Pillow Sleep Impro Jessie Jonas Sh 2.59티09 2.59티092102986 King Size Comforter Comfort Sol Nathan Green Ma Sleep impro less e lonas Sleep impro Jessie Jonas Ship Ship 736589 lones ltimate Sy lohn Henry Salesman 1759 Fastincoln N 게게門 1010233 Megastar won eTam 7.766E+09 none 7.779티097.779티091254788 Miracle Sleep Pillow 54986 USA 1010233 MegaStar Weed Tamer WeedTirne FShellie Jackson Cler 1900917 Infant Sheet Protector Comfort Sol Nathan Green 2102986 Kin Size Comforter Comfort Sol Nathan Greer Mar 1010233 MegaStar Weed Tamer WeedTime I ShellksonCler 94321 USA 81739 USA 84122 USA 84122 USA B.349F+09 none 8.0 19E+09 none 8.019 09 none 10 12 14 16 18 20 24 Unnormailized 1NF 2NF 3NF 85% 805 AM 4/17/2019 Type here to search AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File Cut Copy Format Painter AutoSum A Fill Wrap Text Calibri General 입dear. e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select B 1 u·Z: 2. I U Merge & Cento . $ . % , Formatting TableStyles Alignment G19 从 AC AE 1 SupplierContaciSupplierAddre SupplierCity 2 Shipping Clerk 12879 North IHoneyville 3 Manager 4 Shipping Clerk 12879 North IHoneyville 5 Clerk 6 Shipping Clerk 12879 North Honeyville T Manager 8 Marnager 9 Clerk SupplierRegio SupplierPostalC.oc SupplierCountry SupplierFax SupplierHom UnitPrice Quantity Productr ProductUnitsInSto FmployeelD Fmpl 32.99 99.95 98635 USA 12569 USA 98635 ISA 79632 USA 98635 USA 17569 USA 12569 USA 79632 USA 9655222525 9.655E+09 www.s 2236533000 2.237E109 www.kingsiz 965577255 9.655F09 ww.sleend 64.99 7459620236 7.46E+09 www.weedti 9655222525 9.65SE109 www.sleepd 32.99 7736533OO .237F09 ww.kingsi7.99 2236533000 2.237E+09 ww.k 7459620236 7.46E109 20 25.99 12 66.55 10 55.99 1 22.99 25.99 17.99 4 66.55 1 22.99 23 15 23 65896321 Johnso 65896321 Johnson 258 East Liber Deweyton NM CA NI 689 West Star Snowton 65896395 Zernger 65896328 Jensen 6.5896333 Hunsaker 65896395 Zenger 65896395 Zenger 758 Fast liber Deweyton 258 East Liber Deweytor 689 West Stai Snowton 99.95 35.22 15 NM 14 18 20 75 Unnormailized 1NF 2NF 3NF + 85% 809 AM 4/17/2019 Type here to search AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File AutoSum A | Fill 2h Wrap Text 11A A Calibri General . Paste Copy e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select B 1 u-Z: 2-A I U Merge & Cento . $ . % , t , dear. Format Painter Formatting TableStyles Alignment G19 AG AI AK AN AR AS AT AV 1 FmFirstName FmpTitleFmpBirthD. FmpHireDate FmpAddress Fmpcity FmpRegic FmpPostalc Fmpcountry FmpHomePho FmpFxtension FmpSalary RecipientName RecipientAd Recipientcity RecipientH R 7021 7021 7074 7001 7026 7077 7001 7001 Jr Sales Associa miu####u# 25-May-12 258 East Laven Denver r Sales Associa mitwanUG25-May-12 258 East Lavenia Street Ir Sales Associa 31-Der-675-Mar-1 4657 North Ho Colorado Spri CO r Sales Associi 30-Apr-64 Jr Sales Associa mtttttttttttt 12/2/1995 1256 North Mē Star Valley WY Sr Sales Associ ######### 9/1/2010 456 Fast Trail Boulder CC] r Sales Associi 30-Apr-64 Sr Sales AssociaiIMM9/6/1988 3456 View Linc Littleton CO CO CO 80125 USA 80125 USA 0757 ISA 80253 USA 81265 USA 80774 USA 80253 USA 80253 USA 7806333352 7806333352 7806337849 7806569800 075689865 7806343675 7806569800 7806569800 33021 Johri Henry 1259 East Fi Lincoln 33021 John Henry 1259 East Γι Lincoln 36710 leff Jnnas 7 55600 Jack Seamons 23598 Nort Chino 12012 Johnathan Seel 635 North SChicago 54378 Megan Hirschi 1345 Savan Salt Flat 55600 Rhonida Iigran 846 East 78 Salt Lake City UT 55600 Rhonda Ingran 846 East 78 Salt Lake City UT NE NE A7 WA 3 Eric 4 Iori 5 Kimberly 6 Beth T lisa 8 Kimberly 768 South 4 Yuma 6-Sep-88 3456 ViewLic Litleon CO 6-Sep-88 3456 View Lic Litleon CO Kimberly 12 14 18 20 21 23 Unnormailized 1NF 2NF 3NF E匹- + 85% 8:11 AM Type here to search 4/17/2019 AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File AutoSum A Wrap Text Calibri General 입dear. e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select Paste Copy B 1 u·Z: 2. Merge & Cento . $ . % , Formatting TableStyles Alignment G19 AP AR AS AT AV AW AY AZ B8 8D 1 FmpHomePhoFmpFxtension FmpSalary RecipientName RecipientAd Recipientcity Recipientf RecipientPos RecipientCountry ShipperD ShippingC ShippingComf ShipperPhone 2 7806333352 3 7806333352 4 7806337849 5 7806569800 6 7075689865 T7806343675 8 7806569800 9 7806569800 CustomerTypelD stomerDescription 7021 7021 7074 33021 John Henry 1259 East Fi LincolnNE 33021 John Henry 1259 East Lincoln 36710 leff lonas 55600 Jack Seanons 23598 Nort Chino 2012 Johnathan Seel 635 North S ChicagoIL 54378 Megan Hirschi 1345 Savan Salt Flat 55600 Rhonda Ingran 846 East 78 Salt Lake City UT 55600 Rhonda Ingran 846 East 78 Salt Lake City UT 65987 USA 65987 USA 89657 USA 96895 USA 65986 USA 81739 USA 84122 USA 84122 USA FE 「E 6.99 FedEx 6.99 FedEx 2458547855 MedCo 2458547855 MedCo 3169 76935 Med( 8006953000 Cust 2458547855 Corp 8006953000 Smallco 3659872222 SmaliCo 3659872222 SmallCo Mediurrm Sized C Medium Sized C Medium Sized Co 768 South 4Yuma 7.5 DHI Gilohal WA USPS ГЕ 12.99 US Postal 8.25 FedEx .96 US Postal Sen .55 United Postal 7.55 United Postal Small Sized Company Srnall Sized Company Small Sized Company 7077 7001 7001 12 18 20 Unnormailized 1NF 2NF 3NF 85% 812 AM 4/17/2019 Type here to search Show transcribed image text NormalizationCompany-Revised Compatibility Mode Excel AutoSave ( Insert Page Layout Formulas Data Review View Help Team ell me what you want to do File Σ AutoSum . A Cut Wrap Text 11A A Calibri General Fill Clear , Copy ?m eo .no Conditional Format as Cel Insert Delete Format Sorti&Find & Filter Select B 1 u . -. 2-A. Merge & Cente . $ . % , . y’r Pan. o Formatting- TableStyles Cells Clipboard Alignment Styles Editing G19 1 Order Nur OrderDat ustomer Nu CompanyName ContactName Contcle Addss City 2 125658 23-Nov-13 236589 Jones Ultimate Sy John Hery Salesan 1259 East Licolrn NE 3 125658 11/23/2013 236589 Jones Ultimate Sy John Henry Salesman 1259 East Fremont NE 4 1756 78-Now-13 5 125659 24-Nov-13 236596 Jones Ultimate Sy Lee Johnson Salesnan 4568 VaniGalvaston TX 6 125660 25-Nov-13 236588 Utility Supplies Susan Gordon Operations M 2319 Wes Yuma AZ 7 | 12566, 29-Nov-13 236 79Я Western Systems Megan Hirschi Receptionist 1345 Sava Salt Flat wy 8 125663 30-Nov-13 236850 Bear County Inn Rhonda Ingran Order Adnini 846 East 7 Salt Lake CUT 9 125663 11/30/2013 236850 Bear County Inn Rhonda Ingram Order Admini 846 East 7 Salt Lake CUT Region Postalcde Country Phone Fax 65987 USA 65987 USA 65987 USA ProductiD ProductName SupplierCon SupplierContacN Sup 2.59E092.59E+09 1254788 Miracle Sleep Pillow Sleep Impro Jessie Jonas Sh 2.59티09 2.59티092102986 King Size Comforter Comfort Sol Nathan Green Ma Sleep impro less e lonas Sleep impro Jessie Jonas Ship Ship 736589 lones ltimate Sy lohn Henry Salesman 1759 Fastincoln N 게게門 1010233 Megastar won eTam 7.766E+09 none 7.779티097.779티091254788 Miracle Sleep Pillow 54986 USA 1010233 MegaStar Weed Tamer WeedTirne FShellie Jackson Cler 1900917 Infant Sheet Protector Comfort Sol Nathan Green 2102986 Kin Size Comforter Comfort Sol Nathan Greer Mar 1010233 MegaStar Weed Tamer WeedTime I ShellksonCler 94321 USA 81739 USA 84122 USA 84122 USA B.349F+09 none 8.0 19E+09 none 8.019 09 none 10 12 14 16 18 20 24 Unnormailized 1NF 2NF 3NF 85% 805 AM 4/17/2019 Type here to search
AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File Cut Copy Format Painter AutoSum A Fill Wrap Text Calibri General 입dear. e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select B 1 u·Z: 2. I U Merge & Cento . $ . % , Formatting TableStyles Alignment G19 从 AC AE 1 SupplierContaciSupplierAddre SupplierCity 2 Shipping Clerk 12879 North IHoneyville 3 Manager 4 Shipping Clerk 12879 North IHoneyville 5 Clerk 6 Shipping Clerk 12879 North Honeyville T Manager 8 Marnager 9 Clerk SupplierRegio SupplierPostalC.oc SupplierCountry SupplierFax SupplierHom UnitPrice Quantity Productr ProductUnitsInSto FmployeelD Fmpl 32.99 99.95 98635 USA 12569 USA 98635 ISA 79632 USA 98635 USA 17569 USA 12569 USA 79632 USA 9655222525 9.655E+09 www.s 2236533000 2.237E109 www.kingsiz 965577255 9.655F09 ww.sleend 64.99 7459620236 7.46E+09 www.weedti 9655222525 9.65SE109 www.sleepd 32.99 7736533OO .237F09 ww.kingsi7.99 2236533000 2.237E+09 ww.k 7459620236 7.46E109 20 25.99 12 66.55 10 55.99 1 22.99 25.99 17.99 4 66.55 1 22.99 23 15 23 65896321 Johnso 65896321 Johnson 258 East Liber Deweyton NM CA NI 689 West Star Snowton 65896395 Zernger 65896328 Jensen 6.5896333 Hunsaker 65896395 Zenger 65896395 Zenger 758 Fast liber Deweyton 258 East Liber Deweytor 689 West Stai Snowton 99.95 35.22 15 NM 14 18 20 75 Unnormailized 1NF 2NF 3NF + 85% 809 AM 4/17/2019 Type here to search
AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File AutoSum A | Fill 2h Wrap Text 11A A Calibri General . Paste Copy e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select B 1 u-Z: 2-A I U Merge & Cento . $ . % , t , dear. Format Painter Formatting TableStyles Alignment G19 AG AI AK AN AR AS AT AV 1 FmFirstName FmpTitleFmpBirthD. FmpHireDate FmpAddress Fmpcity FmpRegic FmpPostalc Fmpcountry FmpHomePho FmpFxtension FmpSalary RecipientName RecipientAd Recipientcity RecipientH R 7021 7021 7074 7001 7026 7077 7001 7001 Jr Sales Associa miu####u# 25-May-12 258 East Laven Denver r Sales Associa mitwanUG25-May-12 258 East Lavenia Street Ir Sales Associa 31-Der-675-Mar-1 4657 North Ho Colorado Spri CO r Sales Associi 30-Apr-64 Jr Sales Associa mtttttttttttt 12/2/1995 1256 North Mē Star Valley WY Sr Sales Associ ######### 9/1/2010 456 Fast Trail Boulder CC] r Sales Associi 30-Apr-64 Sr Sales AssociaiIMM9/6/1988 3456 View Linc Littleton CO CO CO 80125 USA 80125 USA 0757 ISA 80253 USA 81265 USA 80774 USA 80253 USA 80253 USA 7806333352 7806333352 7806337849 7806569800 075689865 7806343675 7806569800 7806569800 33021 Johri Henry 1259 East Fi Lincoln 33021 John Henry 1259 East Γι Lincoln 36710 leff Jnnas 7 55600 Jack Seamons 23598 Nort Chino 12012 Johnathan Seel 635 North SChicago 54378 Megan Hirschi 1345 Savan Salt Flat 55600 Rhonida Iigran 846 East 78 Salt Lake City UT 55600 Rhonda Ingran 846 East 78 Salt Lake City UT NE NE A7 WA 3 Eric 4 Iori 5 Kimberly 6 Beth T lisa 8 Kimberly 768 South 4 Yuma 6-Sep-88 3456 ViewLic Litleon CO 6-Sep-88 3456 View Lic Litleon CO Kimberly 12 14 18 20 21 23 Unnormailized 1NF 2NF 3NF E匹- + 85% 8:11 AM Type here to search 4/17/2019
AutoSave ( NormalizationCompany-Revised Compatibility Mode Excel Insert Page Layout Formulas Data Review View Help Tea lell me what you want to do File AutoSum A Wrap Text Calibri General 입dear. e 0 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select Paste Copy B 1 u·Z: 2. Merge & Cento . $ . % , Formatting TableStyles Alignment G19 AP AR AS AT AV AW AY AZ B8 8D 1 FmpHomePhoFmpFxtension FmpSalary RecipientName RecipientAd Recipientcity Recipientf RecipientPos RecipientCountry ShipperD ShippingC ShippingComf ShipperPhone 2 7806333352 3 7806333352 4 7806337849 5 7806569800 6 7075689865 T7806343675 8 7806569800 9 7806569800 CustomerTypelD stomerDescription 7021 7021 7074 33021 John Henry 1259 East Fi LincolnNE 33021 John Henry 1259 East Lincoln 36710 leff lonas 55600 Jack Seanons 23598 Nort Chino 2012 Johnathan Seel 635 North S ChicagoIL 54378 Megan Hirschi 1345 Savan Salt Flat 55600 Rhonda Ingran 846 East 78 Salt Lake City UT 55600 Rhonda Ingran 846 East 78 Salt Lake City UT 65987 USA 65987 USA 89657 USA 96895 USA 65986 USA 81739 USA 84122 USA 84122 USA FE 「E 6.99 FedEx 6.99 FedEx 2458547855 MedCo 2458547855 MedCo 3169 76935 Med( 8006953000 Cust 2458547855 Corp 8006953000 Smallco 3659872222 SmaliCo 3659872222 SmallCo Mediurrm Sized C Medium Sized C Medium Sized Co 768 South 4Yuma 7.5 DHI Gilohal WA USPS ГЕ 12.99 US Postal 8.25 FedEx .96 US Postal Sen .55 United Postal 7.55 United Postal Small Sized Company Srnall Sized Company Small Sized Company 7077 7001 7001 12 18 20 Unnormailized 1NF 2NF 3NF 85% 812 AM 4/17/2019 Type here to search
Expert Answer
Answer to Use the attached file to normalize the data. Create a new tab for each normal form. Start with Unnormalized data. Normal… . . .
OR
