Use the following E/R diagram to answer the following questions MOVIE TITLE MovielD Title Year Category...

Transcribed Image Text:

Use the following E/R diagram to answer the following questions MOVIE TITLE MovielD Title Year Category Rating No_Stars MOVIE_PERSON_JOIN MovielD (FK) PersonID (FK) DirectorFlag ActorFlag ActressFlag ProducerFlag Singer Flag PERSON PersonID Last Name First Name MName Gender i. Retrieve the year, category, and all actors/actresses in the movie titled 'A Beautiful Mind' using SQL. ii. Retrieve every movie's title, year, and category that has 'Tom Cruise' as an actor using SQL. Use the following E/R diagram to answer the following questions MOVIE TITLE MovielD Title Year Category Rating No_Stars MOVIE_PERSON_JOIN MovielD (FK) PersonID (FK) DirectorFlag ActorFlag ActressFlag ProducerFlag Singer Flag PERSON PersonID Last Name First Name MName Gender i. Retrieve the year, category, and all actors/actresses in the movie titled 'A Beautiful Mind' using SQL. ii. Retrieve every movie's title, year, and category that has 'Tom Cruise' as an actor using SQL.

Answer rating: 100% (QA)

The provided image contains an ER EntityRelationship diagram with three entities MOVIETITLE MOVIEPER... View the full answer