SQL DDL

CREATE TABLE zespoly (
  nrz INT(5) AUTO_INCREMENT,
  nazwa VARCHAR(20) NOT NULL,
  nrpk INT(5),
  PRIMARY KEY (nrz)
);

CREATE TABLE pracownicy (
  nrp INT(5) AUTO_INCREMENT,
  nazwisko VARCHAR(20) NOT NULL,
  nrz INT(5),
  PRIMARY KEY (nrp),
  FOREIGN KEY (nrz) REFERENCES zespoly (nrz) ON DELETE SET NULL
);

CREATE TABLE tematy (
  nrt INT(5) AUTO_INCREMENT,
  nazwa VARCHAR(30),
  nrpk INT(5),
  PRIMARY KEY (nrt)
);

CREATE TABLE wyplaty (
  nrp INT(5) REFERENCES pracownicy (nrp),
  nrt INT(5) REFERENCES tematy (nrt) ON DELETE CASCADE,
  kwota DEC(8, 2),
  PRIMARY KEY (nrp, nrt)
);