INSERT INTO S ( S#, SNAME, STATUS, CITY ) VALUES ( 
'S1', 'Smith', 20, 'London'); 
INSERT INTO S ( S#, SNAME, STATUS, CITY ) VALUES ( 
'S2', 'Jones', 10, 'Paris'); 
INSERT INTO S ( S#, SNAME, STATUS, CITY ) VALUES ( 
'S3', 'Blake', 30, 'Paris'); 
INSERT INTO S ( S#, SNAME, STATUS, CITY ) VALUES ( 
'S4', 'Clark', 20, 'London'); 
INSERT INTO S ( S#, SNAME, STATUS, CITY ) VALUES ( 
'S5', 'Adams', 30, 'Athens'); 
commit;
 
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P1', 'Nut', 'Red', 12, 'London');
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P2', 'Bolt', 'Green', 17, 'Paris');
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P3', 'Screw', 'Blue', 17, 'Rome');
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P4', 'Screw', 'Red', 17, 'London');
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P5', 'Cam', 'Blue', 12, 'Paris');
INSERT INTO P (P#, PNAME, COLOR, WEIGHT, CITY) VALUES (
'P6', 'Cog', 'Red' ,19, 'London');
commit;

INSERT INTO j (J#, JNAME, CITY) VALUES (
'J1', 'Sorter', 'Paris');
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J2', 'Punch', 'Rome');
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J3', 'Reader', 'Athens');
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J4', 'Console', 'Athens');
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J5', 'Collator', 'London');
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J6', 'Terminal', 'Oslo'); 
INSERT INTO j (J#, JNAME, CITY) VALUES (
'J7', 'Tape', 'London');
commit;

INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S1', 'P1', 'J1', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S1', 'P1', 'J4', 700);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J1', 400);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J2', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J3', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J4', 500);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J5', 600);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J6', 400);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P3', 'J7', 800);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S2', 'P5', 'J2', 100);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S3', 'P3', 'J1', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S3', 'P4', 'J2', 500);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S4', 'P6', 'J3', 300);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S4', 'P6', 'J7', 300);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P2', 'J2', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P2', 'J4', 100);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P5', 'J5', 500);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P5', 'J7', 100);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P6', 'J2', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P1', 'J4', 100);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P3', 'J4', 200);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P4', 'J4', 800);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P5', 'J4', 400);
INSERT INTO SPJ (S#, P#, J#, QTY) VALUES (
'S5', 'P6', 'J4', 500);
commit;
