Consider the scenario from where you designed an ER diagram and relation schemas for the Movie database. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible.
Note: Please use the attached ER diagram and relation schemas #2 see image.
Relation schemes #2 (with {quotes} as a multi-value attribute)
Movies(movie_year_of_release, movie_title length_in_minutes, plot_outline, company_name)
Directors(director_name, director_date_of_birth)
Companies(company_name, address)
Actors(actor_name, actor_date_of_birth)
Direct(movie_year_of_release, movie_title, director_name, director_date_of birth)
Act (movie_year_of_release, movie_title, actor_name, actor_date_of_birth, role) Movie_Genres(genre, movie_year_of_release, movie_title)
Quotes(movie_year_of_release, movie_title, actor_name, actor_date_of_birth, quote)