Question: Please make sure you submit the homework via D 2 L . Submit your written solution in PDF format and the source files of your

Please make sure you submit the homework via D2L. Submit your written
solution in PDF format and the source files of your program as requested.
1.(20 pts) Consider the following schema for a movie database (the primary
keys of the tables are underlined). Foreign key constraints are also listed
under the schema of each table.
Person (ID, FirstName, LastName, Birthdate)
Movie (ID, Title, ReleaseYear, Director)
Movie(Director) references Person(ID)
Acts (ActorID, MovieID)
Acts(ActorID) references Person(ID)
Acts(MovieID) references Movie(ID)
Express each of the following query in SQL.
(a) Find the year in which the movie entitled Jurassic Park was released.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!