**I have created the databases already I just need the querries for # 5 that is below in bold.

1.) Create the database 2.) Create the tables in including appropriate data types (Actors, Movies, ActorMovies, Directors) 3.) Create appropriate foreign key constraints 4.) Add data including at least 5 movies, the director, and at least 3 actors from each movie (put yourself in as an actor in at least two movies)

5.) Create and run the following queries. For each query copy and paste or screenshot the query and submit the result to assignment:

a query that joins the tables and displays all actors and all movies

a query that joins the tables and displays all actors in a particular movie

a query that joins the tables and displays only the movies in which you are an actor

create two additional queries of your choice that displays the data in a way that could be useful

3.) Submit your queries and the results they produce.

Maroon Box ERD Actor ActorlD Int, auto_increment PK MovielD Int, auto increment ActorMovies Title Varchar(50) PKFK ActorlD Int Int Int PK/FK MovielD DOB Date ReleaseDate MPAARating DirectorID Date Varchar(5) Int Char(1) FK Director PK DirectorID Int, auto_increment Fname DOB Date Gender Char(1)