PR3_P1_EJ1a

ALTER TABLE TRABAJA_EN
ADD CONSTRAINT FK_emp FOREIGN KEY (TipoE, NroE)
    REFERENCES EMPLEADO (TipoE, NroE)
    ON UPDATE RESTRICT
    ON DELETE CASCADE
ADD CONSTRAINT FK_pro FOREIGN KEY (IdProy)
    REFERENCES PROYECTO (IdProy)
    ON UPDATE CASCADE
    ON DELETE RESTRICT}



ALTER TABLE AUSPICIO
ADD CONSTRAINT FK_emp FOREIGN KEY (TipoE, NroE)
    REFERENCES EMPLEADO (TipoE, NroE)
    ON UPDATE RESTRICT
    ON DELETE SET NULL
ADD CONSTRAINT FK_pro FOREIGN KEY (IdProy)
    REFERENCES PROYECTO (IdProy)
    ON UPDATE RESTRICT
    ON DELETE RESTRICT