We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City Studio) Title Actor Genre Rating City_Studio Jaws Horror Year 1975 1975 1975 1979 Jaws Studio Universal Universal Universal Horror R Roy Schneider Robert Shaw Richard Dreyfus Sigourney Weaver Hollywood Hollywood Hollywood Jaws Length 124 124 124 117 139 139 212 Horror Alien Sci-Fi Fox Hollywood Mary Poppins Julie Andrews Musical Disney Buena Vista Dick Van Dyke Musical Disney Buena Vista Mary Poppins Ben Hur 1964 1964 1959 1959 Charlton Heston History MGM PG-13 PG-13 Hollywood Hollywood Ben Hur 212 Martha Scott Ghostbusters Sigourney Weaver 1984 1984 History Fantasy Fantasy 105 105 Culver City MGM Columbia Columbia PG PG Ghostbusters Bill Murray Culver City Where: - A movie can have different versions in different years but not with the same actor - Example, you can have Jaws in 1975 and Jaws in 2019 but Roy Schneider can't be in both. . The rating can be different in the different versions of the same movie - So Jaws 1975 can be R and Jaws 2019 can be PG-13 - A movie can have only one Genre Example, Alien is just sci-fi . A movie can not have different versions in the same year. - Example, we can't have two Jaws in 1975 . An actor can be in more than a movie the same year - Example: Charlton Heston can be in Ben Hur in 1959 and in Harry Potter in 1959 too (I know... / know... it is just an example) There is not any Studio with the headquarters in more than one city, but we can have 2 studios in the same city. - So, Universal can not be in Hollywood and in any other place, and MGM can be in Hollywood too. - An actor can work with more than one studio. . Example: Bill Murray can work in a Columbia's Movie and for MGM's movie Use: Title Rating R T, Year - Y, Length - L, Genre-G, Studio - S, City_Studio-C, Actor A, 1) Explain (not just list) all the anomalies that you can find in the Movie relation (10p) We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City Studio) Title Actor Genre Rating City_Studio Jaws Horror Year 1975 1975 1975 1979 Jaws Studio Universal Universal Universal Horror R Roy Schneider Robert Shaw Richard Dreyfus Sigourney Weaver Hollywood Hollywood Hollywood Jaws Length 124 124 124 117 139 139 212 Horror Alien Sci-Fi Fox Hollywood Mary Poppins Julie Andrews Musical Disney Buena Vista Dick Van Dyke Musical Disney Buena Vista Mary Poppins Ben Hur 1964 1964 1959 1959 Charlton Heston History MGM PG-13 PG-13 Hollywood Hollywood Ben Hur 212 Martha Scott Ghostbusters Sigourney Weaver 1984 1984 History Fantasy Fantasy 105 105 Culver City MGM Columbia Columbia PG PG Ghostbusters Bill Murray Culver City Where: - A movie can have different versions in different years but not with the same actor - Example, you can have Jaws in 1975 and Jaws in 2019 but Roy Schneider can't be in both. . The rating can be different in the different versions of the same movie - So Jaws 1975 can be R and Jaws 2019 can be PG-13 - A movie can have only one Genre Example, Alien is just sci-fi . A movie can not have different versions in the same year. - Example, we can't have two Jaws in 1975 . An actor can be in more than a movie the same year - Example: Charlton Heston can be in Ben Hur in 1959 and in Harry Potter in 1959 too (I know... / know... it is just an example) There is not any Studio with the headquarters in more than one city, but we can have 2 studios in the same city. - So, Universal can not be in Hollywood and in any other place, and MGM can be in Hollywood too. - An actor can work with more than one studio. . Example: Bill Murray can work in a Columbia's Movie and for MGM's movie Use: Title Rating R T, Year - Y, Length - L, Genre-G, Studio - S, City_Studio-C, Actor A, 1) Explain (not just list) all the anomalies that you can find in the Movie relation (10p)