drop table PARTS;
create table PARTS (
  PNO varchar(50), 
  PNAME varchar(50), 
  COLOR varchar(50), 
  CITY varchar(50));

insert into PARTS values 
('P1', 'Nut', 'Red', 'Duluth');
insert into PARTS values 
('P2', 'Bolt', 'Blue', 'Marietta');
insert into PARTS values 
('P3', 'Screw', 'Red', 'Dunwoody');
insert into PARTS values 
('P4', 'Axle', 'Green', 'Marietta');

drop table SPJ;
create table SPJ (
  SNO varchar(50), 
  PNO varchar(50), 
  JNO varchar(50), 
  QTY integer);

insert into SPJ values 
('S1', 'P1', 'J1', 100);
insert into SPJ values 
('S1', 'P2', 'J2', 100);
insert into SPJ values 
('S1', 'P1', 'J2', 100);
insert into SPJ values 
('S2', 'P1', 'J1', 100);
insert into SPJ values 
('S2', 'P3', 'J1', 100);
insert into SPJ values 
('S2', 'P3', 'J2', 100);
insert into SPJ values 
('S3', 'P1', 'J1', 100);
insert into SPJ values 
('S3', 'P2', 'J2', 100);

drop table SUPPLIERS;
create table SUPPLIERS (
  SNO varchar(50), 
  SNAME varchar(50), 
  CITY varchar(50));

insert into SUPPLIERS values 
('S1', 'Jones', 'Atlanta');
insert into SUPPLIERS values 
('S2', 'Smith', 'Duluth');
insert into SUPPLIERS values 
('S3', 'Blake', 'Marietta');

drop table PROJECTS;
create table PROJECTS (
  JNO varchar(50), 
  JNAME varchar(50), 
  CITY varchar(50));

insert into PROJECTS values 
('J1', 'Bicycles', 'Duluth');
insert into PROJECTS values 
('J2', 'Motorcycles', 'Dunwoody');

