SQL Database. I need help creating this database in MYSQL and I can not seem to figure out the correct code this is what I have so far but I am unable to get it correct.

This is the database I am supposed to create.

My code so far:

CREATE TABLE Customers

(Customer ID CHAR (4) PRIMARY KEY,

Customer Name CHAR (20),

Customer Address CHAR (15),

Customer City CHAR (15),

Customer State CHAR (2),

Customer Zip CHAR (5) );

Customer Phone Number CHAR (10));

CREATE TABLE Items

(Item Id CHAR (4) PRIMARY KEY,

Title CHAR (20),

Artist CHAR (20),

Unit Price DECIMAL (3,2),

On Hand CHAR (3));

CREATE TABLE Orders

(Order Id CHAR (1) PRIMARY KEY,

Customer CHAR (4),

Order Date CHAR (10),

Ship Date CHAR (10));

CREATE TABLE ORDERLINE

(Order Id CHAR (1) PRIMARY KEY,

Item Id CHAR (3),

Order Quantity CHAR (1));

INSERT INTO Customers

VALUES

(1000, Cora Blanca ,1555 Seminole Ct. , Charlotte, NC ,28210 ,704/552.1810),

(1100,Yash Reed, 878 Madison Ave., Greensboro ,NC ,27407 ,336/316-5434 )

(1200, John Mills , 4200 Olive Ave. , Columbia, SC, 29206 , 803/432.6225 )

(1300 , David Cox ,608 Old Post Rd. , Decatur ,GA, 30030 ,404/243.7379 )

(1400 , Tina Evans, 235 Easton Ave. , Jacksonville, FL , 32221, 904/992-7234 )

(1500 , Will Allen, 2508 W. Shaw Rd., Raleigh , NC , 27542 , 919/809.2545 )

(1600, James Boyd , 200 Pembury Ln. , Columbia, SC , 29206, 803/432-7600 )

(1700, Will Parsons , 4990 S. Pine St. , Raleigh , NC , 27545, 919/355/0034 )

(1800, Walter Kelly , 1200 Little St. , Columbia , SC , 29206, 803/432-1987 )

(1900, Ann Damian, 7822 N. Ridge Rd., Jacksonville, FL , 32216, 904/725-4672 )

(2000, Grace Hull , 4090Caldweld St. , Charlotte , NC , 28205 , 704/365.7655 )

(2100, Jane Brown , 3320 W. Main St. , Charlotte , NC , 28210, 704/372/9000 )

(2200, Betty Draper, 1600 Sardis Rd. ,Sarasota , FL , 32441, 918/941-9121);

INSERT INTO Items

VALUES

(100, Under the Sun Donald Arley, 46.80, 340 )

(200, Dark Lady , Keith Morris, 120.99, 250 )

(300, Happy Days Andrea Reid 78.00 210 )

(350 , Top of the Mountain , Janice Jones , 110.00 , 290 )

(400, Streets from Old, Sharon Brune, 123.00, 320 )

(450, The Hunt, Walter Alford, 39.99 , 390 )

(600, Rainbow Row, Judy Ford , 46.00 , 350 )

(700, Skies Above , Alexander Wilson, 98.00 , 275 )

(800, The Seas and Moon, Susan Beeler, 67.81 , 235 )

(850, Greek Isles , Benjamin Caudle , 76.00 , 300 );

INSERT INTO Orderline

VALUES

('1','800','2'),

('1', '600' , '1'),

('2', '700' , '3'),

('2', '300', '2'),

('3', '850', '1'),

('4', '200', '4'),

('4', '100', '1'),

('4', '850', '1'),

('5', '450', '1'),

('6', '800', '2'),

('7', '300', '2'),

('7', '600', '2'),

('8', '100' , '1'),

('9', '100', '3'),

('10', '450', '6'),

('10', '600', '8'),

('10', '200', '4'),

('11', '700' , '2'),

('12', '300', '3'),

('12', '700', '4'),

('13', '200', '2'),

('13', '600', '10'),

('13', '450', '4'),

('14', '700', '8'),

('14', '200', '6'),

('14', '800', '4'),

('14', '450', '2');

Pretty Prints ASSIGNMENT DESCRIPTION: A company named Pretty Prints is in the business of selling lithograph prints created by local artists When an artist creates a lithograph, S(he) creates several hundred prints from it. The company needs a database to manage orders. You are to create a database for this purpose and enter the existing data. The database should be named prints and is composed of the tables below You are asked to do the following Download the MySQL database management system along with the MySQL workbench. Also download connector/J After the download you are to use SQL to create a database named prints which is composed of these tables. Submit either a screenshot of the SQL commands or a script file containing the SQL into Moodle2 for grading TABLES: customers customer.id customer.name customer-add 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 Cora Blanca Yash Reed John Mills David Cox ina Evans Will Allen James Boyd Will Parsons Walter Kellv Ann Damian Grace Hull Jane Brown Betty Draper 1555 Seminole Ct Charlotte 878 Madison Ave. Greensboro 4200 Olive Ave 608 Old Post Rd 235 Easton Ave 2508 W. Shaw Rd. Raleigh 200 Pembury Ln 4990 S. Pine St. 1200 Little St. 7822 N. Ridge Rd.Jacksonville 4090Caldweld St. Charlotte 3320 W. Main St. Charlotte 1600 Sardis Rd customercity customer state customer.zip |customer.phane 704/552.1810 336/316-5434 803/432.6225 404/243.7379 904/992-7234 919/809.2545 803/432-7600 919/355/0034 803/432-1987 904/725-4672 704/365.7655 704/372/9000 918/941-9121 NC NC SC GA FL NC SC NC SC 28210 27407 29206 30030 32221 27542 29206 27545 29206 32216 28205 28210 32441 Columbia Decatur Jacksonville Columbia Raleigh Columbia NC NC 2200 Sarasota