tp1.sql
CREATE TABLE Intervenants(
  numIntervention INTEGER,
  numEmploye      INTEGER,
  dateDebut       DATE,
  dateFin         DATE,
  CONSTRAINT PK_Intervenants
    PRIMARY KEY (numIntervention, numEmploye),
  CONSTRAINT FK_Intervenants
    FOREIGN KEY (numIntervention)
    REFERENCES Interventions (numIntervention)
      ON DELETE CASCADE,
  CONSTRAINT FK_Intervenant FOREIGN KEY (numEmploye)
    REFERENCES Employe (numEmploye)
      ON DELETE CASCADE
);