CREATE TABLE samochod (
  nr_rejestracyjny VARCHAR(8) NOT NULL,
  id_model NUMBER NOT NULL,
  id_klient NUMBER NOT NULL,
  id_producent NUMBER NOT NULL,
  przebieg NUMBER(6),
  pojemnosc NUMBER(4),
  CONSTRAINT pk_samochod
    PRIMARY KEY(nr_rejestracyjny, id_model, id_klient, id_producent),
  CONSTRAINT fk_klient
    FOREIGN KEY (id_klient)
    REFERENCES klient(id_klient),
    ON DELETE CASCADE,
  CONSTRAINT fk_model
  FOREIGN KEY (id_model, id_producent)
    REFERENCES model(id_model, id_producent)
    ON DELETE CASCADE
);