Suppose we have the following relational model:

Movie(mov_id(PK), title, yr)

Person(pid(PK), fname, lname, gender)

Acts_In(actor_id(PFK), movie_id(PFK), role) -- actor_id references Person, movie_id references Movie

What would be true of the following query?

SELECT fname, lname

FROM Movie m, Acts_In a, Person p

WHERE mov_id = movie_id AND actor_id = pid AND yr = 2022

Suppose we have the following relational model:

Movie(mov_id(PK), title, yr)

Person(pid(PK), fname, lname, gender)

Acts_In(actor_id(PFK), movie_id(PFK), role) -- actor_id references Person, movie_id references Movie

What would be true of the following query?

SELECT fname, lname

FROM Movie m, Acts_In a, Person p

WHERE mov_id = movie_id AND actor_id = pid AND yr = 2022

a. It produces the names of all actors

b. It produces the names of actors who were in exactly 1 movie released in 2022

c. It produces the names of actors who were in every movie released in 2022

d. It produces names of actors who had a role in a movie released in 2022