INSERT INTO ELEVE VALUES ('','Giansetto','Nicolas','IG2');
INSERT INTO ELEVE VALUES ('','Lemma','JB','IG2');
INSERT INTO ELEVE VALUES ('','Marin','JC','IG2');
INSERT INTO ELEVE VALUES ('','Meyere','Laurent','IG2');
INSERT INTO ELEVE VALUES ('','Tabouret','David','IG2');
INSERT INTO ELEVE VALUES ('','Taret','Magalie','IG2');
INSERT INTO ELEVE VALUES ('','Romain','Ludovic','IG2');
INSERT INTO ELEVE VALUES ('','Slaoui','Taha','IG2');
INSERT INTO ELEVE VALUES ('','Ortega','Guillaume','IG1');
INSERT INTO ELEVE VALUES ('','Loury','Renaud','IG1');

INSERT INTO PROF VALUES ('','a','a','a');
INSERT INTO PROF VALUES ('','Thomassin','Gilles','secret');
INSERT INTO PROF VALUES ('','Sotoca','Rodolphe','secret');
INSERT INTO PROF VALUES ('','Bourges','Claude','secret');

INSERT INTO MATIERE VALUES ('','S1',2);
INSERT INTO MATIERE VALUES ('','S2',3);
INSERT INTO MATIERE VALUES ('','S3-Analyse',2);
INSERT INTO MATIERE VALUES ('','S3-Programmation',1);
INSERT INTO MATIERE VALUES ('','S4',3);