All of the questions in this assignment use the following database schema, in which the keys of each relation are underlined: Movie(title,year, director, budget, earnings) Actor(stagename, realname, birthyear) ActedIn(stagename, title, year, pay) CanWorkWithstagename, director) Note: the CanWorkWith relation stores information on which actors are able to work with which directors - this is important as occasionally an actor will absolutely refuse to work with a given director (or vice-versa)