/* Liste d'élèves */

INSERT INTO eleve values (1,'Dos','Hugo',to_date('05/11/1993','DD/MM/YYYY'));
INSERT INTO eleve values (2,'Tyndal','Pierre-Alexandre',to_date('27/06/1993','DD/MM/YYYY'));
INSERT INTO eleve values (3,'Ingouff','Christian',to_date('28/04/1993','DD/MM/YYYY'));
INSERT INTO eleve values (4,'Simpson','Bart',to_date('7/04/1993','DD/MM/YYYY'));
INSERT INTO eleve values (5,'Simpson','Maggie',to_date('23/09/1996','DD/MM/YYYY'));
INSERT INTO eleve values (6,'Monkey D.','Luffy',to_date('28/04/1992','DD/MM/YYYY'));
INSERT INTO eleve values (7,'Uzumaki','Naruto',to_date('25/12/1993','DD/MM/YYYY'));
INSERT INTO eleve values (8,'Uchiha','Sasuke',to_date('3/02/1993','DD/MM/YYYY'));
INSERT INTO eleve values (9,'Uchiha','Itachi',to_date('20/04/1991','DD/MM/YYYY'));
INSERT INTO eleve values (10,'San','Gohan',to_date('17/06/1990','DD/MM/YYYY'));
INSERT INTO eleve values (11,'Elric','Edward',to_date('17/10/1994','DD/MM/YYYY'));
INSERT INTO eleve values (12,'Elric','Alphonse',to_date('22/11/1995','DD/MM/YYYY'));
INSERT INTO eleve values (13,'Van Damme','Jean-Claude',to_date('2/02/0002','DD/MM/YYYY'));
INSERT INTO eleve values (14,'Kurosaki','Ichigo',to_date('11/11/1992','DD/MM/YYYY'));
INSERT INTO eleve values (15,'San','Goten',to_date('14/07/1995','DD/MM/YYYY'));

/* Programmes */

INSERT INTO Programme values (1, 'CPI 1');
INSERT INTO Programme values (2, 'CPI 2');
INSERT INTO Programme values (3, 'ING 1');
INSERT INTO Programme values (4, 'ING 2');
INSERT INTO Programme values (5, 'ING 3');

/* Modules et activités */

INSERT INTO Module values (1, 'Mathématiques', 1);
INSERT INTO Activite values (1,'DS',1);
INSERT INTO Activite values (2,'DM',1);
INSERT INTO Activite values (3,'TD',1);

INSERT INTO Module values (2, 'Mathématiques', 2);
INSERT INTO Activite values (4,'DS',2);
INSERT INTO Activite values (5,'DM',2);
INSERT INTO Activite values (6,'TD',2);

INSERT INTO Module values (3, 'Mathématiques', 3);
INSERT INTO Activite values (7,'DS',3);
INSERT INTO Activite values (8,'DM',3);
INSERT INTO Activite values (9,'TD',3);

INSERT INTO Module values (4, 'Informatique', 4);
INSERT INTO Activite values (10,'DS',4);
INSERT INTO Activite values (11,'TD',4);
INSERT INTO Activite values (12,'Projet',4);

INSERT INTO Module values (5, 'Informatique', 5);
INSERT INTO Activite values (13,'DS',5);
INSERT INTO Activite values (14,'TD',5);
INSERT INTO Activite values (15,'Projet',5);

INSERT INTO Module values (6, 'Langues', 3);
INSERT INTO Activite values (16,'DS',6);
INSERT INTO Activite values (17,'Presentation orale',6);

INSERT INTO Module values (7, 'Sport', 3);
INSERT INTO Activite values (18,'Competition',7);

INSERT INTO Module values (8, 'Transverse', 3);
INSERT INTO Activite values (19,'Ninjutsu',8);

/* Structure scolaire/questionnaires */

INSERT INTO Questionnaire values (1, 'Test Catégorisation', to_date('12/04/2012','DD/MM/YYYY'));
INSERT INTO Categorisation values (1, 1);

INSERT INTO Question values (1,'Il est samedi soir. Que faites vous ?','fermée unique',1);
INSERT INTO Reponse values (1,'Je reste chez moi',1);
INSERT INTO Reponse values (2,'Je sors pour faire des activités',1);
INSERT INTO Reponse values (3,'Je travaille',1);

INSERT INTO Question values (2,'Quel genres de jeux vidéo preferez-vous ?','fermée unique',1);
INSERT INTO Reponse values (4,'Sport (foot, course...)',2);
INSERT INTO Reponse values (5,'Stategie(RTS, MOBA, FPS ...)',2);
INSERT INTO Reponse values (6,'Simulation (creation, rythme)',2);
INSERT INTO Reponse values (7,'Je ne joue pas',2);

INSERT INTO Question values (3,'Quel genre de musique preferez-vous ?','fermée unique',1);
INSERT INTO Reponse values (8,'Rock/Metal',3);
INSERT INTO Reponse values (9,'Classique/Jazz',3);
INSERT INTO Reponse values (10,'Electro',3);
INSERT INTO Reponse values (11,'Pop/R''nB',3);

INSERT INTO Question values (4,'A l''EISTI, vous preferez...','fermée unique',1);
INSERT INTO Reponse values (12,'L''informatique',4);
INSERT INTO Reponse values (13,'Les mathématiques',4);
INSERT INTO Reponse values (14,'La vie etudiante',4);
INSERT INTO Reponse values (15,'Les relations humaines',4);

INSERT INTO Question values (5,'A quelle fréquence faites-vous du sport ?','fermée unique',1);
INSERT INTO Reponse values (16,'Jamais',5);
INSERT INTO Reponse values (17,'Une fois de temps en temps',5);
INSERT INTO Reponse values (18,'Une fois par semaine',5);
INSERT INTO Reponse values (19,'Davantage',5);

INSERT INTO Questionnaire values (2, 'Test Evaluation', DEFAULT);
INSERT INTO Evaluation values (1, 2, 8);

INSERT INTO Question values (6,'Comment trouvez-vous les cours d''informatique ?','fermée unique',2);
INSERT INTO Reponse values (20,'Super',6);
INSERT INTO Reponse values (21,'Tres Bien',6);
INSERT INTO Reponse values (22,'Bien',6);
INSERT INTO Reponse values (23,'Assez Bien',6);
INSERT INTO Reponse values (24,'Nul',6);

INSERT INTO Question values (7,'Comment trouvez-vous les cours en général ?','fermée unique',2);
INSERT INTO Reponse values (25,'Super',7);
INSERT INTO Reponse values (26,'Tres Bien',7);
INSERT INTO Reponse values (27,'Bien',7);
INSERT INTO Reponse values (28,'Assez Bien',7);
INSERT INTO Reponse values (29,'Nul',7);

INSERT INTO Question values (8,'Comment trouvez-vous les professeurs en général ?','fermée unique',2);
INSERT INTO Reponse values (30,'Super',8);
INSERT INTO Reponse values (31,'Tres Bien',8);
INSERT INTO Reponse values (32,'Bien',8);
INSERT INTO Reponse values (33,'Assez Bien',8);
INSERT INTO Reponse values (34,'Nul',8);

INSERT INTO Question values (9,'Comment trouvez-vous le personnel de l''administration ?','fermée unique',2);
INSERT INTO Reponse values (35,'Super',9);
INSERT INTO Reponse values (36,'Tres Bien',9);
INSERT INTO Reponse values (37,'Bien',9);
INSERT INTO Reponse values (38,'Assez Bien',9);
INSERT INTO Reponse values (39,'Nul',9);

INSERT INTO Question values (10,'Comment trouvez-vous les cours de mathématiques ?','fermée unique',2);
INSERT INTO Reponse values (40,'Super',10);
INSERT INTO Reponse values (41,'Tres Bien',10);
INSERT INTO Reponse values (42,'Bien',10);
INSERT INTO Reponse values (43,'Assez Bien',10);
INSERT INTO Reponse values (44,'Nul',10);

INSERT INTO Question values (16, 'Est-ce que vous avez d''autres remarques ?', 'ouverte',2);

INSERT INTO Questionnaire values (3, 'Test QCM', to_date('24/11/2011','DD/MM/YYYY'));
INSERT INTO QCM values (1, 3, 19);

INSERT INTO Question values (11,'Qui est le directeur de l''EISTI ?','fermée multiple',3);
INSERT INTO Reponse values (45,'Nesim Fintz',11);
INSERT INTO Reponse values (46,'Mickael Vendetta',11);
INSERT INTO Reponse values (47,'Chuck Norris',11);
INSERT INTO Reponse values (48,'Houcine Senoussi',11);

INSERT INTO Question values (12,'L''ensemble des réels est inclus dans :','fermée multiple',3);
INSERT INTO Reponse values (49,'L''ensemble matriciel',12);
INSERT INTO Reponse values (50,'L''ensemble des complexes',12);
INSERT INTO Reponse values (51,'L''ensemble des entiers',12);

INSERT INTO Question values (13,'L''élève de l''EISTI est :','fermée multiple',3);
INSERT INTO Reponse values (52,'Un singe',13);
INSERT INTO Reponse values (53,'Chuck Norris',13);
INSERT INTO Reponse values (54,'eistien',13);
INSERT INTO Reponse values (55,'ingenieur',13);
INSERT INTO Reponse values (56,'etudiant',13);

INSERT INTO Question values (14,'Quel âge a l''EISTI ?','fermée multiple',3);
INSERT INTO Reponse values (57,'15 ans',14);
INSERT INTO Reponse values (58,'30 ans',14);
INSERT INTO Reponse values (59,'45 ans',14);
INSERT INTO Reponse values (60,'50 ans',14);
INSERT INTO Reponse values (61,'100 ans',14);

INSERT INTO Question values (15,'EISTI signifie :','fermée multiple',3);
INSERT INTO Reponse values (62,'Ecole Informatique des Sciences et Techniques de l''Information ',15);
INSERT INTO Reponse values (63,'Ecole International des Sciences et Technologies de l''Information',15);
INSERT INTO Reponse values (64,'Ecole International des Sciences et Techniques de l''Information',15);
INSERT INTO Reponse values (65,'Ecole Informatiques des Sciences et Technologies de l''Information',15);
INSERT INTO Reponse values (66,'Aucune proposition',15);

/* Jeux d'essais : réponses des étudiants */

INSERT INTO Session_ values (1, to_date('01/02/2013','DD/MM/YYYY'), 1, 1);
INSERT INTO rep_valider values (1,1);
INSERT INTO rep_valider values (1,4);
INSERT INTO rep_valider values (1,8);
INSERT INTO rep_valider values (1,12);
INSERT INTO rep_valider values (1,16);

INSERT INTO Session_ values (2, to_date('02/02/2013','DD/MM/YYYY'), 2, 1);
INSERT INTO rep_valider values (2,2);
INSERT INTO rep_valider values (2,5);
INSERT INTO rep_valider values (2,9);
INSERT INTO rep_valider values (2,13);
INSERT INTO rep_valider values (2,17);

INSERT INTO Session_ values (3, to_date('03/03/2013','DD/MM/YYYY'), 3, 1);
INSERT INTO rep_valider values (3,3);
INSERT INTO rep_valider values (3,6);
INSERT INTO rep_valider values (3,10);
INSERT INTO rep_valider values (3,14);
INSERT INTO rep_valider values (3,18);

INSERT INTO Session_ values (4, DEFAULT, 4, 2);
INSERT INTO rep_valider values (4,20);
INSERT INTO rep_valider values (4,25);
INSERT INTO rep_valider values (4,30);
INSERT INTO rep_valider values (4,35);
INSERT INTO rep_valider values (4,40);
INSERT INTO Reponse values (67,'Aucune',16);
INSERT INTO rep_valider values (4,67);

INSERT INTO Session_ values (5, DEFAULT, 5, 2);
INSERT INTO rep_valider values (5,21);
INSERT INTO rep_valider values (5,26);
INSERT INTO rep_valider values (5,31);
INSERT INTO rep_valider values (5,36);
INSERT INTO rep_valider values (5,41);
INSERT INTO Reponse values (68,'Elle est où ma sucette ?',16);
INSERT INTO rep_valider values (5,68);

INSERT INTO Session_ values (6, DEFAULT, 2, 2);
INSERT INTO rep_valider values (6,22);
INSERT INTO rep_valider values (6,27);
INSERT INTO rep_valider values (6,32);
INSERT INTO rep_valider values (6,37);
INSERT INTO rep_valider values (6,42);
INSERT INTO Reponse values (69,'J''ai envie de dormir',16);
INSERT INTO rep_valider values (6,69);

INSERT INTO Session_ values (7, DEFAULT, 6, 3);
INSERT INTO rep_valider values (7,45);
INSERT INTO rep_valider values (7,49);
INSERT INTO rep_valider values (7,52);
INSERT INTO rep_valider values (7,54);
INSERT INTO rep_valider values (7,58);
INSERT INTO rep_valider values (7,64);

INSERT INTO Session_ values (8, DEFAULT, 3, 3);
INSERT INTO rep_valider values (8,46);
INSERT INTO rep_valider values (8,48);
INSERT INTO rep_valider values (8,54);
INSERT INTO rep_valider values (8,61);
INSERT INTO rep_valider values (8,63);

INSERT INTO Session_ values (9, DEFAULT, 13, 3);
INSERT INTO rep_valider values (9,45);
INSERT INTO rep_valider values (9,46);
INSERT INTO rep_valider values (9,47);
INSERT INTO rep_valider values (9,49);
INSERT INTO rep_valider values (9,52);
INSERT INTO rep_valider values (9,53);
INSERT INTO rep_valider values (9,56);
INSERT INTO rep_valider values (9,57);
INSERT INTO rep_valider values (9,59);
INSERT INTO rep_valider values (9,60);
INSERT INTO rep_valider values (9,62);
INSERT INTO rep_valider values (9,64);
INSERT INTO rep_valider values (9,65);
