Using the data in the form

Using draw.io, create an 3NF entity-relationship diagram Populated each table (entity) in your ER model with the actual data from the spreadsheet Accepted Submission Formats:

draw.io or image (screenshot, jpg or pdf) file of your ER diagram Excel files with your populated tables(or screenshot) Excel: One tab per table

B D E F G . J K M N O R S 1402 last_name Maskelyne Adiscot D'Alessandro Hardaker Hardaker Rainsden Hardaker 900 Frew Audi 1 claim_number 2 825577585-4 3 551566602-X 4. 764248818-1 5 491153365-X 6 363813291-9 7 378698442-5 8 515302178-5 9 640090895-1 LO 722686195-X 11 713938793-1 L2 565071283-2 13 281158537-0 14 011904756-X 15 413007080-0 16 355337367-9 17 140354879-X 18 077971001-0 19 410091436-9 20 915934411-3 21 claim_date 2020/12/15 2020/3/13 2020/5/30 2019/12/16 2020/3/2 2020/1/22 2019/11/28 2019/7/30 2019/11/4 2019/6/2 2019/11/8 2019/11/15 2020/3/3 2019/10/28 2019/11/20 2020/3/7 2020/3/29 2019/12/27 2020/2/19 amount status policy_number 6139 approved 143.26.68.156 19480 denied 96.251.185.36 28177 approved 210.94.90.7 8739 pending 243.167.44.242 31376 pending 243.167.44.242 35245 denied 201.69.129.228 23777 denied 242.217.130.38 35051 pending 165.95.87.36 37347 approved 188.152.216.15 17326 denied 188.152.216.15 34985 denied 149.34.98.135 47882 pending 129.252.59.95 26085 denied 144.199.242.96 24594 approved 144.199.242.96 4620 approved 144.199.242.96 11846 denied 144.249.43.87 41865 approved 30.167.27.56 5559 approved 249.17.98.80 500 denied 85.188.173.79 limit deductible expiration_date vehicle_id_number 8382 569 01/25/2021 WAULC58E25A064279 21334 11/08/2020 3N1CN7AP 8EL050824 31249 1237 07/09/2020 1FAHP2D86DG756056 8853 650 04/01/2020 2B3CA7CW4AH779243 8853 650 04/01/2020 2B3CA7CW4AH779243 37832 1017 11/23/2020 1G4GE5GD7BF392007 25736 532 05/26/2020 166AH5RX7E0485743 38510 1115 01/03/2020 2T3BF4DVOAW107972 41197 506 03/10/2020 WAUVC58E72A415210 41197 506 03/10/2020 WAUVC58E72A415210 37976 677 10/09/2020 1CORD7JT1CS818334 48334 1164 08/27/2020 WAULT58E75A684531 28410 1976 04/02/2020 JN1AJOHP4AM968005 28410 1976 04/02/2020 JN1AJOHP4AM968005 28410 1976 04/02/2020 JN1AJOHP4AM968005 16080 1938 11/26/2020 1G4HF5EMSAU 357211 45120 1632 09/04/2020 WUARL48H18K621654 8136 704 05/08/2020 166AK5S34F0214570 2924 1668 04/10/2020 WDDLJ6FB3FA137898 car_make car_model model_year customer_number Ford Thunderbird 1988 1005-00 Acura CL 2001 1005-07 1005-14 Oldsmobile 88 1005-21 Oldsmobile 88 1005-21 Volkswagen R32 2008 1005-28 Toyota Highlander 2009 1005-21 Saab 1987 1005-49 RS4 2007 1005-56 Audi RS4 2007 1005-56 Toyota Camry 2003 1005-70 Porsche 911 1996 1005-77 Mazda Miata MX-5 1993 1005-84 Mazda Miata MX-5 1993 1005-84 Mazda Miata MX-5 1993 1005-84 Infiniti Q 1992 1005-91 Volvo S60 1006-19 Ford Escort 2004 1006-26 Toyota Tacoma 1006-26 first_name Haily Conan Darya Griz Griz Joete Griz Pate Marla Marla Lorain Chiquita Yves Yves Yves Elsinore Spenser Lucien Lucien Buckley Buckley Howroyd Spires Carlyon Carlyon Carlyon Strangman Crosston Bordes Bordes street_address 79873 Hudson Alley 12453 Maple Place 6777 Hanson Center 147 Memorial Junction 147 Memorial Junction 61990 Norway Maple Junction 147 Memorial Junction 7 Laurel Court 7 Knutson Terrace 7 Knutson Terrace 63943 Bashford Way 66 Troy Trail 78969 Arkansas Pass 78969 Arkansas Pass 78969 Arkansas Pass 43 Lillian Road 89346 Toban Center 64804 Thackeray Junction 64804 Thackeray Junction city state Washington District of Columbia Denver Colorado Lancaster Pennsylvania Indianapolis Indiana Indianapolis Indiana Saint Paul Minnesota Indianapolis Indiana Bakersfield California El Paso Texas El Paso Texas Austin Texas Jacksonville Florida Baltimore Maryland Baltimore Maryland Baltimore Maryland Baton Rouge Louisiana Stockton California Tallahassee Florida Tallahassee Florida postal_code 20566 80299 17622 46216 46216 55172 46216 93381 79934 79934 78703 32230 21282 21282 21282 70820 95219 32309 32309 B D E F G . J K M N O R S 1402 last_name Maskelyne Adiscot D'Alessandro Hardaker Hardaker Rainsden Hardaker 900 Frew Audi 1 claim_number 2 825577585-4 3 551566602-X 4. 764248818-1 5 491153365-X 6 363813291-9 7 378698442-5 8 515302178-5 9 640090895-1 LO 722686195-X 11 713938793-1 L2 565071283-2 13 281158537-0 14 011904756-X 15 413007080-0 16 355337367-9 17 140354879-X 18 077971001-0 19 410091436-9 20 915934411-3 21 claim_date 2020/12/15 2020/3/13 2020/5/30 2019/12/16 2020/3/2 2020/1/22 2019/11/28 2019/7/30 2019/11/4 2019/6/2 2019/11/8 2019/11/15 2020/3/3 2019/10/28 2019/11/20 2020/3/7 2020/3/29 2019/12/27 2020/2/19 amount status policy_number 6139 approved 143.26.68.156 19480 denied 96.251.185.36 28177 approved 210.94.90.7 8739 pending 243.167.44.242 31376 pending 243.167.44.242 35245 denied 201.69.129.228 23777 denied 242.217.130.38 35051 pending 165.95.87.36 37347 approved 188.152.216.15 17326 denied 188.152.216.15 34985 denied 149.34.98.135 47882 pending 129.252.59.95 26085 denied 144.199.242.96 24594 approved 144.199.242.96 4620 approved 144.199.242.96 11846 denied 144.249.43.87 41865 approved 30.167.27.56 5559 approved 249.17.98.80 500 denied 85.188.173.79 limit deductible expiration_date vehicle_id_number 8382 569 01/25/2021 WAULC58E25A064279 21334 11/08/2020 3N1CN7AP 8EL050824 31249 1237 07/09/2020 1FAHP2D86DG756056 8853 650 04/01/2020 2B3CA7CW4AH779243 8853 650 04/01/2020 2B3CA7CW4AH779243 37832 1017 11/23/2020 1G4GE5GD7BF392007 25736 532 05/26/2020 166AH5RX7E0485743 38510 1115 01/03/2020 2T3BF4DVOAW107972 41197 506 03/10/2020 WAUVC58E72A415210 41197 506 03/10/2020 WAUVC58E72A415210 37976 677 10/09/2020 1CORD7JT1CS818334 48334 1164 08/27/2020 WAULT58E75A684531 28410 1976 04/02/2020 JN1AJOHP4AM968005 28410 1976 04/02/2020 JN1AJOHP4AM968005 28410 1976 04/02/2020 JN1AJOHP4AM968005 16080 1938 11/26/2020 1G4HF5EMSAU 357211 45120 1632 09/04/2020 WUARL48H18K621654 8136 704 05/08/2020 166AK5S34F0214570 2924 1668 04/10/2020 WDDLJ6FB3FA137898 car_make car_model model_year customer_number Ford Thunderbird 1988 1005-00 Acura CL 2001 1005-07 1005-14 Oldsmobile 88 1005-21 Oldsmobile 88 1005-21 Volkswagen R32 2008 1005-28 Toyota Highlander 2009 1005-21 Saab 1987 1005-49 RS4 2007 1005-56 Audi RS4 2007 1005-56 Toyota Camry 2003 1005-70 Porsche 911 1996 1005-77 Mazda Miata MX-5 1993 1005-84 Mazda Miata MX-5 1993 1005-84 Mazda Miata MX-5 1993 1005-84 Infiniti Q 1992 1005-91 Volvo S60 1006-19 Ford Escort 2004 1006-26 Toyota Tacoma 1006-26 first_name Haily Conan Darya Griz Griz Joete Griz Pate Marla Marla Lorain Chiquita Yves Yves Yves Elsinore Spenser Lucien Lucien Buckley Buckley Howroyd Spires Carlyon Carlyon Carlyon Strangman Crosston Bordes Bordes street_address 79873 Hudson Alley 12453 Maple Place 6777 Hanson Center 147 Memorial Junction 147 Memorial Junction 61990 Norway Maple Junction 147 Memorial Junction 7 Laurel Court 7 Knutson Terrace 7 Knutson Terrace 63943 Bashford Way 66 Troy Trail 78969 Arkansas Pass 78969 Arkansas Pass 78969 Arkansas Pass 43 Lillian Road 89346 Toban Center 64804 Thackeray Junction 64804 Thackeray Junction city state Washington District of Columbia Denver Colorado Lancaster Pennsylvania Indianapolis Indiana Indianapolis Indiana Saint Paul Minnesota Indianapolis Indiana Bakersfield California El Paso Texas El Paso Texas Austin Texas Jacksonville Florida Baltimore Maryland Baltimore Maryland Baltimore Maryland Baton Rouge Louisiana Stockton California Tallahassee Florida Tallahassee Florida postal_code 20566 80299 17622 46216 46216 55172 46216 93381 79934 79934 78703 32230 21282 21282 21282 70820 95219 32309 32309