0 votes
33 views
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

Your answer

Help us make this a great place for discussion by always working to provide accurate answers.
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
Write 2 in words
To avoid this verification in future, please log in or register.

Related questions

+1 vote
1 answer
+2 votes
1 answer
+1 vote
1 answer
+3 votes
1 answer
+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
+1 vote
1 answer
asked in Database Management Systems by (user.guest)
Welcome to CPEN Talk
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...