ID 1 2 3 4 NULL Format 35MM Digital 3D IMAX 35MM NULL 3 4 4. Using the table above for formats, what data redundancies do you detect (1pt)? 2 ID ActorName MovieID Film Character 1 1 Gal Gadot 1 Wonder Woman 2 2 Tom Holland 9 Spideman 3 3 Tom Holland 7 Spideman 4 4 Vin Diesel 5 Dominic Toretto 5 5 Scarlett Johansson 7 Natasha Romanoff 6 6 Tom Hardy 9 Venom 7 7 Hiroyuki Sanada 6 Scorpion 8 8 Ludi Lin 6 Liu Kang 9 9 Daniel Nelson 6 Kabal 10 10 Sisi Stringer 6 Mileena 11 11 Josh Lawson 6 Kano 5. Using the table above for actors, where do you see data redundancies, explain why it would be a problem (3pt)? 6. Using the actors table, what changes would you recommend for the ActorName field (2pt)? 1 2 WN 3 125 4 4 un 5 6 ID ActorName MovielD Film Character 1 Gal Gadot 1 Wonder Woman 2. Tom Holland 9 Spiderman 3 Tom Holland 7 Spiderman 4 Vin Diesel 5 Dominic Toretto 5 Scarlett Johansson 7 Natasha Romanoff 6 Tom Hardy 9 Venom 7 Hiroyuki Sanada 6 Scorpion 8 Ludi Lin 6 Liu Kang 9 Daniel Nelson 6 Kabal 10 Sisi Stringer 6 Mileena 11 Josh Lawson 6 Kano 6 ID Movie Name Release Date Rating RunTime_Minutes 1 Wonder Woman 1984 2020-12-25 3 151 2 Tom and Jerry 2021-02-26 1 96 3 Ghostbusters: Afterlife 2021-03-05 3 Morbius 2021-03-19 3 137 5 F9 2021-04-02 3 128 6 Mortal Kombat 2021-04-16 4 100 7 Black Widow 2021-05-07 3 129 8 Godzilla Vs Kong 2021-05-21 4 144 9 Venom: Let There Be Camage 2021-06-25 4 147 10 Tenet 2020-09-03 3 11 The Croods: A New Age 2020-11-25 2 95 7 8 9 10 11 150 23 7. What problems would you encounter if you deleted the Mortal Kombat movie (2pt)? 8. What is the most used language to access databases (1pt)? 9. What is metadata (2pt)? 10. Why is database design important (3pt)? 11. A question to the database is known as a what (1 pt)? 12. A spur of the moment question to the database is known as what (1pt)? 13. What is something you interact with daily that is likely using a database? Explain why you believe a database is being used. 14. What are some basic database functions that a spreadsheet (such as an Excel document) cannot perform