Database: Add, Display, Delete Records

For this interactive assignment, you will create three MySQL databasetables and write SQL scripts to read, insert, and delete data. Thefirst database table will contain the names of at least four of yourfavorite movies. The second table will be a list of actors who appear inthe movies. The third table will be an associative table that describesthe relationship between the actors and their movies (which actorsappear in which movies). Actors and movies have a “many-to-manyrelationship,” meaning an actor can be in multiple movies and a moviecan have multiple actors.
Use the MySQL Database
Download MySQL Databaseto create the three tables.Once you have completed your three tables, create a “join”statement that joins data from all three tables. Remember that fieldnames used in more than one table (ASIN, ActorID) must be fullyqualified (i.e., dvdtitle, ASIN).The previous SQL query returns a separate record for eachactor. Provide a way to group results from several records into a singlerow.
General guidelines for this interactive assignment:
String values in SQL statements are always enclosed withinsingle quotes. ASIN and Title are both strings and require singlequotes. For instance, your insert statement will look something likethis:
$sql = “Insert into dvdtitles (asin, title, price) VALUES (‘$asin’, ‘$title’, $price)”;
SQL debugging tip: check your SQL statement before youexecute it. Put the following line of code immediately before themysql_query($strSQL) statement.When retrieving ASIN from the querystring, remember that ASIN is a string, not a number.
Once you have completed the assignment, include the following in your initial post:
A Word document with screenshots of the tables you created.A Word document with the SQL statements that you used to create the tables and populate them with data.Explain how you grouped results from several records into a single row.