drop table if exists maitriser,programme,biologiste;
create table biologiste(bid int primary key auto_increment,bnom varchar(50),grade varchar(50),institut varchar(30));
create table programme(pid int primary key auto_increment,pnom varchar(30),societe varchar(50),prix_licence int);
create table maitriser(mid int primary key auto_increment,bid int,pid int, niveau int,foreign key(bid) references biologiste(bid),foreign key (pid) references programme(pid));
insert into biologiste(bnom,grade,institut) values('McBlobby','IE','INRA'),('Choco','AI','CNRS'),('Sinock','POSTDOC','CNRS'),('Captain Flam','IR','INSERM'),('Candy','UDA','MDC'),('Princesse Sarah','IE','INRA');
insert into programme(pnom,societe,prix_licence) values('PERL_A_MA_MAIN','BlobbyCorp',150),('PEUT_CHE_PEUT','BlobbyCorp',80),('BAY_DAY_DAY','BlobbyCorp',90),('MegaProg','MegaProg',250);
insert into maitriser(bid,pid,niveau) values (1,1,16),(1,2,15),(1,3,13),(2,1,11),(2,2,13),(3,2,9),(4,3,17),(5,1,8),(3,1,14),(4,1,12),(6,1,13),(6,3,12),(6,2,11);