Crowdly

Add to Chrome

Given the following SQL query: Film ( FilmID , Title, Year, Genre, DirectorID)...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Given the following SQL query:

Film (FilmID, Title, Year, Genre, DirectorID)

Director (DirectorID, Name, BirthYear, Nationality)

Actor (ActorID, Name, BirthYear, Nationality)

Film_Actor (FilmID, ActorID, Role)

SELECT f.Title

FROM Film f

JOIN Film_Actor fa1 ON f.FilmID = fa1.FilmID

JOIN Actor a1 ON fa1.ActorID = a1.ActorID

JOIN Film_Actor fa2 ON f.FilmID = fa2.FilmID

JOIN Actor a2 ON fa2.ActorID = a2.ActorID

WHERE a1.Name = 'Leonardo DiCaprio' AND a2.Name = 'Tom Hanks';

Which of the following Relational Algebra expressions correctly represents this query?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome