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

 Could anybody help with this? Please use MYSQK Workbench please, thankyou!! Create a new schema; name it your "[first_name] [last_name)". Create the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!