CREATE TABLE S
  ( SNo       CHAR(4),
    SName     VARCHAR(20),
    Status    INT,
    City      VARCHAR(15),
    PRIMARY KEY (SNo) );

CREATE TABLE P
  ( PNo       CHAR(4),
    PName     VARCHAR(20),
    Color     VARCHAR(10),
    Weight    FLOAT,
    City      VARCHAR(15),
    PRIMARY KEY (PNo) );

CREATE TABLE J
  ( JNo       CHAR(4),
    JName     VARCHAR(20),
    City      VARCHAR(15),
    PRIMARY KEY (JNo) );

CREATE TABLE SPJ
  ( SNo       CHAR(4),
    PNo       CHAR(4),
    JNo       CHAR(4),
    Qty       INT,
    PRIMARY KEY (SNo, PNo, JNo),
    FOREIGN KEY (SNo) REFERENCES S,
    FOREIGN KEY (PNo) REFERENCES P,
    FOREIGN KEY (JNo) REFERENCES J );

INSERT INTO S VALUES
  ('S1', 'Smith', 20, 'London'),
  ('S2', 'Jones', 10, 'Paris'),
  ('S3', 'Blake', 30, 'Paris'),
  ('S4', 'Clark', 20, 'London'),
  ('S5', 'Adams', 30, 'Athens');

INSERT INTO P VALUES
  ('P1', 'Nut', 'Red', 12.0, 'London'),
  ('P2', 'Bolt', 'Green', 17.0, 'Paris'),
  ('P3', 'Screw', 'Blue', 17.0, 'Oslo'),
  ('P4', 'Screw', 'Red', 14.0, 'London'),
  ('P5', 'Cam', 'Blue', 12.0, 'Paris'),
  ('P6', 'Cog', 'Red', 19.0, 'London');

INSERT INTO J VALUES
  ('J1', 'Sorter', 'Paris'),
  ('J2', 'Display', 'Rome'),
  ('J3', 'OCR', 'Athens'),
  ('J4', 'Console', 'Athens'),
  ('J5', 'RAID', 'London'),
  ('J6', 'EDS', 'Oslo'),
  ('J7', 'Tape', 'London');

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