In this assignment, you will be creating the DDL SQL code $($create database $+$ create table statements$)$ to re$-$create the Access schema $($Jet DB engine, file$-$based$)$ in a MySQL RDS instance. then expect to lose points on syntax errors at minimum. Don't just make this up without actually running$/$testing it$...$

$1.$ Download the following Access file $($DO NOT USE ANY OTHER FILE$)$: AnnandaleCupcakes v$03.$accdb $\backslash (\backslash$downarrow $\backslash )$

$2.$ Using the Access design view for the tables, go through every table and write the equivalent SQL DDL code to create that table in MySQL$.$

$3.$ SUBMISSION: Simply COPY your SQL DDL code and PASTE it into the text$-$only submission box. DO NOT submit a screenshot of your code or schema.

$4.$ Make sure to actually RUN YOUR CODE in MySQL Workbench against your AWS MySQL instance TO ENSURE THAT IT WORKS.

$5.$ To get you started, below is the code to create the new database schema as well as the customer table. You must complete the code for the rest of the tables $($customer$\_$note, event, payment, product, sale, and sale$\_$item$).$

$```$

create database annandale$\_$cupcakes;

use annandale$\_$cupcakes;

create table customer $($

customer$\_$id int primary key auto$\_$increment,

first$\_$name varchar$(50),$

last$\_$name varchar$(50),$

phone$\_$number varchar$(20),$

email varchar$(30),$

street varchar$(100),$

city varchar$(50),$

state varchar$(25),$

zip varchar$(10),$

notes varchar$(255),$

created$\_$at datetime,

updated$\_$at datetime

$)$;

$```$