Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 GCP 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started