IS 443/543 Database Design Individual Project Due Date: January 27, 2022 Deliverables: Legibly handwritten or machine-typed answers Total points: 25 Consider the following file structure of a database for a video rental business (1) Discuss the data redundancy and data anomalies exhibited by the file structure. (2) How many tables would you use to eliminate the problems? Draw the new table structures you would recommend and show the records in each table. Video Rental TrD Went Date Vide_ID Last Name FirstName Der date 4232000 V203 111 Laster Elroy 4/28/2020 111 Lacaster Jones 88888 4/23/2020 4/23/2020 4242020 424/2030 2242020 54/2020 Bey and Dog FI Earth Cost A The Terminal The Train V202 V304 V211 1413 V525 V304 Elroy La Charlie Charlie Charlie Elroy 4/28/2020 425/2020 4/28/2010 427/2020 4/27/2020 5/9/2020 Washington Washington Lancaster 333 111 Video_IDunique ID number assigned to each movie title. Assume each title has one copy for renting. Optional: what tables you need if each title has multiple copies. IS 443/543 Database Design Individual Project 1 Due Dates: January 27, 2022 Deliverables: legibly handwrimen or machine-typed swers Total points: 25 Consider the following file structure of a database for a video rental business (1) Discuss the data redundancy and data anomalies exhibited by the file structure (2) How many tables would you use to eliminate the problems? Draw the new table structures you would recommend and show the records in each table. Video Rental TrID Rest Date Veo ID CID Title Law Time Due date 423.2020 V200 Boy and Dog Elroy 41202020 Lac Jones 10 120 30 30 30 2 elle 303 23 2020 1423/2020 404/2100 4342020 42020 544/20.30 V200 V300 V21 VO2 1923 V304 Earth CA The Terminal The Ta Elmer LE Charlie Charlie Charlie 42.2020 25 2020 428 2020 4272020 427/2000 592020 333 Washington Washington Video_ID: unique ID number assigned to cach movie title. Assume each title has one copy for renting. Optional: what tables you need if each title has multiple copies