-- V1.1.0

PROMPT "Création de la base de données Questionnaire";

-- **************************************************************************** Définition des données

PROMPT "Définition des données";

DROP TABLE Evaluation CASCADE CONSTRAINTS;
DROP TABLE ThemQuest CASCADE CONSTRAINTS;
DROP TABLE Theme CASCADE CONSTRAINTS;
DROP TABLE Question CASCADE CONSTRAINTS;
DROP TABLE Etudiant CASCADE CONSTRAINTS;

CREATE TABLE Etudiant (
	numEt NUMBER(6, 0), 
	nom VARCHAR2(20) NOT NULL, 
	prenom VARCHAR2(15) NOT NULL, 
	typeBac VARCHAR2(15) NOT NULL,
	groupe NUMBER(1, 0) NOT NULL, 
	CONSTRAINT pk_Etudiant PRIMARY KEY (numEt),
	CONSTRAINT uk_Etudiant_01 UNIQUE (nom, prenom),
	CONSTRAINT ch_Etudiant_typeBac CHECK (typeBac IN ('GENERAL', 'TECHNOLOGIQUE', 'INTERNATIONAL')),
	CONSTRAINT ch_Etudiant_groupe CHECK (groupe BETWEEN 1 AND 4)
);

CREATE TABLE Question (
	idQ NUMBER(6, 0), 
	numTP NUMBER(1, 0) NOT NULL,
	niveau VARCHAR2(15) NOT NULL,
	temps NUMBER(2, 0) NOT NULL,
	nbVariantes NUMBER(1, 0) DEFAULT 1,
	nbPoints NUMBER(2, 0) DEFAULT 1,
	CONSTRAINT pk_Question PRIMARY KEY (idQ),
	CONSTRAINT ch_Question_numTP CHECK (numTP BETWEEN 1 AND 4),
	CONSTRAINT ch_Etudiant_niveau CHECK (niveau IN ('FACILE', 'NORMAL', 'DIFFICILE', 'COMPLEXE')),
	CONSTRAINT ch_Question_nbVariantes CHECK (nbVariantes BETWEEN 1 AND 3),
	CONSTRAINT ch_Question_nbPoints CHECK (nbPoints BETWEEN 1 AND 5)
);

CREATE TABLE Theme (
	idT NUMBER(6, 0), 
	libelle VARCHAR2(40) NOT NULL,
	idTPere NUMBER(6, 0),
	CONSTRAINT pk_Theme PRIMARY KEY (idT),
	CONSTRAINT fk_Theme_Theme FOREIGN KEY (idTPere) REFERENCES Theme(idT)
);

CREATE TABLE ThemQuest (
	idQ NUMBER(6, 0),
	idT NUMBER(6, 0),
	CONSTRAINT pk_ThemQuest PRIMARY KEY (idQ, idT),
	CONSTRAINT fk_ThemQuest_Question FOREIGN KEY (idQ) REFERENCES Question(idQ),
	CONSTRAINT fk_ThemQuest_Theme FOREIGN KEY (idT) REFERENCES Theme(idT)
);

CREATE TABLE Evaluation (
	idQ NUMBER(6, 0),
	numEt NUMBER(6, 0),
	resultat VARCHAR2(30),
	temps NUMBER(2, 0),
	nbVariantes NUMBER(1, 0) DEFAULT 1,
	nbPoints NUMBER(2, 0) DEFAULT 1,
	CONSTRAINT pk_Evaluation PRIMARY KEY (idQ, numEt),
	CONSTRAINT fk_Evaluation_Question FOREIGN KEY (idQ) REFERENCES Question(idQ),
	CONSTRAINT fk_Evaluation_Etudiant FOREIGN KEY (numEt) REFERENCES Etudiant(numEt),
	CONSTRAINT ch_Evaluation_resultat CHECK (resultat IN ('FAUX', 'ERREUR MINIME', 'JUSTE MAIS NON OPTIMAL', 'JUSTE'))
);

-- **************************************************************************** Insertions des données

PROMPT "Insertions des données";

PROMPT "Insertions des données de la table Etudiant";

INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (1, 'DUPONT', 'JEAN', 'GENERAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (2, 'MOREL', 'EMILIE', 'TECHNOLOGIQUE', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (3, 'MIYAMOTO', 'SHIGERU', 'INTERNATIONAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (4, 'ROBERT', 'ANTOINE', 'GENERAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (5, 'LAMBERT', 'MARIE', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (6, 'DUPONT', 'CAMILLE', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (7, 'DUBOIS', 'LUCAS', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (8, 'WAYNE', 'BRUCE', 'INTERNATIONAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (9, 'LAURENT', 'THOMAS', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (10, 'GIRARD', 'LAURA', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (11, 'MICHEL', 'ADRIEN', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (12, 'LOVELACE', 'ADA', 'INTERNATIONAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (13, 'LEROY', 'ARTHUR', 'TECHNOLOGIQUE', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (14, 'ROUX', 'MAXIME', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (15, 'RENAULT', 'LISA', 'TECHNOLOGIQUE', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (16, 'PERRIN', 'CLAIRE', 'GENERAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (17, 'FRY', 'PHILIP', 'INTERNATIONAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (18, 'FOURNIER', 'ETIENNE', 'TECHNOLOGIQUE', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (19, 'GIRARD', 'BAPTISTE', 'GENERAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (20, 'FERNANDEZ', 'ELISE', 'TECHNOLOGIQUE', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (21, 'FRANCOIS', 'ALEXANDRE', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (22, 'MASSON', 'JULIE', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (23, 'CHEVALIER', 'REMY', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (24, 'DUVAL', 'MAEVA', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (25, 'DUPUIS', 'ROMAIN', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (26, 'COLIN', 'SEBASTIEN', 'TECHNOLOGIQUE', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (27, 'SKŁODOWSKA', 'MARIE', 'INTERNATIONAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (28, 'BARBIER', 'KEVIN', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (29, 'MARTIN', 'PIERRE', 'TECHNOLOGIQUE', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (30, 'RICHARD', 'PAUL', 'GENERAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (31, 'PETIT', 'HUGO', 'TECHNOLOGIQUE', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (32, 'SIMON', 'NICOLAS', 'TECHNOLOGIQUE', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (33, 'LEFEBVRE', 'JULES', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (34, 'DAVID', 'VICTOR', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (35, 'EINSTEIN', 'ALBERT', 'INTERNATIONAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (36, 'BONNET', 'GUILLAUME', 'GENERAL', 1);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (37, 'GARNIER', 'MATHIEU', 'TECHNOLOGIQUE', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (38, 'HIDEO', 'KOJIMA', 'INTERNATIONAL', 2);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (39, 'LEGRAND', 'CEDRIC', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (40, 'VINCENT', 'MATHIS', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (41, 'BARON', 'EMMA', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (42, 'DUJARDIN', 'MARIE', 'GENERAL', 4);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (43, 'BOUCHER', 'AXEL', 'GENERAL', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (44, 'MAURICE', 'LUC', 'TECHNOLOGIQUE', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (45, 'HENRY', 'MARINA', 'TECHNOLOGIQUE', 3);
INSERT INTO Etudiant (numEt, nom, prenom, typeBac, groupe) VALUES (46, 'MOREL', 'DAMIEN', 'GENERAL', 1);

PROMPT "Insertions des données de la table Question";

INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (1, 1, 'FACILE', 10, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (2, 1, 'COMPLEXE', 15, 1, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (3, 1, 'DIFFICILE', 20, 3, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (4, 3, 'COMPLEXE', 20, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (5, 2, 'FACILE', 10, 1, 1);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (6, 2, 'COMPLEXE', 15, 3, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (7, 2, 'DIFFICILE', 20, 2, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (8, 2, 'COMPLEXE', 15, 3, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (9, 3, 'FACILE', 5, 1, 1);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (10, 3, 'NORMAL', 10, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (11, 3, 'DIFFICILE', 15, 3, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (12, 3, 'COMPLEXE', 20, 1, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (13, 4, 'COMPLEXE', 5, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (14, 4, 'NORMAL', 10, 1, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (15, 4, 'DIFFICILE', 15, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (16, 4, 'COMPLEXE', 20, 2, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (17, 4, 'COMPLEXE', 50, 3, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (18, 4, 'NORMAL', 15, 1, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (19, 2, 'DIFFICILE', 20, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (20, 4, 'COMPLEXE', 20, 1, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (21, 2, 'FACILE', 5, 1, 1);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (22, 2, 'NORMAL', 10, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (23, 2, 'DIFFICILE', 15, 1, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (24, 2, 'COMPLEXE', 20, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (25, 3, 'FACILE', 10, 1, 1);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (26, 3, 'NORMAL', 15, 3, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (27, 3, 'DIFFICILE', 20, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (28, 3, 'COMPLEXE', 20, 1, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (29, 4, 'FACILE', 5, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (30, 4, 'NORMAL', 10, 1, 3);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (31, 4, 'DIFFICILE', 15, 3, 5);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (32, 4, 'COMPLEXE', 20, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (33, 3, 'FACILE', 5, 1, 1);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (34, 2, 'NORMAL', 10, 1, 2);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (35, 3, 'DIFFICILE', 15, 1, 4);
INSERT INTO Question (idQ, numTP, niveau, temps, nbVariantes, nbPoints) VALUES (36, 4, 'COMPLEXE', 20, 1, 5);

PROMPT "Insertions des données de la table Theme";

INSERT INTO Theme (idT, libelle, idTPere) VALUES (1, 'CONCEPTION', NULL);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (2, 'LANGAGE DE REQUETES', NULL);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (3, 'MERISE', 1);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (4, 'ALGEBRE RELATIONNELLE', 2);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (5, 'SQL', 2);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (6, 'MCT', 3);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (7, 'MCD', 3);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (8, 'MLT', 3);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (9, 'MLD', 3);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (10, 'MPT', 3);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (11, 'MPD', 3);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (12, 'SQL LDD', 5);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (13, 'SQL LMD', 5);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (14, 'SQL LCT', 5);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (15, 'CREATION DE TABLE', 12);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (16, 'SUPPRESSION DE TABLE', 12);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (17, 'SELECTION SIMPLE', 13);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (18, 'JOINTURE', 13);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (19, 'FONCTION AGREGATIVE OU STATISTIQUE', 13);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (20, 'JOINTURE IMBRIQUEE', 18);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (21, 'JOINTURE PREDICATIVE', 18);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (22, 'AUTO-JOINTURE', 18);
INSERT INTO Theme (idT, libelle, idTPere) VALUES (23, 'JOINTURE EXTERNE', 18);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (24, 'JOINTURE CORRELEE', 20);

INSERT INTO Theme (idT, libelle, idTPere) VALUES (25, 'SUPPRESSION EN CASCADE', 16);

PROMPT "Insertions des données de la table ThemQuest";

-- Répartition équilibrée des questions sur les thèmes 15 à 21

INSERT INTO ThemQuest (idQ, idT) VALUES (1, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (1, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (1, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (2, 22);
INSERT INTO ThemQuest (idQ, idT) VALUES (3, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (4, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (5, 19);
INSERT INTO ThemQuest (idQ, idT) VALUES (6, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (7, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (8, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (9, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (10, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (10, 24);
INSERT INTO ThemQuest (idQ, idT) VALUES (11, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (12, 19);
INSERT INTO ThemQuest (idQ, idT) VALUES (13, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (14, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (15, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (16, 22);
INSERT INTO ThemQuest (idQ, idT) VALUES (17, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (17, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (18, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (19, 19);
INSERT INTO ThemQuest (idQ, idT) VALUES (19, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (20, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (21, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (21, 23);
INSERT INTO ThemQuest (idQ, idT) VALUES (22, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (23, 24);
INSERT INTO ThemQuest (idQ, idT) VALUES (24, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (24, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (25, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (26, 19);
INSERT INTO ThemQuest (idQ, idT) VALUES (27, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (27, 23);
INSERT INTO ThemQuest (idQ, idT) VALUES (28, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (29, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (30, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (31, 17);
INSERT INTO ThemQuest (idQ, idT) VALUES (31, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (32, 18);
INSERT INTO ThemQuest (idQ, idT) VALUES (33, 19);
INSERT INTO ThemQuest (idQ, idT) VALUES (33, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (34, 20);
INSERT INTO ThemQuest (idQ, idT) VALUES (35, 21);
INSERT INTO ThemQuest (idQ, idT) VALUES (36, 15);
INSERT INTO ThemQuest (idQ, idT) VALUES (36, 22);

PROMPT "Insertions des données de la table Evaluation";

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 2, 'JUSTE MAIS NON OPTIMAL', 7, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 7, 'JUSTE', 9, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 9, 'ERREUR MINIME', 3, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 11, 'FAUX', 13, 0, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 17, 'JUSTE MAIS NON OPTIMAL', 8, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 19, 'FAUX', 9, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 21, 'JUSTE MAIS NON OPTIMAL', 6, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 25, 'FAUX', 18, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 27, 'ERREUR MINIME', 8, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 29, 'FAUX', 9, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 31, 'FAUX', 10, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 37, 'JUSTE MAIS NON OPTIMAL', 5, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 39, 'ERREUR MINIME', 4, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (1, 41, 'FAUX', 1, 0, 0);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 1, 'FAUX', 0, 0, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 4, 'ERREUR MINIME', 8, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 5, 'ERREUR MINIME', 14, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 8, 'JUSTE', 10, 1, 3);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 9, 'JUSTE MAIS NON OPTIMAL', 12, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 11, 'JUSTE MAIS NON OPTIMAL', 12, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 12, 'JUSTE', 6, 1, 3);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 14, 'ERREUR MINIME', 14, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 19, 'FAUX', 21, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 23, 'ERREUR MINIME', 13, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 24, 'FAUX', 10, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 25, 'JUSTE MAIS NON OPTIMAL', 12, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 27, 'JUSTE', 6, 1, 3);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 28, 'JUSTE', 8, 1, 3);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 31, 'FAUX', 19, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 33, 'ERREUR MINIME', 15, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 34, 'ERREUR MINIME', 8, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 35, 'JUSTE MAIS NON OPTIMAL', 6, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 37, 'ERREUR MINIME', 13, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 39, 'FAUX', 21, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 41, 'FAUX', 22, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (2, 44, 'ERREUR MINIME', 9, 1, 1);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 1, 'JUSTE', 10, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 6, 'JUSTE', 12, 2, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 7, 'JUSTE MAIS NON OPTIMAL', 13, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 9, 'JUSTE MAIS NON OPTIMAL', 13, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 12, 'JUSTE', 14, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 13, 'JUSTE MAIS NON OPTIMAL', 17, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 16, 'JUSTE', 11, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 17, 'JUSTE MAIS NON OPTIMAL', 11, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 22, 'JUSTE', 15, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 25, 'JUSTE MAIS NON OPTIMAL', 14, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 26, 'JUSTE', 12, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 27, 'JUSTE MAIS NON OPTIMAL', 19, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 32, 'JUSTE', 14, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 33, 'JUSTE MAIS NON OPTIMAL', 10, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 36, 'JUSTE', 11, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 37, 'JUSTE MAIS NON OPTIMAL', 13, 3, 3.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 42, 'JUSTE', 14, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 45, 'JUSTE', 16, 3, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (3, 46, 'JUSTE MAIS NON OPTIMAL', 11, 3, 3.5);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 1, 'JUSTE MAIS NON OPTIMAL', 19, 1, 3);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 3, 'JUSTE', 15, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 5, 'JUSTE', 10, 1, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 9, 'JUSTE', 18, 1, 5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 12, 'JUSTE', 12, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 13, 'JUSTE', 16, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 15, 'JUSTE', 13, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 17, 'FAUX', 20, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 20, 'JUSTE', 17, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 21, 'FAUX', 20, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 25, 'FAUX', 22, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 27, 'JUSTE', 12, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 29, 'JUSTE', 16, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 35, 'JUSTE', 12, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 40, 'JUSTE', 17, 1, 4);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 43, 'ERREUR MINIME', 18, 1, 1.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (4, 45, 'JUSTE', 13, 1, 5);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 1, 'JUSTE MAIS NON OPTIMAL', 10, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 3, 'ERREUR MINIME', 8, 1, 0.25);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 5, 'FAUX', 20, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 10, 'FAUX', 8, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 13, 'JUSTE MAIS NON OPTIMAL', 6, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 15, 'FAUX', 20, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 17, 'FAUX', 18, 2, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 18, 'ERREUR MINIME', 7, 1, 0.25);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 21, 'JUSTE MAIS NON OPTIMAL', 7, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 23, 'JUSTE', 5, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 29, 'JUSTE', 6, 1, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 30, 'FAUX', 8, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 33, 'JUSTE MAIS NON OPTIMAL', 5, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 38, 'ERREUR MINIME', 7, 1, 0.25);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 41, 'JUSTE MAIS NON OPTIMAL', 8, 1, 0.5);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (5, 43, 'JUSTE MAIS NON OPTIMAL', 6, 1, 0.5);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (6, 12, 'JUSTE MAIS NON OPTIMAL', 10, 3, 1);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (6, 27, 'JUSTE', 10, 3, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (6, 33, 'JUSTE', 15, 3, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (6, 35, 'JUSTE', 12, 3, 2);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (8, 17, 'FAUX', 3, 2, 0);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (9, 17, 'FAUX', 9, 1, 0);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (9, 42, 'ERREUR MINIME', 4, 1, 0.25);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (12, 42, 'FAUX', 34, 1, 0);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (13, 12, 'JUSTE', 2, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (13, 27, 'JUSTE MAIS NON OPTIMAL', 3, 1, 2);
INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (13, 35, 'JUSTE', 4, 1, 2);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (15, 42, 'JUSTE MAIS NON OPTIMAL', 14, 1, 2.5);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (18, 42, 'FAUX', 34, 1, 0);

INSERT INTO Evaluation (idQ, numEt, resultat, temps, nbVariantes, nbPoints) VALUES (21, 42, 'JUSTE', 4, 1, 1);

PROMPT "Fin de la création de la base de données Questionnaire";