Homework 5 Computer Database, Each statement must not contain duplicates. Must be able to output the tables in MySQL Database Server.

DROP DATABASE IF EXISTS GShop; 10 CREATE DATABASE GShop; USE GShop; 12 13 14 Define tables 15 16 CREATE TABLE Employees( 17 18 19 20 21 empID CHAR(8), firstName varchar(20), lastName VARCHAR(20), ssn telNumber CHAR(13), salary DECIMAL (10,2), PRIMARY KEY (empID)); CHAR(11) 23 24 25 26 CREATE TABLE Items( 27 28 29 30 31 32 CHAR(5), VARCHAR(30), itemID name description VARCHAR(50), qtyInStock SMALLINT, PRIMARY KEY (itemID)); CREATE TABLE Suppliers( 34 35 36 supID CHAR(5), name VARCHAR (35), address VARCHAR(50), 37 38 PRIMARY KEY (supID)): 40