Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the data presented in the below table, how would I create an 3NF entity-relationship diagram in ERwin ? Pate Frew claim_number claim_date amount status
Using the data presented in the below table, how would I create an 3NF entity-relationship diagram in ERwin ?
Pate Frew claim_number claim_date amount status policy_number limit deductible expiration_date vehicle_id_number car_make car_model model_year customer_number first_name last_name street_address city state postal code 825577585-4 12/15/2020 6139 approved 143.26.68.156 8382 569 01/25/2021 WAULC58E25A064279 Ford Thunderbird 1988 1005-00 Haily Maskelyne 79873 Hudson Alley Washington District of Columbia 20566 551566602-X 3/13/2020 19480 denied 96.251.185.36 21334 1402 11/08/2020 3N1CN7AP8EL050824 Acura CL 2001 1005-07 Conan Adiscot 12453 Maple Place Denver Colorado 80299 764248818-15/30/2020 28177 approved 28177 approved 210.94.90.7 31249 1237 07/09/2020 1FAHP2D86DG756056 1005-14 Darya D'Alessandro 6777 Hanson Center Lancaster Pennsylvania 17622 491153365-X 12/16/2019 8739 pending 243.167.44.242 8853 650 04/01/2020 2B3CA7CW4AH779243 Oldsmobile 88 1005-21 Griz Hardaker 147 Memorial Junction Indianapolis Indiana 46216 363813291-9 3/2/2020 31376 pending 243.167.44.242 8853 650 04/01/2020 2B3CA7CW4AH779243 Oldsmobile 88 1005-21 Griz Hardaker 147 Memorial Junction Indianapolis Indiana 46216 378698442-5 1/22/2020 35245 denied 201.69.129.228 37832 1017 11/23/2020 164GE5GD7BF392007 Volkswagen R32 2008 1005-28 Joete Rainsden 61990 Norway Maple Junction Saint Paul Minnesota 55172 515302178-5 11/28/2019 23777 denied 242.217.130.38 25736 532 05/26/2020 1G6AH5RX7E0485743 Toyota Highlander 2009 1005-21 Griz Hardaker 147 Memorial Junction Indianapolis Indiana 46216 640090895-1 | 7/30/2019 35051 pending 165.95.87.36 38510 1115 01/03/2020 2T3BF4DVOAW107972 Saab 900 1987 1005-49 7 Laurel Court Bakersfield California 93381 722686195-X 11/4/2019 37347 approved 188.152.216.15 41197 506 03/10/2020 WAUVC58E72A415210 Audi RS4 2007 1005-56 Marla Buckley 7 7 Knutson Terrace El Paso Texas 79934 713938793-1 6/2/2019 17326 denied 188.152.216.1541197 506 03/10/2020 WAUVC58E72A415210 Audi RS4 2007 1005-56 Marla Buckley 7 Knutson Terrace El Paso Texas 79934 565071283-2 11/8/2019 34985 denied 149.34.98.135 37976 677 10/09/2020 1C6RD7JT1CS818334 Toyota Camry 2003 1005-70 Lorain Howroyd 63943 Bashford Way Austin Texas 78703 281158537-0 11/15/2019 47882 pending 129.252.59.95 48334 1164 08/27/2020 WAULT58E75A684531 Porsche 911 1996 1005-77 Chiquita Spires 66 Troy Trail Jacksonville Florida 32230 011904756-X 3/3/2020 26085 denied 144.199.242.9628410 1976 04/02/2020 JN1AJOHP4AM968005 Mazda Miata MX-5 1993 1005-84 Yves Carlyon 78969 Arkansas Pass Baltimore Maryland 21282 413007080-0 10/28/2019 24594 approved 144.199.242.96 28410 1976 04/02/2020 JN1AJOHP4AM968005 Mazda Miata MX-5 1993 1005-84 Yves Carlyon 78969 Arkansas Pass Baltimore Maryland 21282 355337367-9 11/20/2019 4620 approved 144.199.242.96 28410 1976 04/02/2020 JN1AJOHP4AM968005 Mazda Miata MX-5 1993 1005-84 Yves Carlyon 78969 Arkansas Pass Baltimore Maryland 21282 140354879-X 3/7/2020 11846 denied 144.249.43.87 16080 1938 11/26/2020 164HFSEMIAU357211 Infiniti Q 1992 1005-91 Elsinore Strangman 43 Lillian Road Baton Rouge Louisiana 70820 077971001-0 3/29/2020 41865 approved 30.167.27.56 45120 1632 09/04/2020 WUARL48H18K621654 Volvo S60 1006-19 Spenser Crosston 89346 Toban Center Stockton California 95219 410091436-9 12/27/2019 5559 approved 249.17.98.80 8136 704 05/08/2020 1G6AK5S34F0214570 Ford Escort 2004 1006-26 Lucien Bordes 64804 Thackeray Junction Tallahassee Florida 32309 915934411-32/19/2020 500 denied 85.188.173.79 2924 1668 04/10/2020 WDDUJ6FB3FA137898 Toyota Tacoma 1006-26 Lucien Bordes 64804 Thackeray Junction Tallahassee Florida 32309
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started