Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

M?teri IDAdSoyadCinsiyetDo?um TarihiTelefon Numaras?EmailAdres Metni?le?lKay?t TarihiHarcama Miktar?Harcama TarihiHarcama Tutar?BankaHarcama TipiKart TipiHarcama EnlemHarcama Boylam 012835RavenPatelErkek01/06/1958213.373.3987x214irichards@example.org62322 Henderson Hollow Apt. 887 Nancymouth, SD 79597shireMelissahaven8/26/2022430.7901/03/2023389.32Bank ATransferMastercard-53.243647-134.510342 164287ErikTapiaKadn09/03/1933+1-886-594-1897x11289daniel34@example.org832 Mark Parkway

M?teri IDAdSoyadCinsiyetDo?um TarihiTelefon Numaras?EmailAdres Metni?le?lKay?t TarihiHarcama Miktar?Harcama TarihiHarcama Tutar?BankaHarcama TipiKart TipiHarcama EnlemHarcama Boylam 012835RavenPatelErkek01/06/1958213.373.3987x214irichards@example.org"62322 Henderson Hollow Apt. 887 Nancymouth, SD 79597"shireMelissahaven8/26/2022430.7901/03/2023389.32Bank ATransferMastercard-53.243647-134.510342 164287ErikTapiaKadn09/03/1933+1-886-594-1897x11289daniel34@example.org"832 Mark Parkway Suite 161 Thomasside, TN 91226"portEast Bryan12/15/2021435.2706/08/2023138.38Bank BAlveriMastercard57.337336-94.155159 227276SeanWilliamsErkek9/28/1967507.567.8503x451bishopmichael@example.net"1793 Mata Harbor Apt. 404 North Amandaview, VA 03460"fortWest Debbie4/13/2020399.778/27/2023169.35Bank AFatura demesiAmerican Express55.502187-173.470994 337620CarolynWrightErkek11/07/1938811.591.4673valerie84@example.net"84075 Kyle Walk Huertamouth, CA 82472"furtSouth Lauren6/30/2022284.8907/12/2023196.62Bank AFatura demesiMastercard-74.5505038.735809 418500DustinWhitakerErkek08/05/1933+1-617-514-1984x61429qrodriguez@example.org"PSC 5921, Box 3618 APO AE 81377"villeWoodmouth4/24/2021100.504/08/2023245.79Bank CFatura demesiAmerican Express14.2368812.596534 511511JoseDavisKadn11/01/19993155363603abigailhowell@example.net"034 Travis Mountains Port Charlesborough, NC 35134"shireTravisberg8/19/2022207.2303/08/2023445.66Bank AFatura demesiVisa-89.339438-6.705346 688994TimothyDorseyErkek02/10/1968001-375-323-7397x2047peter17@example.net"37346 Matthew Loop Suite 946 North Gregoryfurt, NJ 08002"sideFranklinland12/15/2022138.066/27/2023493.76Bank BTransferMastercard15.386183134.595 754389DanielleMartinezKadn12/26/1977001-461-539-4964brandi51@example.com"PSC 4155, Box 6093 APO AA 48297"tonMeganburgh09/06/2021119.5902/11/2023369.76Bank BFatura demesiAmerican Express-85.313818101.190109 828135JohnMartinezKadn7/26/1961488.601.7236allison77@example.net"027 Harrison Inlet Jeffreymouth, MP 22352"chesterEast Alanberg04/06/2023389.8612/03/2023337.59Bank BFatura demesiVisa49.423331-6.080746 932652SeanKleinKadn08/08/19676817183682julie10@example.com"Unit 5431 Box 2198 DPO AE 51098"landNorth Jessicastad05/08/2022341.3412/09/2023107.36Bank ATransferMastercard-24.272433-7.93904 1023292JohnMcdowellKadn11/30/1972(660)943-7285mclark@example.com"05159 Carney Lake Suite 594 Port Melissa, KY 64640"tonGillbury5/23/202226.4911/17/2023413.72Bank CFatura demesiVisa-70.801609-9.037274 1129913JessicaJosephKadn9/27/1965-8104reyeselizabeth@example.com"USNV Bradley FPO AA 44668"stadWest Johnfort6/21/2021300.875/22/2023190Bank BTransferAmerican Express-17.445636-10.916069 1222076JacobCoxKadn9/17/1997001-787-574-0273mcarter@example.com"96159 John Harbors New Kimberly, WY 11845"sideMillerchester09/12/2020481.077/19/2023198.35Bank AFatura demesiAmerican Express32.818787155.602382 1365911DianaGrantErkek01/09/2002390.727.1618xfarrell@example.org"PSC 5232, Box 1001 APO AA 44271"furtWest Karenview8/25/202131.054/25/202360.07Bank BTransferVisa-18.874097-49.623966 1424211MarcusMckenzieErkek07/10/1989001-968-966-8988x25859lawrence05@example.com"PSC 9496, Box 0649 APO AE 76974"stadSouth Whitney9/30/202358.539/28/2023301.5Bank CFatura demesiMastercard76.85319768.480996 1553365MatthewPinedaErkek12/02/1950809.496.6057x949daviserin@example.net"783 Green Crest East Gail, CT 79271"boroughLauratown8/24/2022338.914/25/2023119.52Bank AFatura demesiAmerican Express-75.722109-81.342944 1692247MariahJonesKadn03/08/1962661-238-5166x49076vperez@example.org"25482 Miller Park East Sharon, AZ 42896"townEast Erichaven12/04/2021483.126/17/2023447.1Bank CTransferAmerican Express-21.527446-143.877771 1760076SheilaSantosKadn2/13/1996001-551-906-9178x898karen38@example.net"USNV Bowers FPO AP 12474"landAnthonyville10/24/202343.836/16/2023459.38Bank BTransferAmerican Express62.534246-158.089352 1827604SamuelHermanErkek1/18/1979716-527-3400x496oliviabecker@example.org"81900 Taylor Springs North Rogerborough, ID 39045"tonNorth Maryfurt9/27/202119.9608/02/202384.68Bank AAlveriVisa29.563751-104.872928 1945404BaileyMartinErkek4/25/2004+1-922-404-2582x68750melvindominguez@example.com"562 White Throughway Apt. 429 Mooneystad, TX 94452"fortBrianfurt11/15/2022323.702/08/202382.01Bank BAlveriVisa89.10332132.056379 2079021TaylorLongKadn7/21/1936603-679-4092jreed@example.net"20304 Juan Burgs Wongtown, WV 95312"fortMichaelborough3/27/2022129.7302/12/2023382.53Bank BTransferMastercard82.19719841.921847 2136999SherryEnglishKadn1/25/1999651.617.5360x70542teresahall@example.com"056 Douglas Turnpike Suite 035 New Johnside, AL 60323"mouthScottfort7/28/2022238.254/24/2023234.57Bank AFatura demesiAmerican Express-24.075912157.119968 2227243BrittanyCrossKadn10/08/19419714169897matthewmolina@example.net"368 William Gardens Kiddmouth, NJ 46927"portCynthiaberg05/11/2021290.613/23/202321.84Bank BAlveriAmerican Express2.613952-167.542656 2310678AndrewKellerErkek10/27/1943891-514-5155x5257sarahgeorge@example.com"Unit 4187 Box 3734 DPO AA 93398"stadPaynefort10/12/2023298.761/31/2023460.06Bank AFatura demesiAmerican Express78.58466434.706243 2472218ChristopherDouglasKadn12/22/1983001-568-464-1909x616sandra45@example.org"Unit 3672 Box 5101 DPO AE 80846"tonMontgomeryville9/17/202378.1410/29/2023365.98Bank BTransferVisa-49.15708-144.672388 2559723AndrewJonesKadn3/28/19926348319357hintonjames@example.com"30710 Sara Inlet Port Savannah, AL 25624"stadDavidchester5/31/202374.501/08/2023262.16Bank CFatura demesiMastercard-44.15827897.353772 2677830AmyMuellerErkek10/08/19679123746158michael43@example.com"07249 Joel View Garnerchester, SC 13522"bergMcgrathbury12/20/2022200.965/20/202343.14Bank ATransferAmerican Express55.181864-102.816307 2782391WendyMclaughlinKadn09/11/1953+1-444-579-8855x410racheljohnson@example.org"6410 Jennifer Freeway Apt. 049 South Mark, PA 47387"landEast Jonathan5/25/2022451.288/25/2023103.42Bank BFatura demesiAmerican Express43.299526-120.873908 2853873JerryHubbardErkek8/20/1937912.261.5083edwardsdonna@example.com"14455 Oneill Center Suite 916 Lake Jonathanbury, SC 09553"townPort Nicholasville10/26/2021251.977/27/202382.23Bank AAlveriMastercard-53.125768-72.757367 2985837JustinMooneyErkek12/30/1939339-931-4107timothyswanson@example.net"59166 Willie Flat Lake Eugenefort, IL 95130"fortHickmanbury9/22/202016.183/28/2023393.38Bank CTransferAmerican Express-10.51786131.338278 3077006EricGregoryKadn6/27/1934905-413-8007x62378higginsjesse@example.com"PSC 9125, Box 4309 APO AA 60010"stadSouth Ian3/29/2021264.153/28/2023396.05Bank BFatura demesiVisa-49.784906143.481821 3153587RyanHartErkek6/30/1953643-221-3575x929baileyjames@example.net"6905 Hunter Groves Stephaniebury, OR 88317"fortNorth Francisco12/04/2020488.0110/13/2023424.23Bank CTransferVisa6.81122772.742543 324061NathanBrownErkek02/08/1991+1-956-292-0807x75794howelldenise@example.com"542 Laura Junctions Lake Robert, LA 58620"sideAbbottfort05/05/2022215.8909/05/2023196.95Bank BTransferMastercard76.520266-100.576902 3343804JuliaPetersonErkek10/03/1956+1-560-610-4482x82986meghan30@example.net"3570 Eric Views New Carrie, FM 78660"shireWest Dustin01/04/2021260.155/16/2023198.47Bank BTransferVisa-54.512999-118.331277 345406AprilMartinErkek01/07/1939253.508.4970x994jacob28@example.com"6009 Bell Field Apt. 686 Woodbury, MD 09178"fortEnglishbury8/15/2023236.9311/19/2023351.78Bank ATransferAmerican Express-22.399694-111.988091 3557495MichelleGonzalezErkek8/24/1990001-925-375-6074x9260nathan32@example.net"349 Le Locks Apt. 354 Douglasfort, PW 58702"burghGeorgeberg07/07/2022473.447/28/2023361.12Bank BFatura demesiAmerican Express3.711168-69.115234 3695211KatrinaCainErkek7/24/1964-10332garciadaniel@example.org"616 Ann Land East Linda, AR 06565"tonMontoyamouth10/27/2020290.062/21/2023402.3Bank AAlveriMastercard54.006097127.379351 3775837KevinSweeneyKadn2/22/1982+1-875-938-2130x75595shernandez@example.com"15123 Williams Manor Watersburgh, WY 27092"boroughRivashaven1/31/2021302.8808/09/2023344.73Bank CTransferMastercard18.80659149.934858 3851169MorganThomasErkek10/04/1995616-295-0974x226jmorrison@example.org"5564 Yates Neck East Angelafort, MO 19207"havenMosleyshire10/31/2021427.396/26/2023300.63Bank AAlveriAmerican Express-45.188834-166.409734 3912371DawnMartinezKadn6/28/20058272950898xcastro@example.com"98044 Boyd Trafficway Suite 296 Sherrychester, WV 57453"fortTracyfort7/22/202186.4911/04/2023289.59Bank BTransferAmerican Express-9.033639135.539839 4088263JasonAlexanderErkek1/24/1963+1-852-491-7657x1757christopher02@example.com"827 Anthony Tunnel Suite 946 Rachaelport, WV 38080"shireNorth Alexandra7/19/2020326.224/20/2023244.6Bank BAlveriAmerican Express-28.142197169.467027 4120812RebeccaOchoaKadn01/04/1992(417)429-4210klester@example.org"361 Tucker Road Apt. 118 South Kylemouth, MN 82829"stadEast Cynthiaburgh03/06/202116008/10/2023396.4Bank ATransferAmerican Express-12.480213-40.984488 4278848MeganWhiteKadn7/20/1979549.377.7750x0093averyrichard@example.org"6701 Carpenter Mall Suite 066 Reneeshire, KY 88126"portMcdonaldmouth02/05/2021459.2901/06/2023430.27Bank AFatura demesiMastercard0.75182855.717502 4321372GregoryAvilaKadn9/13/1977965.323.3462x34670emilymccoy@example.net"115 Sean Ferry Lake Ronaldhaven, RI 15685"boroughAliciatown8/25/2021449.351/21/2023350Bank CAlveriMastercard40.2516455.664819 4465997ElizabethFoxKadn05/10/1979+1-799-478-2412x92030ysaunders@example.com"256 Morales Hill Apt. 307 Howardchester, MA 29915"boroughLarryview3/21/202147.032/25/202372.26Bank BTransferAmerican Express-60.01060728.344945 4527486ZacharyFlemingKadn01/12/1944769.574.7433david44@example.org"9687 Sandy Via East Natasha, NJ 22926"sideWest Bethany04/10/202256.848/14/2023232.6Bank CFatura demesiAmerican Express43.340228-3.016474 4690660PamelaReedKadn6/25/1957+1-851-698-3782x1754bvazquez@example.net"PSC 3715, Box 9709 APO AA 90775"bergLisaland07/04/2022465.725/31/2023310.13Bank CTransferMastercard-69.6515576.206661 4786759SeanMillerKadn8/21/1971-6647pnelson@example.net"55135 Jimmy Port Apt. 877 Powersstad, MI 48532"havenSchneiderhaven05/08/202321.1210/11/2023130.63Bank CTransferVisa-9.977351-121.024574 4828893AngelaMatthewsKadn11/06/1943+1-342-923-4669x9885ronaldlewis@example.com"USNS Tran FPO AE 58223"mouthMaryville12/09/2020242.3808/02/202357.92Bank AAlveriMastercard-24.540115121.334117 4931760MargaretMcneilErkek12/21/1951(343)692-2006x807christopherlamb@example.com"461 Sullivan Street Apt. 950 South Ashleyfurt, NV 82362"chesterEast Mckenzie1/21/2020305.597/22/2023150.08Bank CFatura demesiVisa-9.08838293.352934 5058346MarkDanielsErkek03/08/1939638-722-4651kevinboyer@example.com"9129 Garcia Run Apt. 794 Andradeville, MT 30592"havenEast Patricia5/14/2020143.1407/08/2023342.83Bank ATransferVisa-83.916511-115.351035

this is a 50 row of data from excell file that is mentioned on the bottom of the picture I am sending I want you to do this task with those 50 rows and make me understand how can I do it on the exact hw our dear lovely super duper suger lecturer gave 1000 rows of data so pls help me and get a solid thumbs up

image text in transcribed

18:00 23:59 The assignment involves you doing the following work on the data set shared with you in the attachment; 1- Examining the data set and evaluating the examination results; a. Understanding the dataset: The first step in EDA is to understand the dataset. This should include the size of the dataset, data types, variable names, and whether there is any missing or incorrect data. b. Data cleaning: If there is missing or incorrect data in the dataset, you need to clean it. This may include removing or correcting missing or inaccurate data from the dataset. 2- You should start preparing the assignment in a power point presentation, starting with the work done in the first article. 3- You need to create tables according to the 3rd Normal Form (3NF) setup using the data set. 4- You are expected to model the created tables by establishing two of them as in the example below; Figurel 1 - Sample 3NF Modelling View 5- You need to create 2 sample visualization studies using the data set and add them to the presentation. 6- You need to explain the work you have done above in the relevant slide and add details to the presentation. 3- The data you will use for the assignment is in the excel document below. Veri Modelleme Odev.csv

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Android 4 Application Development

Authors: Reto Meier

3rd Edition

1118223853, 9781118223857

More Books

Students also viewed these Programming questions

Question

On a scale of 1-10 how funny would you say you are?

Answered: 1 week ago

Question

Discuss about training and development in India?

Answered: 1 week ago

Question

Explain the various techniques of training and development.

Answered: 1 week ago

Question

Explain the various techniques of Management Development.

Answered: 1 week ago