Here's what I have so far:

Write ALTER TABLE statements for each table to create Primary Keys and Foreign Keys where applicable.

Test the statements in your schema to make sure they work.

Save the ALTER TABLE statements to a text editor application such as NotePad (do not use Word!).

Take a screen shot of your schema in the Navigator window showing Foreign Keys for each table expanded. Upload the image in the Submit Database Design Exercise 2 area.

USE brownSchema;

CREATE TABLE CUSTOMER ( CUS_CODE int, CUS_LNAME varchar(15), CUS_FNAME varchar(15), CUS_INITIAL varchar(1), CUS_AREACODE varchar(3), CUS_PHONE varchar(8), CUS_BALANCE float(8), CONSTRAINT pk_cust_code primary key(CUS_CODE) );

INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0'); INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','0'); INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','345.86'); INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','536.75'); INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','0'); INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','0'); INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','221.19'); INSERT INTO CUSTOMER VALUES('10017','Williams','George','','615','290-2556','768.93'); INSERT INTO CUSTOMER VALUES('10018','Farriss','Anne','G','713','382-7185','216.55'); INSERT INTO CUSTOMER VALUES('10019','Smith','Olette','K','615','297-3809','0');

/* -- */ DROP TABLE IF EXISTS INVOICE; CREATE TABLE INVOICE ( INV_NUMBER int, CUS_CODE int, INV_DATE date, INV_SUBTOTAL float(8), INV_TAX float(8), INV_TOTAL float(8), CONSTRAINT pk_inv_num primary key(INV_NUMBER), CONSTRAINT fk_invoice FOREIGN KEY (CUS_CODE) REFERENCES CUSTOMER(CUS_CODE) );

INSERT INTO INVOICE VALUES('1001','10014','2016-01-16','24.90','1.99','26.89'); INSERT INTO INVOICE VALUES('1002','10011','2016-01-16','9.98','0.80','10.78'); INSERT INTO INVOICE VALUES('1003','10012','2016-01-16','153.85','12.31','166.16'); INSERT INTO INVOICE VALUES('1004','10011','2016-01-16','34.97','2.80','37.77'); INSERT INTO INVOICE VALUES('1005','10018','2016-01-16','70.44','5.64','76.08'); INSERT INTO INVOICE VALUES('1006','10014','2016-01-16','397.83','31.83','429.66'); INSERT INTO INVOICE VALUES('1007','10015','2016-01-16','34.97','2.80','37.77'); INSERT INTO INVOICE VALUES('1008','10011','2016-01-16','399.15','31.93','431.08');

/* -- */ DROP TABLE IF EXISTS LINE; CREATE TABLE LINE ( LINE_ID int, INV_NUMBER int, LINE_NUMBER int, P_CODE varchar(10), LINE_UNITS float(8), LINE_PRICE float(8), LINE_TOTAL float(8), CONSTRAINT pk_line_number primary key(LINE_ID, LINE_NUMBER), CONSTRAINT fk_a_line FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE(INV_NUMBER) );

INSERT INTO LINE VALUES('155','1001','1','13-Q2/P2','1','14.99','14.99'); INSERT INTO LINE VALUES('551','1001','2','23109-HB','1','9.95','9.95'); INSERT INTO LINE VALUES('674','1002','1','54778-2T','2','4.99','9.98'); INSERT INTO LINE VALUES('098','1003','1','2238/QPD','1','38.95','38.95'); INSERT INTO LINE VALUES('765','1003','2','1546-QQ2','1','39.95','39.95'); INSERT INTO LINE VALUES('123','1003','3','13-Q2/P2','5','14.99','74.95'); INSERT INTO LINE VALUES('321','1004','1','54778-2T','3','4.99','14.97'); INSERT INTO LINE VALUES('345','1004','2','23109-HB','2','9.95','19.90'); INSERT INTO LINE VALUES('678','1005','1','PVC23DRT','12','5.87','70.44'); INSERT INTO LINE VALUES('876','1006','1','SM-18277','3','6.99','20.97'); INSERT INTO LINE VALUES('594','1006','2','2232/QTY','1','109.92','109.92'); INSERT INTO LINE VALUES('856','1006','3','23109-HB','1','9.95','9.95'); INSERT INTO LINE VALUES('940','1006','4','89-WRE-Q','1','256.99','256.99'); INSERT INTO LINE VALUES('654','1007','1','13-Q2/P2','2','14.99','29.98'); INSERT INTO LINE VALUES('987','1007','2','54778-2T','1','4.99','4.99'); INSERT INTO LINE VALUES('965','1008','1','PVC23DRT','5','5.87','29.35'); INSERT INTO LINE VALUES('030','1008','2','WR3/TT3','3','119.95','359.85'); INSERT INTO LINE VALUES('521','1008','3','23109-HB','1','9.95','9.95'); /* -- */ DROP TABLE IF EXISTS PRODUCT; CREATE TABLE PRODUCT ( P_CODE varchar(10), P_DESCRIPT varchar(35), P_INDATE date, P_QOH int, P_MIN int, P_PRICE float(8), P_DISCOUNT float(8), V_CODE int, CONSTRAINT pk_p_code primary key(P_CODE), CONSTRAINT fk_product FOREIGN KEY (V_CODE) REFERENCES VENDOR(V_CODE), CONSTRAINT fk__b_line FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE) );

INSERT INTO PRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle','2015-11-03','8','5','109.99','0','25595'); INSERT INTO PRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade','2015-12-13','32','15','14.99','0.05','0'); INSERT INTO PRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade','2015-11-13','18','12','17.49','0','21344'); INSERT INTO PRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50','2016-01-15','15','8','39.95','0','23119'); INSERT INTO PRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50','2016-01-15','23','5','43.99','0','23119'); INSERT INTO PRODUCT VALUES('2232/QTY','B&D jigsaw, 12-in. blade','2015-12-30','8','5','109.92','0.05','24288'); INSERT INTO PRODUCT VALUES('2232/QWE','B&D jigsaw, 8-in. blade','2015-12-24','6','5','99.87','0.05','24288'); INSERT INTO PRODUCT VALUES('2238/QPD','B&D cordless drill, 1/2-in.','2016-01-20','12','5','38.95','0.05','25595'); INSERT INTO PRODUCT VALUES('23109-HB','Claw hammer','2016-01-12','23','10','9.95','0.1','21225'); INSERT INTO PRODUCT VALUES('23114-AA','Sledge hammer 12 lb.','2016-01-2','8','5','14.40','0.05','0'); INSERT INTO PRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine','2015-12-15','43','20','4.99','0','21344'); INSERT INTO PRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.','2016-02-17','11','5','256.99','0.05','24288'); INSERT INTO PRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft','2016-02-27','188','75','5.87','0','24004'); INSERT INTO PRODUCT VALUES('SM-18277','metal screw 1.25-in., 25','2016-03-01','172','75','6.99','0','21225'); INSERT INTO PRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50','2016-02-14','237','100','8.45','0','21231'); INSERT INTO PRODUCT VALUES('WR3/TT3','Steel matting, 4''x8''x1/6", .5" mesh','2016-01-27','18','5','119.95','0.1','25595');

/* -- */

DROP TABLE IF EXISTS VENDOR; CREATE TABLE VENDOR ( V_CODE int, V_NAME varchar(15), V_CONTACT varchar(50), V_AREACODE varchar(3), V_PHONE varchar(8), V_STATE varchar(2), V_ORDER varchar(1), CONSTRAINT pk_v_code primary key(V_CODE) );

INSERT INTO VENDOR VALUES('21225','Bryson, Inc.','Smithson','615','223-3234','TN','Y'); INSERT INTO VENDOR VALUES('21226','SuperLoo, Inc.','Flushing','904','215-8995','FL','N'); INSERT INTO VENDOR VALUES('21231','D&E Supply','Singh','615','228-3245','TN','Y'); INSERT INTO VENDOR VALUES('21344','Gomez Bros.','Ortega','615','889-2546','KY','N'); INSERT INTO VENDOR VALUES('22567','Dome Supply','Smith','901','678-1419','GA','N'); INSERT INTO VENDOR VALUES('23119','Randsets Ltd.','Anderson','901','678-3998','GA','Y'); INSERT INTO VENDOR VALUES('24004','Brackman Bros.','Browning','615','228-1410','TN','N'); INSERT INTO VENDOR VALUES('24288','ORDVA, Inc.','Hakford','615','898-1234','TN','Y'); INSERT INTO VENDOR VALUES('25443','B&K, Inc.','Smith','904','227-0093','FL','N'); INSERT INTO VENDOR VALUES('25501','Damal Supplies','Smythe','615','890-3529','TN','N'); INSERT INTO VENDOR VALUES('23200','Rubicon Systems','Orton','904','456-0092','FL','Y');