Question: Could anybody help with this? Please use MYSQK Workbench please, thank you!! Create a new schema; name it your [first_name] [last_name). Create the following tables

![you!! Create a new schema; name it your "[first_name] [last_name)". Create the](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f310f5df113_62166f310f57e1b2.jpg)
Could anybody help with this? Please use MYSQK Workbench please, thank you!!
Create a new schema; name it your "[first_name] [last_name)". Create the following tables in this schema: Table: Customer Field Data Type Notes customer_id INT primary key, Not Null, Auto_increment first_name VARCHAR(20) Not Null last_name VARCHAR(20) Not Null address 1 VARCHAR(60) Not Null address 2 VARCHAR(20) zip CHAR(5) Not Null city VARCHAR(20) Not Null state VARCHAR(2) Not Null Table: Sale Field Data Type Notes sale_id INT primary key, Not Null, Auto_increment date DATE() Not Null customer_id INT Foreign_KEY, Not Null References primary key of customer table Enter one record in each table: Enter your first and last name as customer number 1 in the customer table. Add random values for address, zip, city, and state. Sale table record's sale_id is "1", date is in YYYY-MM-DD" format (enter a real date), and customer_id is 1. Export your schema after saving the data. Rename the dump file as your "first_nam-Last_name-Assignment1" and upload here
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
