Create a formal database design for a Movie Database. The movie database will need to store information about movies, directors, actors, and studios. For movies, the database should store title, year, budget. For directors and actors, we only need to store first and last names and birthdates. For studios, we only need to store the names of the studios. The database design will need to allow us to determine who director was for each movie, which studio produced each movie, and which actors appeared in each movie. One other important requirement is that the design will need to store the role that each actor had in the movie

The only business rules you really need to know are

• Only one director can direct any given movie
• Only one studio can produce any given movie
• Obviously many actors appear in any given movie

Think about this. After the database is complete and the data is entered in, a person who uses it would be able show data for the following questions:

• Which movies were released in 2010?
• What movies has Harrison Ford appeared in?
• Which studio produced The Rookie?
• Which actors appeared in The Greatest Game Ever Played?