QuestionAnswered step-by-stepI have question for writing a question regarding my MIS 562 class:I can’t get the tables to create within MySQL and I’m not sure what’s going wrong.Must be a simply “-” or syntax error, but I can’t locate it.Anyone who could you help with answering the following:DROP TABLE IF EXISTS PROMOTION;DROP TABLE IF EXISTS BOOK_AUTHOR;DROP TABLE IF EXISTS ORDER_ITEMS;DROP TABLE IF EXISTS BOOKS;DROP TABLE IF EXISTS AUTHOR;DROP TABLE IF EXISTS PUBLISHER;DROP TABLE IF EXISTS BOOK_ORDER;DROP TABLE IF EXISTS BOOK_CUSTOMER;Create table Book_customer(CustomerID?NT(4) NOT NULL,LastName VARCHAR(10),FirstName VARCHAR(10),Address VARCHAR(20),City VARCHAR(20),State VARCHAR(2),Zip VARCHAR(5),Referred INT(4),PRIMARY KEY (CustomerID));INSERT INTO BOOK_CUSTOMERVALUES (1001, ‘MORALES’, ‘BONITA’, ‘P.O. BOX 651’, ‘EASTPOINT’, ‘FL’, ‘32328’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1002, ‘THOMPSON’, ‘RYAN’, ‘P.O. BOX 9835’, ‘SANTA MONICA’, ‘CA’, ‘90404’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1003, ‘SMITH’, ‘LEILA’, ‘P.O. BOX 66’, ‘TALLAHASSEE’, ‘FL’, ‘32306’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1004, ‘PIERSON’, ‘THOMAS’, ‘69821 SOUTH AVENUE’, ‘BOISE’, ‘ID’, ‘83707’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1005, ‘GIRARD’, ‘CINDY’, ‘P.O. BOX 851’, ‘SEATTLE’, ‘WA’, ‘98115’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1006, ‘CRUZ’, ‘MESHIA’, ’82 DIRT ROAD’, ‘ALBANY’, ‘NY’, ‘12211’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1007, ‘GIANA’, ‘TAMMY’, ‘9153 MAIN STREET’, ‘AUSTIN’, ‘TX’, ‘78710’, 1003);INSERT INTO BOOK_CUSTOMERVALUES (1008, ‘JONES’, ‘KENNETH’, ‘P.O. BOX 137’, ‘CHEYENNE’, ‘WY’, ‘82003’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1009, ‘PEREZ’, ‘JORGE’, ‘P.O. BOX 8564’, ‘BURBANK’, ‘CA’, ‘91510’, 1003);INSERT INTO BOOK_CUSTOMERVALUES (1010, ‘LUCAS’, ‘JAKE’, ‘114 EAST SAVANNAH’, ‘ATLANTA’, ‘GA’, ‘30314’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1011, ‘MCGOVERN’, ‘REESE’, ‘P.O. BOX 18’, ‘CHICAGO’, ‘IL’, ‘60606’, NULL);?NSERT INTO BOOK_CUSTOMERVALUES (1012, ‘MCKENZIE’, ‘WILLIAM’, ‘P.O. BOX 971’, ‘BOSTON’, ‘MA’, ‘02110’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1013, ‘NGUYEN’, ‘NICHOLAS’, ‘357 WHITE EAGLE AVE.’, ‘CLERMONT’, ‘FL’, ‘34711’, 1006);INSERT INTO BOOK_CUSTOMERVALUES (1014, ‘LEE’, ‘JASMINE’, ‘P.O. BOX 2947’, ‘CODY’, ‘WY’, ‘82414’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1015, ‘SCHELL’, ‘STEVE’, ‘P.O. BOX 677’, ‘MIAMI’, ‘FL’, ‘33111’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1016, ‘DAUM’, ‘MICHELL’, ‘9851231 LONG ROAD’, ‘BURBANK’, ‘CA’, ‘91508’, 1010);INSERT INTO BOOK_CUSTOMERVALUES (1017, ‘NELSON’, ‘BECCA’, ‘P.O. BOX 563’, ‘KALMAZOO’, ‘MI’, ‘49006’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1018, ‘MONTIASA’, ‘GREG’, ‘1008 GRAND AVENUE’, ‘MACON’, ‘GA’, ‘31206’, NULL);INSERT INTO BOOK_CUSTOMERVALUES (1019, ‘SMITH’, ‘JENNIFER’, ‘P.O. BOX 1151’, ‘MORRISTOWN’, ‘NJ’, ‘07962’, 1003);INSERT INTO BOOK_CUSTOMERVALUES (1020, ‘FALAH’, ‘KENNETH’, ‘P.O. BOX 335’, ‘TRENTON’, ‘NJ’, ‘08607’, NULL);Create Table Book_order(OrderID INT(4) NOT NULL,CustomerID INT(4),OrderDate DATE,ShipDate DATE,ShipStreet VARCHAR(20),ShipCity VARCHAR(20),ShipState VARCHAR(2),ShipZip VARCHAR(5),PRIMARY KEY (OrderID),FOREIGN KEY (CustomerID) REFERENCES BOOK_CUSTOMER (CustomerID));INSERT INTO BOOK_ORDERVALUES (1000,1005,’2014-3-09′,’2014-4-02′,’1201 ORANGE AVE’, ‘SEATTLE’, ‘WA’, ‘98114’);INSERT INTO BOOK_ORDERVALUES (1001,1010,’2014-3-09′,’2014-4-01′, ‘114 EAST SAVANNAH’, ‘ATLANTA’, ‘GA’, ‘30314’);INSERT INTO BOOK_ORDERVALUES (1002,1011,’2014-3-09′,’2014-4-01′,’58 TILA CIRCLE’, ‘CHICAGO’, ‘IL’, ‘60905’);INSERT INTO BOOK_ORDERVALUES (1003,1001,’2014-4-01′,’2014-4-01′,’958 MAGNOLIA LANE’, ‘EASTPOINT’, ‘FL’, ‘32328’);INSERT INTO BOOK_ORDERVALUES (1004,1020,’2014-4-01′,’2014-4-09′,’561 ROUNDABOUT WAY’, ‘TRENTON’, ‘NJ’, ‘08601’);INSERT INTO BOOK_ORDERVALUES (1005,1018,’2014-4-01′,’2014-4-02′, ‘1008 GRAND AVENUE’, ‘MACON’, ‘GA’, ‘31206’);INSERT INTO BOOK_ORDERVALUES (1006,1003,’2014-4-01′,’2014-4-02′,’558A CAPITOL HWY.’, ‘TALLAHASSEE’, ‘FL’, ‘32307’);INSERT INTO BOOK_ORDERVALUES (1007,1007,’2014-4-02′,’2014-4-04′, ‘9153 MAIN STREET’, ‘AUSTIN’, ‘TX’, ‘78710’);INSERT INTO BOOK_ORDERVALUES (1008,1004,’2014-4-02′,’2014-4-03′, ‘69821 SOUTH AVENUE’, ‘BOISE’, ‘ID’, ‘83707’);INSERT INTO BOOK_ORDERVALUES (1009,1005,’2014-4-03′,’2014-4-09′,’9 LIGHTENING RD.’, ‘SEATTLE’, ‘WA’, ‘98110’);INSERT INTO BOOK_ORDERVALUES (1010,1019,’2014-4-03′,’2014-4-04′,’384 WRONG WAY HOME’, ‘MORRISTOWN’, ‘NJ’, ‘07960’);INSERT INTO BOOK_ORDERVALUES (1011,1010,’2014-4-03′,’2014-4-09′, ‘102 WEST LAFAYETTE’, ‘ATLANTA’, ‘GA’, ‘30311’);INSERT INTO BOOK_ORDERVALUES (1012,1017,’2014-4-09′,NULL,’1295 WINDY AVENUE’, ‘KALMAZOO’, ‘MI’, ‘49002’);INSERT INTO BOOK_ORDERVALUES (1013,1014,’2014-4-03′,’2014-4-04′,’7618 MOUNTAIN RD.’, ‘CODY’, ‘WY’, ‘82414’);INSERT INTO BOOK_ORDERVALUES (1014,1007,’2013-12-09′,’2014-01-10′, ‘9153 MAIN STREET’, ‘AUSTIN’, ‘TX’, ‘78710’);INSERT INTO BOOK_ORDERVALUES (1015,1020,’2014-4-04′,NULL,’557 GLITTER ST.’, ‘TRENTON’, ‘NJ’, ‘08606’);INSERT INTO BOOK_ORDERVALUES (1016,1003,’2014-4-04′,NULL,’9901 SEMINOLE WAY’, ‘TALLAHASSEE’, ‘FL’, ‘32307’);INSERT INTO BOOK_ORDERVALUES (1017,1015,’2014-10-09′,’2014-10-10′,’887 HOT ASPHALT ST’, ‘MIAMI’, ‘FL’, ‘33112’);INSERT INTO BOOK_ORDERVALUES (1018,1001,’2014-09-05′,NULL,’95812 HIGHWAY 98′, ‘EASTPOINT’, ‘FL’, ‘32328’);INSERT INTO BOOK_ORDERVALUES (1019,1018,’2014-4-09′,NULL, ‘1008 GRAND AVENUE’, ‘MACON’, ‘GA’, ‘31206’);INSERT INTO BOOK_ORDERVALUES (1020,1008,’2014-05-09′,NULL,’195 JAMISON LANE’, ‘CHEYENNE’, ‘WY’, ‘82003’);Create Table Publisher(PubID INT(2) NOT NULL,PublisherName VARCHAR(23),ContactName VARCHAR(20),Phone VARCHAR(12),PRIMARY KEY (PubID));INSERT INTO PUBLISHERVALUES(1,’PRINTING IS US’,’TOMMIE SEYMOUR’,’800-714-8321′);INSERT INTO PUBLISHERVALUES(2,’PUBLISH OUR WAY’,’JANE TOMLIN’,’800-410-0010′);INSERT INTO PUBLISHERVALUES(3,’AMERICAN PUBLISHING’,’DAVID DAVIDSON’,’800-555-1211′);INSERT INTO PUBLISHERVALUES(4,’READING MATERIALS INC.’,’RENEE SMITH’,’800-555-9743′);INSERT INTO PUBLISHERVALUES(5,’REED-N-RITE’,’SEBASTIAN JONES’,’800-555-8284′);INSERT INTO PUBLISHERVALUES(6,’LITTLE HOUSE’,’DOUG COLLINS’,’800-515-2665′);Create Table Author(AuthorID INT(4) NOT NULL,Lname VARCHAR(10),Fname VARCHAR(10),PRIMARY KEY (AuthorID));INSERT INTO AUTHORVALUES (‘5100′,’SMITH’, ‘SAM’);INSERT INTO AUTHORVALUES (‘6100′,’JONES’,’JANICE’);INSERT INTO AUTHORVALUES (‘7100′,’AUSTIN’,’JAMES’);INSERT INTO AUTHORVALUES (‘8100′,’MARTINEZ’,’SHEILA’);INSERT INTO AUTHORVALUES (‘5110′,’KZOCHSKY’,’TAMARA’);INSERT INTO AUTHORVALUES (‘1100′,’PORTER’,’LISA’);INSERT INTO AUTHORVALUES (‘7105′,’ADAMS’,’JUAN’);INSERT INTO AUTHORVALUES (‘9100′,’BAKER’,’JACK’);?NSERT INTO AUTHORVALUES (‘1105′,’PETERSON’,’TINA’);INSERT INTO AUTHORVALUES (‘2100′,’WHITE’,’WILLIAM’);INSERT INTO AUTHORVALUES (‘2105′,’WHITE’,’LISA’);INSERT INTO AUTHORVALUES (‘3110′,’ROBINSON’,’ROBERT’);INSERT INTO AUTHORVALUES (‘4110′,’FIELDS’,’OSCAR’);INSERT INTO AUTHORVALUES (‘2110′,’WILKINSON’,’ANTHONY’);Create table Books(BookID INT(15) NOT NULL,ISBN VARCHAR(10),Title VARCHAR(30),PubDate DATE,PubID INT (2),Cost DECIMAL (5,2),Retail DECIMAL (5,2),Category VARCHAR(12),PRIMARY KEY (BookID),FOREIGN KEY (PubID) REFERENCES PUBLISHER (PubID));INSERT INTO BOOKSVALUES (5001,’1059831198′,’BODYBUILD IN 10 MINUTES A DAY’,’2001-01-21′,4,18.75,30.95, ‘FITNESS’);INSERT INTO BOOKSVALUES (5002,’0401140733′,’REVENGE OF MICKEY’,’2001-12-12′,1,14.20,22.00, ‘FAMILY LIFE’);INSERT INTO BOOKSVALUES (5003,’4981341710′,’BUILDING A CAR WITH TOOTHPICKS’,’2002-03-18′,2,37.80,59.95, ‘CHILDREN’);INSERT INTO BOOKSVALUES (5004,’8843172113′,’DATABASE IMPLEMENTATION’,’2004-04-06′,3,31.40,55.95, ‘COMPUTER’);INSERT INTO BOOKSVALUES (5005,’3437212490′,’COOKING WITH MUSHROOMS’,’2000-01-02′,4,12.50,19.95, ‘COOKING’);INSERT INTO BOOKSVALUES (5006,’3957136468′,’HOLY GRAIL OF ORACLE’,’2001-12-31′,3,47.25,75.95, ‘COMPUTER’);INSERT INTO BOOKSVALUES (5007,’1915762492′,’HANDCRANKED COMPUTERS’,’2001-01-01′,3,21.80,25.00, ‘COMPUTER’);INSERT INTO BOOKSVALUES (5008,’9959789321′,’E-BUSINESS THE EASY WAY’,’2002-02-03′,2,37.90,54.50, ‘COMPUTER’);INSERT INTO BOOKSVALUES (5009,’2491748320′,’PAINLESS CHILD-REARING’,’2000-07-17′,5,48.00,89.95, ‘FAMILY LIFE’);INSERT INTO BOOKSVALUES (5010,’0299282519′,’THE WOK WAY TO COOK’,’2000-11-09′,4,19.00,28.75, ‘COOKING’);INSERT INTO BOOKSVALUES (5011,’8117949391′,’BIG BEAR AND LITTLE DOVE’,’2001-11-01′,5,5.32,8.95, ‘CHILDREN’);INSERT INTO BOOKSVALUES (5012,’0132149871′,’HOW TO GET FASTER PIZZA’,’2002-02-11′,4,17.85,29.95, ‘SELF HELP’);INSERT INTO BOOKSVALUES (5013,’9247381001′,’HOW TO MANAGE THE MANAGER’,’1999-05-01′,1,15.40,31.95, ‘BUSINESS’);INSERT INTO BOOKSVALUES (5014,’2147428890′,’SHORTEST POEMS’,’2001-05-01′,5,21.85,39.95, ‘LITERATURE’);CREATE TABLE ORDER_ITEMS(ORDERID INT(4) NOT NULL,ITEMNUM INT(2) NOT NULL,BOOKID INT(15) NOT NULL,QUANTITY INT(3),?RIMARY KEY (orderid, bookid),FOREIGN KEY (ORDERID) REFERENCES Book_Order (OrderID),FOREIGN KEY (BOOKID) REFERENCES BOOKS (BOOKID));INSERT INTO ORDER_ITEMSVALUES (1000,1,5005,1);?NSERT INTO ORDER_ITEMSVALUES (1001,1,5013,1);?NSERT INTO ORDER_ITEMSVALUES (1001,2,5009,1);?NSERT INTO ORDER_ITEMSVALUES (1002,1,5004,2);?NSERT INTO ORDER_ITEMSVALUES (1003,1,5004,1);?NSERT INTO ORDER_ITEMSVALUES (1003,2,5001,1);INSERT INTO ORDER_ITEMSVALUES (1003,3,5005,1);INSERT INTO ORDER_ITEMSVALUES (1004,1,5009,2);INSERT INTO ORDER_ITEMSVALUES (1005,1,5014,1);INSERT INTO ORDER_ITEMSVALUES (1006,1,5008,1);INSERT INTO ORDER_ITEMSVALUES (1007,1,5006,3);INSERT INTO ORDER_ITEMSVALUES (1007,2,5008,1);INSERT INTO ORDER_ITEMSVALUES (1007,3,5011,1);INSERT INTO ORDER_ITEMSVALUES (1007,4,5004,1);INSERT INTO ORDER_ITEMSVALUES (1008,1,5005,2);INSERT INTO ORDER_ITEMSVALUES (1009,1,5005,1);INSERT INTO ORDER_ITEMSVALUES (1009,2,5002,1);INSERT INTO ORDER_ITEMSVALUES (1010,1,5004,4);INSERT INTO ORDER_ITEMSVALUES (1011,1,5009,1);INSERT INTO ORDER_ITEMSVALUES (1012,1,5011,1);INSERT INTO ORDER_ITEMSVALUES (1012,2,5007,2);INSERT INTO ORDER_ITEMSVALUES (1012,3,5009,1);INSERT INTO ORDER_ITEMSVALUES (1012,4,5002,1);INSERT INTO ORDER_ITEMSVALUES (1013,1,5004,1);INSERT INTO ORDER_ITEMSVALUES (1014,1,5002,2);INSERT INTO ORDER_ITEMSVALUES (1015,1,5005,1);INSERT INTO ORDER_ITEMSVALUES (1016,1,5009,1);INSERT INTO ORDER_ITEMSVALUES (1017,1,5011,2);INSERT INTO ORDER_ITEMSVALUES (1018,1,5005,1);INSERT INTO ORDER_ITEMSVALUES (1018,2,5004,1);INSERT INTO ORDER_ITEMSVALUES (1019,1,5002,1);INSERT INTO ORDER_ITEMSVALUES (1020,1,5005,1);CREATE TABLE BOOK_AUTHOR(BOOKID INT(15) NOT NULL,AUTHORid INT(4) NOT NULL,PRIMARY KEY (BOOKID,AUTHORID),FOREIGN KEY (BOOKID) REFERENCES BOOKS (BOOKID),FOREIGN KEY (AUTHORID) REFERENCES Author (AUTHORID));INSERT INTO BOOK_AUTHORVALUES (5001,’5100′);INSERT INTO BOOK_AUTHORVALUES (5001,’1100′);INSERT INTO BOOK_AUTHORVALUES (5002,’6100′);INSERT INTO BOOK_AUTHORVALUES (5003,’5110′);INSERT INTO BOOK_AUTHORVALUES (5004,’1105′);INSERT INTO BOOK_AUTHORVALUES (5004,’7100′);INSERT INTO BOOK_AUTHORVALUES (5004,’7105′);INSERT INTO BOOK_AUTHORVALUES (5005,’9100′);INSERT INTO BOOK_AUTHORVALUES (5006,’7100′);INSERT INTO BOOK_AUTHORVALUES (5007,’2100′);INSERT INTO BOOK_AUTHORVALUES (5007,’2105′);INSERT INTO BOOK_AUTHORVALUES (5008,’6100′);INSERT INTO BOOK_AUTHORVALUES (5009,’3110′);INSERT INTO BOOK_AUTHORVALUES (5009,’4110′);INSERT INTO BOOK_AUTHORVALUES (5009,’9100′);INSERT INTO BOOK_AUTHORVALUES (5010,’5100′);INSERT INTO BOOK_AUTHORVALUES (5011,’3110′);INSERT INTO BOOK_AUTHORVALUES (5012,’5100′);INSERT INTO BOOK_AUTHORVALUES (5013,’2100′);INSERT INTO BOOK_AUTHORVALUES (5014,’2105′);create table promotion(PromotionID INT(3) NOT NULL,gift?ARCHAR(15),minretail DECIMAL(5,2),maxretail DECIMAL(5,2),PRIMARY KEY (PROMOTIONID));insert into promotion?alues (1,’BOOKMARKER’, 0, 12);insert into promotion?alues (2,’BOOK LABELS’, 12.01, 25);insert into promotionvalues (3, ‘BOOK COVER’, 25.01, 56);insert into promotionvalues (4, ‘FREE SHIPPING’, 56.01, 999.99);I greatly appreciate any and all help answering & will tip kindly.Thanks!A helpless AnalystComputer ScienceEngineering & TechnologyMYSQLMIS 562Share Question
Get a plagiarism-free order today we guarantee confidentiality and a professional paper and we will meet the deadline.