Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Databases Concepts And Practice

Authors: Suzanne W Dietrich

1st Edition

1119827949, 9781119827948

More Books

Students also viewed these Databases questions

Question

=+j Describe an effective crisis management program.

Answered: 1 week ago