home / study / engineering / computer science / computer science questions and answers / sql database queries question: consider the following database which has the following relations: ...

Question: SQL Database queries question: Consider the following database which has the following relations:...

Edit question

SQL Database queries question:

Consider the following database which has the following relations:

Movies ( title, year, length, genre, studioName, producer_id )

Stars ( movieTitle, movieYear, starName )

MovieStar ( name, address, gender, birthdate )

MovieExec ( name, id, address, networth )

Studio ( name, address, president_id )

Where movie executives can be producers or studio presidents and they have unique id numbers. Assume that names of people are unique, there is one producer of each movie, and each studio has one president.

Express the following queries using SQL:

3. (a) Find names of movie stars who starred in no movies produced by Columbia Pictures in 2017 (Using the EXCEPT operator)

(b) Find names of movie stars who starred in no movies produced by Columbia Pictures in 2017 (Without using the EXCEPT operator)

(c) Find movie stars who only star in movies that are produced by producers that have the same address as them.