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

WHERE NOT EXISTS (

SELECT 1

FROM Film_Actor fa

JOIN Actor a ON fa.ActorID = a.ActorID

WHERE fa.FilmID = f.FilmID AND a.Nationality <> 'American'

);

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

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

Add to Chrome