This assignment has two parts $-$ you will first need to load the Campus Eats database before completing the assignment. This can be a group assignment $($up to $4$ total students$)$ or individual. If you want to work with a group, you need to use "self$-$assign" to join a group with teammates that have agreed to join your group in the "Assignment $7"$ groups. You can simply drag your members into a group designed by "Assignment $7"$ and a number. If you want to work individually, you do not have to self$-$join a group.

Creating the Campus Eats Database:

For this assignment, you will use the campuseats.sql script to create the CampusEats database. Campus Eats is an $"$on campus" restaurant delivery app with a relational database in the back end.

Getting Started

Step $1$: Use the script to create the database $($script linked below$)$ in MySQL Workbench. Remember to refresh your schemas after running the script.

Step $2$: After creating the database, reverse engineer to the entity relationship diagram: From the menu select:

Database, reverse engineer, select Campus Eats database only.

Next Steps:

A$)$ Study the database EERD to familiarize yourself with the CampusEats database. This database tracks food deliveries on a campus.

B$)$ Using the Campus Eats Database, create the following stored procedures or functions. Turn in screen shots showing the code and results in a PDF document, along with the SQL code.

$1)$ Using Murach script $15-05$ as a guide, create a stored procedure or function that inserts a new row into the Restaurant table. Test with good and bad data.

$2)$ Using Murach script $15-09$ as a guide, create a stored procedure or function that returns the Driver$\_$Name given the Driver$\_$ID$.$ Test the function.

$3)$ Using Murach script $15-11$ as a guide, create a stored procedure or a function that returns the max, min and avg ratings for Restaurants. Test the function.

Deliverable: PDF or Word Document with screen shots showing the SQL statements $($include a comment with your name$)$ and the output.