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)