Please help me with the solution:INSERT INTO LINE VALUES('1001','1','123-21UUY','1','189.99'); INSERT INTO LINE VALUES('1001','2','SRE-657UG','3','2.99'); INSERT INTO LINE VALUES('1002','1','QER-34256','2','18.63'); INSERT INTO LINE VALUES('1003','1','ZZX/3245Q','1','6.79'); INSERT INTO LINE VALUES('1003','2','SRE-657UG','1','2.99'); INSERT INTO LINE VALUES('1003','3','001278-AB','1','12.95'); INSERT INTO LINE VALUES('1004','1','001278-AB','1','12.95'); INSERT INTO LINE VALUES('1004','2','SRE-657UG','2','2.99'); /* -- / CREATE TABLE PRODUCT ( PROD_CODE varchar(10), PROD_DESCRIPT varchar(35), PROD_PRICE numeric, PROD_ON_HAND int, VEND_CODE int ); INSERT INTO PRODUCT VALUES('001278-AB','Claw hammer','12.95','23','232'); INSERT INTO PRODUCT VALUES('123-21UUY','Houselite chain saw, 16-in. bar','189.99','4','235'); INSERT INTO PRODUCT VALUES('QER-34256','Sledge hammer, 16-lb. head','18.63','6','231'); INSERT INTO PRODUCT VALUES('SRE-657UG','Rat-tail file','2.99','15','232'); INSERT INTO PRODUCT VALUES('ZZX/3245Q','Steel tape, 12-ft. length','6.79','8','235'); / -- */ CREATE TABLE VENDOR ( VEND_CODE int, VEND_CONTACT varchar(25), VEND_AREACODE varchar(3), VEND_PHONE varchar(8) ); INSERT INTO VENDOR VALUES('230','Shelly K. Smithson','608','555-1234'); INSERT INTO VENDOR VALUES('231','James Johnson','615','123-4536'); INSERT INTO VENDOR VALUES('232','Annelise Crystall','608','224-2134'); INSERT INTO VENDOR VALUES('233','Candice Wallace','904','342-6567'); INSERT INTO VENDOR VALUES('234','Arthur Jones','615','123-3324'); INSERT INTO VENDOR VALUES('235','Henry Ortozo','615','899-3425');

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Please help me with the solution:INSERT INTO LINE VALUES('1001','1','123-21UUY','1','189.99'); INSERT INTO LINE VALUES('1001','2','SRE-657UG','3','2.99'); INSERT INTO LINE VALUES('1002','1','QER-34256','2','18.63'); INSERT INTO LINE VALUES('1003','1','ZZX/3245Q','1','6.79'); INSERT INTO LINE VALUES('1003','2','SRE-657UG','1','2.99'); INSERT INTO LINE VALUES('1003','3','001278-AB','1','12.95'); INSERT INTO LINE VALUES('1004','1','001278-AB','1','12.95'); INSERT INTO LINE VALUES('1004','2','SRE-657UG','2','2.99'); /* -- */ CREATE TABLE PRODUCT ( PROD_CODE varchar(10), PROD_DESCRIPT varchar(35), PROD_PRICE numeric, PROD_ON_HAND int, VEND_CODE int ); INSERT INTO PRODUCT VALUES('001278-AB','Claw hammer','12.95','23','232'); INSERT INTO PRODUCT VALUES('123-21UUY','Houselite chain saw, 16-in. bar','189.99','4','235'); INSERT INTO PRODUCT VALUES('QER-34256','Sledge hammer, 16-lb. head','18.63','6','231'); INSERT INTO PRODUCT VALUES('SRE-657UG','Rat-tail file','2.99','15','232'); INSERT INTO PRODUCT VALUES('ZZX/3245Q','Steel tape, 12-ft. length','6.79','8','235'); /* -- */ CREATE TABLE VENDOR ( VEND_CODE int, VEND_CONTACT varchar(25), VEND_AREACODE varchar(3), VEND_PHONE varchar(8) ); INSERT INTO VENDOR VALUES('230','Shelly K. Smithson','608','555-1234'); INSERT INTO VENDOR VALUES('231','James Johnson','615','123-4536'); INSERT INTO VENDOR VALUES('232','Annelise Crystall','608','224-2134'); INSERT INTO VENDOR VALUES('233','Candice Wallace','904','342-6567'); INSERT INTO VENDOR VALUES('234','Arthur Jones','615','123-3324'); INSERT INTO VENDOR VALUES('235','Henry Ortozo','615','899-3425');

TinyCollege/* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ CREATE TABLE CLASS ( CLASS_CODE varchar(5), CRS_CODE varchar(10), CLASS_SECTION varchar(2), CLASS_TIME varchar(20), CLASS_ROOM varchar(8), PROF_NUM numeric(8) ) ENGINE = INNODB; INSERT INTO CLASS VALUES('10012','ACCT-211','1','MWF 8:00-8:50 a.m.','BUS311','105'); INSERT INTO CLASS VALUES('10013','ACCT-211','2','MWF 9:00-9:50 a.m.','BUS200','105'); INSERT INTO CLASS VALUES('10014','ACCT-211','3','TTh 2:30-3:45 p.m.','BUS252','342'); INSERT INTO CLASS VALUES('10015','ACCT-212','1','MWF 10:00-10:50 a.m.','BUS311','301'); INSERT INTO CLASS VALUES('10016','ACCT-212','2','Th 6:00-8:40 p.m.','BUS252','301'); INSERT INTO CLASS VALUES('10017','CIS-220','1','MWF 9:00-9:50 a.m.','KLR209','228'); INSERT INTO CLASS VALUES('10018','CIS-220','2','MWF 9:00-9:50 a.m.','KLR211','114'); INSERT INTO CLASS VALUES('10019','CIS-220','3','MWF 10:00-10:50 a.m.','KLR209','228'); INSERT INTO CLASS VALUES('10020','CIS-420','1','W 6:00-8:40 p.m.','KLR209','162'); INSERT INTO CLASS VALUES('10021','QM-261','1','MWF 8:00-8:50 a.m.','KLR200','114'); INSERT INTO CLASS VALUES('10022','QM-261','2','TTh 1:00-2:15 p.m.','KLR200','114'); INSERT INTO CLASS VALUES('10023','QM-362','1','MWF 11:00-11:50 a.m.','KLR200','162'); INSERT INTO CLASS VALUES('10024','QM-362','2','TTh 2:30-3:45 p.m.','KLR200','162'); CREATE TABLE COURSE ( CRS_CODE varchar(10), DEPT_CODE varchar(10), CRS_DESCRIPTION varchar(35), CRS_CREDIT numeric(8) ) ENGINE = INNODB; INSERT INTO COURSE VALUES('ACCT-211','ACCT','Accounting I','3'); INSERT INTO COURSE VALUES('ACCT-212','ACCT','Accounting II','3'); INSERT INTO COURSE VALUES('CIS-220','CIS','Intro. to Microcomputing','3'); INSERT INTO COURSE VALUES('CIS-420','CIS','Database Design and Implementation','4'); INSERT INTO COURSE VALUES('QM-261','CIS','Intro. to Statistics','3'); INSERT INTO COURSE VALUES('QM-362','CIS','Statistical Applications','4'); CREATE TABLE ENROLL ( CLASS_CODE varchar(5), STU_NUM int, ENROLL_GRADE varchar(50) ) ENGINE = INNODB; INSERT INTO ENROLL VALUES('10014','321452','C'); INSERT INTO ENROLL VALUES('10014','324257','B'); INSERT INTO ENROLL VALUES('10018','321452','A'); INSERT INTO ENROLL VALUES('10018','324257','B'); INSERT INTO ENROLL VALUES('10021','321452','C'); INSERT INTO ENROLL VALUES('10021','324257','C'); CREATE TABLE STUDENT ( STU_NUM int, STU_LNAME varchar(15), STU_FNAME varchar(15), STU_INIT varchar(1), STU_DOB datetime, STU_HRS int, STU_CLASS varchar(2), STU_GPA numeric(4,2), STU_TRANSFER varchar(6), DEPT_CODE varchar(18), STU_PHONE varchar(4), PROF_NUM int ) ENGINE = INNODB; INSERT INTO STUDENT VALUES('321452','Bowser','William','C','1986-2-12','42','So','2.84','False','BIOL','2134','205'); INSERT INTO STUDENT VALUES('324257','Smithson','Anne','K','1991-11-15','81','Jr','3.27','True','CIS','2256','222'); INSERT INTO STUDENT VALUES('324258','Brewer','Juliette','','1980-8-23','36','So','2.26','True','ACCT','2256','228'); INSERT INTO STUDENT VALUES('324269','Oblonski','Walter','H','1987-9-16','66','Jr','3.09','False','CIS','2114','222'); INSERT INTO STUDENT VALUES('324273','Smith','John','D','1969-12-30','102','Sr','2.11','True','ENGL','2231','199'); INSERT INTO STUDENT VALUES('324274','Katinga','Raphael','P','1990-10-21','114','Sr','3.15','False','ACCT','2267','228');

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.