Please write the SQL statements needed to answer the following questions. Submit your statements as a Word or PDF file to the Blackboard course website by the due date.

Please use the following information and model to help you answer questions $13.$ For these questions, you will create a new database, titled recipes, on your MySQL instance installed on your computer.

$1.$ Using the model above, write SQL statements to create the following entities as tables in the recipes database. Include the required referential integrity constraints. Set all FK to the NOT NULL property. Also, set each of the PKs $($except the composite PK$)$ to auto$-$increment.

$2.$ Alter the recipe table to include another field, titled recipe$\_$author, with a varchar$(100)$ data type.

$3.$ Once you have completed questions $1$ and $2,$ drop each of your tables from the recipes database $($using SQL statements$).$ Did you run into any issues dropping the tables? If so$,$ what?

Please use the following information to help you answer question $4.$ For question $4,$ you will use the

sql$\_$practice database.

$4.$ For your work, you need the monthly order totals for each customer $($i$.$e$.,$ how much was spent each month by each customer$)$ returned in a list. To make using the returned results in other queries easier, you have decided to use a View to create a virtual table of the results. Using a single SQL statement, create a View in the sql$\_$practice database that displays this data when the View is called. Title the View monthly$\_$customer$\_$order$\_$totals. $($Hint: Make sure the SELECT statement works before creating the View. Also, think about what groups you will be creating.$)$