drop table s;
drop table p;
drop table sp;

create table S
(s#	char(4)	not null,
sname	char(10),
city	char(10),
primary key(s#));

create table P
(p#	char(4)	not null,
pname	char(10),
color	char(10),
primary key(p#));

create table SP
(s#	char(4)	not null,
p# char (4) not null,
qty integer,
primary key(s#,p#));


INSERT INTO S VALUES ('S1', 'SMITH', 'LONDON');
INSERT INTO S VALUES ('S2', 'JONES', 'PARIS');
INSERT INTO S VALUES ('S3', 'ADAMS', 'ATHENS');
INSERT INTO S VALUES ('S4', 'LEE', 'PARIS');

INSERT INTO P VALUES ('P1', 'NUT', 'RED');
INSERT INTO P VALUES ('P2', 'BOLT', 'BLUE');
INSERT INTO P VALUES ('P3', 'SCREW', 'RED');
INSERT INTO P VALUES ('P4', 'SCREW', 'BLACK');

INSERT INTO SP VALUES ('S1', 'P1', 100);
INSERT INTO SP VALUES ('S2', 'P1', 100);
INSERT INTO SP VALUES ('S2', 'P2', 300);
INSERT INTO SP VALUES ('S3', 'P3', 100);
INSERT INTO SP VALUES ('S4', 'P4', 300);