0 votes
in Database Management Systems by
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

1 Answer

0 votes
by
Thank you!!1

Related questions

Welcome to CPEN Talk
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

Chuck Norris can access the DB from the UI.
...