CREATE TABLE S (
  S text PRIMARY KEY CHECK (SUBSTR(S,1,1)='S')
, SNAME text
, STATUS integer
, CITY text
);
INSERT INTO "S" VALUES('S1','Smith',20,'London');
INSERT INTO "S" VALUES('S2','Jones',10,'Paris');
INSERT INTO "S" VALUES('S3','Blake',30,'Paris');
INSERT INTO "S" VALUES('S4','Clark',20,'London');
INSERT INTO "S" VALUES('S5','Adams',30,'Athens');
CREATE TABLE P (
  P text PRIMARY KEY CHECK (SUBSTR(P,1,1)='P')
, PNAME text, COLOR text
, WEIGHT real
, CITY text
);
INSERT INTO "P" VALUES('P1','Nut','Red',12.0,'London');
INSERT INTO "P" VALUES('P2','Bolt','Green',17.0,'Paris');
INSERT INTO "P" VALUES('P3','Screw','Blue',17.0,'Oslo');
INSERT INTO "P" VALUES('P4','Screw','Red',14.0,'London');
INSERT INTO "P" VALUES('P5','Cam','Blue',12.0,'Paris');
INSERT INTO "P" VALUES('P6','Cog','Red',19.0,'London');
CREATE TABLE J (
  J text PRIMARY KEY CHECK (SUBSTR(J,1,1)='J')
, JNAME text
, CITY text
);
INSERT INTO "J" VALUES('J1','Sorter','Paris');
INSERT INTO "J" VALUES('J2','Display','Rome');
INSERT INTO "J" VALUES('J3','OCR','Athens');
INSERT INTO "J" VALUES('J4','Console','Athens');
INSERT INTO "J" VALUES('J5','RAID','London');
INSERT INTO "J" VALUES('J6','EDS','Oslo');
INSERT INTO "J" VALUES('J7','Tape','London');
CREATE TABLE SPJ 	(
 S text, 
 P text, 
 J text,
 QTY integer, 
 CONSTRAINT SP_S FOREIGN KEY(S) REFERENCES S(S) ON DELETE CASCADE ON UPDATE CASCADE,
 CONSTRAINT SP_P FOREIGN KEY(P) REFERENCES P(P) ON DELETE CASCADE ON UPDATE CASCADE,
 CONSTRAINT SP_J FOREIGN KEY(J) REFERENCES J(J) ON DELETE CASCADE ON UPDATE CASCADE
);
INSERT INTO "SPJ" VALUES('S1','P1','J1',200);
INSERT INTO "SPJ" VALUES('S1','P1','J4',700);
INSERT INTO "SPJ" VALUES('S2','P3','J1',400);
INSERT INTO "SPJ" VALUES('S2','P3','J2',200);
INSERT INTO "SPJ" VALUES('S2','P3','J3',200);
INSERT INTO "SPJ" VALUES('S2','P3','J4',500);
INSERT INTO "SPJ" VALUES('S2','P3','J5',600);
INSERT INTO "SPJ" VALUES('S2','P3','J6',400);
INSERT INTO "SPJ" VALUES('S2','P3','J7',800);
INSERT INTO "SPJ" VALUES('S2','P5','J2',100);
INSERT INTO "SPJ" VALUES('S3','P3','J1',200);
INSERT INTO "SPJ" VALUES('S3','P4','J2',500);
INSERT INTO "SPJ" VALUES('S4','P6','J3',300);
INSERT INTO "SPJ" VALUES('S4','P6','J7',300);
INSERT INTO "SPJ" VALUES('S5','P2','J2',200);
INSERT INTO "SPJ" VALUES('S5','P2','J4',100);
INSERT INTO "SPJ" VALUES('S5','P5','J5',500);
INSERT INTO "SPJ" VALUES('S5','P5','J7',100);
INSERT INTO "SPJ" VALUES('S5','P6','J2',200);
INSERT INTO "SPJ" VALUES('S5','P1','J4',100);
INSERT INTO "SPJ" VALUES('S5','P3','J4',200);
INSERT INTO "SPJ" VALUES('S5','P4','J4',800);
INSERT INTO "SPJ" VALUES('S5','P5','J4',400);
INSERT INTO "SPJ" VALUES('S5','P6','J4',500);