Question: Implement the following queries using SQL. (a) retrieve all the character names being acted in the film The Godfather II. (b) find all the actors

 Implement the following queries using SQL. (a) retrieve all the character

Implement the following queries using SQL.

(a) retrieve all the character names being acted in the film The Godfather II.

(b) find all the actors who had acted in more than two(2) films. For each such actor, retrieve his/her First Name, Last Name, and the number of films (s)he had acted in.

(c) retrieve the total number of prices the films had received in which the actor Robert De Niro acted.

Consider the following ACTORS, FILMS and ACTEDIN relations for this problem. The Primary Keys of the relations are underlined. Foreign Key Constraints are represented by arrows. ACTORS ( SSNo, FName, LName, YearOfBirth, Gender) FILMS ( FilmNo, FilmTitle, YearOfProduction, NumberOfPrices, Lengthin Mins) ACTEDIN ( SSNo, FilmNo, Character )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!