create table projet(
codeP varchar(4) constraint pk_projet primary key,
nomP varchar(15) not null)

create table participation(
matr integer constraint fk_emp_part references emp,
codeP varchar(4) constraint fk_projet_part references projet,
constraint pk_part primary key (matr, codeP))