Question: SQL language 5 points Suppose we have the following relational model: Movie(mov_id(PK), title, yr) Person(pid(PK), fname, Iname, gender) Acts_In(actor_id(PFK), movie_id(PFK), role) -- actor_id references Person,
SQL language

5 points Suppose we have the following relational model: Movie(mov_id(PK), title, yr) Person(pid(PK), fname, Iname, 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 title, yr FROM Movie m WHERE NOT EXISTS (SELECT* FROM Movie m2 WHERE m1.title = m2.title) Movies where at least one other movie has the same title Movies with an empty string title Movies where no other movie has the same title Movies with a null title
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
