drop table suppliers; 
create table suppliers (sid integer, sname varchar(30), address varchar(50)); 
insert into suppliers values (1,'Acme Widget Suppliers','1 Grub St., Potemkin Village, IL 61801'); 
insert into suppliers values (2,'Big Red Tool and Die','4 My Way, Bermuda Shorts, OR 90305'); 
insert into suppliers values (3,'Perfunctory Parts','99999 Short Pier, Terra Del Fuego, TX 41299'); 
insert into suppliers values (4,'Alien Aircaft Inc.','2 Groom Lake, Rachel, NV 51902'); 
insert into suppliers values (5, 'Nobody Special, Inc.','Nowhere in particular');

drop table parts;
create table parts (pid integer, pname varchar(40), color varchar(14)); 
insert into parts values (1,'Left Handed Bacon Stretcher Cover','Red');
insert into parts values (2,'Smoke Shifter End','Black');
insert into parts values (3,'Acme Widget Washer','Red');
insert into parts values (4,'Acme Widget Washer','Silver');
insert into parts values (5,'I Brake for Crop Circles Sticker','Translucent');
insert into parts values (6,'Anti-Gravity Turbine Generator','Cyan');
insert into parts values (7,'Anti-Gravity Turbine Generator','Magenta');
insert into parts values (8,'Fire Hydrant Cap','Red');
insert into parts values (9,'7 Segment Display','Green');

drop table catalog;
create table catalog (sid integer, pid integer, cost float); 
insert into catalog values (1,3,0.50);
insert into catalog values (1,4,0.50);
insert into catalog values (1,8,11.70);
insert into catalog values (2,3,0.55);
insert into catalog values (2,8,7.95);
insert into catalog values (2,1,16.50);
insert into catalog values (3,8,12.50);
insert into catalog values (3,9,1.00);
insert into catalog values (4,5,2.20);
insert into catalog values (4,6,1247548.23);
insert into catalog values (4,7,1247548.23);
\q