Answered step by step
Verified Expert Solution
Question
1 Approved Answer
We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City_Studio) Title Year Length Actor Genre Studio Rating R City_Studio Hollywood Jaws 1975
We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City_Studio) Title Year Length Actor Genre Studio Rating R City_Studio Hollywood Jaws 1975 124 Roy Schneider Jaws 1975 124 Robert Shaw Horror Horror Horror Universal Universal Universal R Hollywood Jaws 1975 124 Richard Dreyfus R Hollywood Alien 1979 117 Sci-Fi Fox Hollywood Mary Poppins 1964 139 Sigourney Weaver Julie Andrews Dick Van Dyke Disney G Mary Poppins 1964 Disney 139 212 Ben Hur 1959 Charlton Heston MGM Musical Musical History History Fantasy Fantasy Buena Vista Buena Vista Hollywood Hollywood Culver City Culver City Ben Hur 1959 212 PG-13 PG-13 PG PG Ghostbusters 1984 1984 Martha Scott Sigourney Weaver Bill Murray 105 105 MGM Columbia Columbia Ghostbusters 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...I 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 QUESTIONS Use: Title - T, Year - Y, Length - L, Genre - G, Studio - S, City Studio - C, Actor Rating - R A, QUESTIONS Use: Title T, Year Y, Length -L, Genre G, Studio - S, City_Studio - C, Actor - A, Rating R 1) Explain (not just list) all the anomalies that you can find in the Movie relation. (10p)
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