Movies(movieid, title, year) People(pid, name) Genres(gid, genre) ActsIn(pid, movieid) HasRole(pid, movieid, role) HasGenre(gid, movieid) a) Discuss with example what problems this database may suffer due to data redundancy. b) Write a SQL view to show the pid and movieid where the name of the actor is ‘Tom Hanks’ and the movie must belong to the ‘Action’ Genre. c) Write an SQL query that produces output of the form genre, total (that counts the number of movies associated with a pair of distinct genres). Each pair of genres should only appear once in the result. Show them according to the ascending order to total number
