-- V1.5.0

PROMPT "Création de la base de données Gestion pédagogique";

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

PROMPT "Suppression de toutes les vues";

DROP VIEW Q1;
DROP VIEW Q2;
DROP VIEW Q3;
DROP VIEW Q4;
DROP VIEW Q51;
DROP VIEW Q52;
DROP VIEW Q6;
DROP VIEW Q7;
DROP VIEW Q8;
DROP VIEW Q9;

PROMPT "Suppression de toutes les autres éventuelles vues";

BEGIN
   FOR v IN (SELECT view_name FROM user_views) 
   LOOP
      EXECUTE IMMEDIATE 'DROP VIEW "' || v.view_name || '"';
   END LOOP;
END;
/

PROMPT "Définition des données";

DROP TABLE Note CASCADE CONSTRAINTS PURGE;
DROP TABLE Enseigne CASCADE CONSTRAINTS PURGE;
DROP TABLE Professeur CASCADE CONSTRAINTS PURGE;
DROP TABLE Module CASCADE CONSTRAINTS PURGE;
DROP TABLE Etudiant CASCADE CONSTRAINTS PURGE;

CREATE TABLE Etudiant (
	numEt NUMBER(6, 0),
	nomEt VARCHAR2(30),
	prenomEt VARCHAR2(20),
	cpEt VARCHAR2(5),
	villeEt VARCHAR2(20),
	anneeEt NUMBER(2, 0),
	groupeEt NUMBER(1, 0),
	CONSTRAINT pk_Etudiant PRIMARY KEY (numEt),
	CONSTRAINT uk_Etudiant_01 UNIQUE (nomEt, prenomEt),
	CONSTRAINT ck_anneeEt CHECK (anneeEt BETWEEN 1 AND 3),
	CONSTRAINT ck_groupeEt CHECK (groupeEt BETWEEN 1 AND 5)
);

CREATE TABLE Professeur (
	numProf NUMBER(3, 0),
	nomProf VARCHAR2(30),
	prenomProf VARCHAR2(20),
	adresseProf VARCHAR2(40),
	cpProf VARCHAR2(5),
	villeProf VARCHAR2(20),
	specProf VARCHAR2(7),
	CONSTRAINT pk_Prof PRIMARY KEY (numProf),
	CONSTRAINT uk_Prof_01 UNIQUE (nomProf, prenomProf)
);

CREATE TABLE Module (
	code VARCHAR2(7),
	libelle VARCHAR2(30),
	heureCMPrev NUMBER(3, 0),
	heureCMReal NUMBER(3, 0),
	heureTPPrev NUMBER(3, 0),
	heureTPReal NUMBER(3, 0),
	discipline VARCHAR2(15),
	coefCC NUMBER(3, 0),
	coefTest NUMBER(3, 0),
	resp NUMBER(3, 0),
	codePere VARCHAR2(7),
	CONSTRAINT pk_Module PRIMARY KEY (code),
	CONSTRAINT fk_Prof_Module FOREIGN KEY (resp) REFERENCES Professeur(numProf),
	CONSTRAINT fk_Prof_Prof FOREIGN KEY (codePere) REFERENCES Module(code),
	CONSTRAINT ck_discipline CHECK (discipline IN ('INFORMATIQUE', 'MATHS', 'GESTION')),
	CONSTRAINT ck_coefCC CHECK (coefCC BETWEEN 0 AND 100),
	CONSTRAINT ck_coefTest CHECK (coefTest BETWEEN 0 AND 100),
	CONSTRAINT ck_coefCC_coefTest CHECK (COALESCE(coefCC, 0) + COALESCE(coefTest, 0) IN (0, 100))
);

CREATE TABLE Enseigne (
	code VARCHAR2(7),
	numProf NUMBER(3, 0),
	numEt NUMBER(6, 0),
	CONSTRAINT pk_Enseignt PRIMARY KEY (code, numProf, numEt),
	CONSTRAINT fk_Enseignt_code FOREIGN KEY (code) REFERENCES Module(code),
	CONSTRAINT fk_Enseignt_Prof FOREIGN KEY (numProf) REFERENCES Professeur(numProf),
	CONSTRAINT fk_Enseignt_Etudiant FOREIGN KEY (numEt) REFERENCES Etudiant(numEt)
);

CREATE TABLE Note (
	numEt NUMBER(6, 0),
	code VARCHAR2(7),
	moyCC NUMBER(2, 0),
	moyTest NUMBER(2, 0),
	CONSTRAINT pk_Notation PRIMARY KEY (numEt, code),
	CONSTRAINT fk_Notation_Module FOREIGN KEY (code) REFERENCES Module(code),
	CONSTRAINT fk_Notation_Etudiant FOREIGN KEY (numEt) REFERENCES Etudiant (numEt)
);

-- Référence circulaire.
ALTER TABLE Professeur ADD CONSTRAINT fk_Prof_Module FOREIGN KEY (specProf) REFERENCES Module(code);

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

PROMPT "Insertions des données";

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

INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2101, 'ALARCON', 'LAURENT', NULL, NULL, 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2102, 'ARNAUD', 'EMMANUEL', NULL, 'AIX-EN-PROVENCE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2103, 'BALESTRIERI', 'KARINE', NULL, 'MARIGNANE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2104, 'BERENGUIER', 'BERNARD', NULL, 'AIX-EN-PROVENCE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2105, 'BOURMAD', 'MEHDI', NULL, 'AIX-EN-PROVENCE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2113, 'GALINIER', 'BENOIT', NULL, 'AIX-EN-PROVENCE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2121, 'RIBES', 'MARIE-LAURENCE', NULL, 'AIX-EN-PROVENCE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2124, 'TRAN', 'TRI', NULL, 'MARTIGUES', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2125, 'VERGES', 'LAURENT', NULL, 'MARSEILLE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2114, 'GASSE', 'DIDIER', NULL, 'MARSEILLE', 2, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2201, 'ALVES', 'EMMANUEL', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2202, 'ARCHAMBAULD', 'JULIEN', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2207, 'CADET', 'CELINE', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2209, 'CHADEAU', 'CEDRIC', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2211, 'COSTE', 'THOMAS', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2212, 'DEFOSSE', 'JEREMY', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2217, 'JEGO', 'NICOLAS', NULL, 'MARSEILLE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2220, 'MICHAUD', 'OLIVIER', NULL, 'ISTRES', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2222, 'NEVEU', 'PASCAL', NULL, 'AIX-EN-PROVENCE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2224, 'REY', 'CATHERINE', NULL, 'AIX-EN-PROVENCE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2226, 'VIO', 'BERTRAND', NULL, 'AIX-EN-PROVENCE', 2, 2);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2301, 'ANDRE', 'NATHALIE', NULL, 'MARSEILLE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2302, 'ATLANI', 'JEROME', NULL, 'MARSEILLE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2304, 'BASSET', 'OLIVIER', NULL, 'MARSEILLE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2306, 'BOREL', 'BERNARD', NULL, 'MARSEILLE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2317, 'LYON', 'PHILIPPE', NULL, 'MARSEILLE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2318, 'MAI', 'CHRISTINE', NULL, 'GAP', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2316, 'LEVY', 'SANDRINE', NULL, 'AIX-EN-PROVENCE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2320, 'NELLI', 'ANNICK', NULL, 'AIX-EN-PROVENCE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2326, 'WELKER', 'THIERRY', NULL, 'AIX-EN-PROVENCE', 2, 3);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2401, 'ARTAUD', 'SABINE', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2402, 'AUBERT', 'MICHEL', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2404, 'BOEUF', 'FREDERIC', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2406, 'CROTTI', 'MURIEL', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2412, 'LANDAIS', 'SANDRA', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2421, 'PONZIO', 'ANNE', NULL, 'MARSEILLE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2422, 'ROCCHI', 'STEPHANE', NULL, 'AIX-EN-PROVENCE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2423, 'SEU', 'SEBASTIEN', NULL, 'AIX-EN-PROVENCE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2415, 'MESSINA', 'DIDIER', NULL, 'AIX-EN-PROVENCE', 2, 4);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2501, 'APPRIOU', 'GUERLAIN', NULL, 'AIX-EN-PROVENCE', 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2503, 'BLANC', 'DOMINIQUE', NULL, 'AIX-EN-PROVENCE', 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2509, 'DONNAY', 'SEVERINE', NULL, 'AIX-EN-PROVENCE', 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2512, 'GARRO', 'PATRICK', NULL, 'AIX-EN-PROVENCE', 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2516, 'LAMY', 'DAVID', NULL, 'AIX-EN-PROVENCE', 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (2523, 'PINELLI', 'SERGE', NULL, NULL, 2, 5);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1101, 'ALLIONE', 'MATHIEU', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1102, 'ANDRE', 'JULIE', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1103, 'BEAUJEAN', 'ADAM', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1104, 'BELLE', 'FLORENT', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1105, 'BERNO', 'CHARLES', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1106, 'BOVEE', 'CHARLES', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1107, 'BRYIS', 'JONATHAN', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1108, 'CHIABAUT', 'DIMITRI', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1109, 'COPPARD', 'REMI', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1110, 'DEFOSSEZ', 'GAEL', NULL, NULL, 1, 1);
INSERT INTO Etudiant (numEt, nomEt, prenomEt, cpEt, villeEt, anneeEt, groupeEt) VALUES (1111, 'DUMAS', 'BENJAMIN', NULL, NULL, 1, 1);

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

INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (1, 'BOITARD', 'DIDIER', NULL, NULL, 'AIX-EN-PROVENCE', 'ACSI');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (2, 'FAURE', 'BERNARD', NULL, NULL, 'AIX-EN-PROVENCE', 'ACSI');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (3, 'CICCHETTI', 'ROSINE', NULL, NULL, 'AIX-EN-PROVENCE', 'BD');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (4, 'FENEUILLE', 'DANIEL', NULL, NULL, 'AIX-EN-PROVENCE', 'ADA');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (5, 'LAPORTE', 'MARC', NULL, NULL, 'AIX-EN-PROVENCE', 'C++');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (6, 'AVIGNON', 'THIERRY', NULL, NULL, 'AIX-EN-PROVENCE', 'ADA');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (7, 'MATHIEU', 'DIDIER', NULL, NULL, 'MARSEILLE', 'C++');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (8, 'BETARI', 'KADER', NULL, NULL, 'MARSEILLE', 'ADA');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (9, 'PAPINI', 'ODILE', NULL, NULL, 'MARSEILLE', NULL);
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (10, 'MALPAS', 'MYLENE', NULL, NULL, NULL, NULL);
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (11, 'GIOVAMPAOLI', 'JOSETTE', NULL, NULL, NULL, 'ANGL2');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (12, 'CACCHIA', 'MARIE-CLAUDE', NULL, NULL, NULL, 'EGO');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (13, 'LAKHAL', 'LOTFI', NULL, NULL, 'AIX-EN-PROVENCE', 'BD');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (14, 'PAIN-BARRE', 'CYRIL', NULL, NULL, 'MARSEILLE', 'RES');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (15, 'DRAGUT', 'ANDREEA', NULL, NULL, 'AIX-EN-PROVENCE', 'SYS');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (16, 'BONHOMME', 'CHRISTIAN', NULL, NULL, 'MARSEILLE', 'BD');
INSERT INTO Professeur (numProf, nomProf, prenomProf, adresseProf, cpProf, villeProf, specProf) VALUES (17, 'SUN', 'PIERRE', NULL, NULL, 'MARSEILLE', 'ACSI');

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

INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PPNINFO', 'PROGRAMME INFO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PINFO1', 'INFORMATIQUE 1ERE ANNEE', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'PPNINFO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PINFO2', 'INFORMATIQUE 2EME ANNEE', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'PPNINFO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PCC1', 'COMPETENCES COMP 1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PPNINFO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PCC2', 'COMPETENCES COMP 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PPNINFO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('OMGL', 'OUTILS MODELES GENIE LOGICIEL', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'PINFO2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('OMGL1', 'ANALYSE,  CONCEPTION', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'OMGL');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('OMGL2', 'PRINCIPES DES BD', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'OMGL');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ACSI', 'CONCEPTION DE SI', 30, NULL, 40, NULL, 'INFORMATIQUE', 40, 60, 1, 'OMGL1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('CAS1', 'ETUDE DE CAS 1', NULL, NULL, NULL, NULL, 'INFORMATIQUE', 100, 0, 1, 'OMGL1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('CAS2', 'ETUDE DE CAS 2', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'OMGL1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('BD', 'BASES DE DONNEES', 20, NULL, 60, NULL, 'INFORMATIQUE', 40, 60, 3, 'OMGL2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ASR', 'ARCHITECTURE,  ING. RESEAUX', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'PINFO2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ASR1', 'CODAGE ET CIRCUITS', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'ASR');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('SYS', 'SYSTEME', 45, NULL, 50, NULL, 'INFORMATIQUE', 50, 50, 4, 'ASR1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('RES', 'RESEAUX', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ASR1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('AP', 'ALGORITHMIQUE ET PROGRAMMATION', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PINFO2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('AP1', 'ALGORITHMIQUE', NULL, NULL, NULL, NULL, 'INFORMATIQUE', NULL, NULL, NULL, 'AP');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('C++', 'PROGRAMMATION C++', 45, NULL, 50, NULL, 'INFORMATIQUE', 50, 50, 7, 'AP1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ADA', 'LANGAGE ADA', 45, NULL, 60, NULL, 'INFORMATIQUE', 50, 50, 6, 'AP1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('PRL', 'PROLOG', 20, NULL, 35, NULL, 'INFORMATIQUE', 60, 40, 9, 'AP1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('MATH1', 'MATHEMATIQUES 1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PCC1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('LANG1', 'LANGUE VIVANTE 1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PCC1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ANGL1', 'ANGLAIS', 80, NULL, 0, NULL, NULL, 0, 100, 11, 'LANG1');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('EGO', 'ECONOMIE GESTION ORGANISATION', NULL, NULL, NULL, NULL, 'GESTION', NULL, NULL, NULL, 'PCC2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('CPTA', 'COMPTABILITE', 25, NULL, 0, NULL, 'GESTION', 40, 60, 10, 'EGO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('MKTG', 'MARKETING', 25, NULL, 0, NULL, 'GESTION', 40, 60, 12, 'EGO');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('MATH2', 'MATHEMATIQUES 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PCC2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('RO', 'RECHERCHE OPERATIONNELLE', 20, NULL, 25, NULL, 'MATHS', 50, 50, NULL, 'MATH2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('LANG2', 'LANGUE VIVANTE 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PCC2');
INSERT INTO Module (code, libelle, heureCMPrev, heureCMReal, heureTPPrev, heureTPReal, discipline, coefCC, coefTest, resp, codePere) VALUES ('ANGL2', 'ANGLAIS', 80, NULL, 0, NULL, NULL, 0, 100, 11, 'LANG2');

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

INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 1, 2101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 1, 2102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 1, 2404);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 1, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2103);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2104);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2105);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2113);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2114);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2121);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2124);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2125);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2201);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2202);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2207);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2209);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2211);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2212);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2217);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2220);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2222);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2224);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2226);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2301);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2302);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2304);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2306);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2316);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2318);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2320);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2326);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2401);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2402);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2404);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2406);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2412);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2415);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2421);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2423);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2501);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2503);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2509);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2512);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2516);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 2, 2523);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 3, 2101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 3, 2102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 3, 2103);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 3, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ACSI', 3, 2501);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ADA', 5, 2401);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('ADA', 5, 2402);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 1, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 1, 2401);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 1, 2402);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 1, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 1, 2501);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 2, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 2, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 2, 2501);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2302);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2501);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2503);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2509);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2512);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2516);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 3, 2523);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1103);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1104);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1105);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1106);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1107);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1108);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1109);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1110);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 1111);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('BD', 13, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1103);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1104);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1105);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1106);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1107);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1108);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1109);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1110);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 1111);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 5, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('C++', 7, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2302);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2412);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2415);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2422);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('CPTA', 12, 2423);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('PRL', 9, 2302);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1101);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1102);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1103);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1104);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1105);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1106);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1107);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1108);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1109);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1110);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 14, 1111);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('RES', 15, 2302);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('SYS', 5, 2401);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('SYS', 5, 2402);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('SYS', 5, 2404);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('SYS', 7, 2317);
INSERT INTO Enseigne (code, numProf, numEt) VALUES ('SYS', 15, 2317);

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

INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2406, 'ACSI', 11, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2404, 'ACSI', 10, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2401, 'ACSI', 8, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2402, 'ACSI', 15, 17);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2326, 'ACSI', 13, 17);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2320, 'ACSI', 6, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2318, 'ACSI', 15, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2317, 'ACSI', 9, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2301, 'ACSI', 16, 18);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2523, 'ACSI', 11, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2516, 'ACSI', 10, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2512, 'ACSI', 9, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2509, 'ACSI', 14, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2503, 'ACSI', 8, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2406, 'BD', 12, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2404, 'BD', 14, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2401, 'BD', 8, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2402, 'BD', 5, 7);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2326, 'BD', 13, 16);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2320, 'BD', 10, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2318, 'BD', 15, 17);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2317, 'BD', 12, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2301, 'BD', 15, 18);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2523, 'BD', 14, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2516, 'BD', 8, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2512, 'BD', 7, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2509, 'BD', 12, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2503, 'BD', 6, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2406, 'RO', 13, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2404, 'RO', 17, 19);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2401, 'RO', 8, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2402, 'RO', 10, 0);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2326, 'RO', 13, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2320, 'RO', 12, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2318, 'RO', 16, 17);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2317, 'RO', 14, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2301, 'RO', 11, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2523, 'RO', 15, 16);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2516, 'RO', 12, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2512, 'RO', 7, 11);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2509, 'RO', 11, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2503, 'RO', 8, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2101, 'ACSI', 10, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2101, 'PRL', 4, 16);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2102, 'ACSI', 13, 6);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2102, 'PRL', 12, 3);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2103, 'ACSI', 14, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2103, 'PRL', 12, 9);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2104, 'ACSI', 10, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2104, 'PRL', 9, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2105, 'ACSI', 13, NULL);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2105, 'PRL', 10, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2113, 'ACSI', 9, 8);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2113, 'PRL', 11, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2121, 'ACSI', 7, 18);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2121, 'PRL', 9, 16);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2124, 'ACSI', 15, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2124, 'PRL', 8, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2125, 'ACSI', 10, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'ACSI', 10, 19);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'PRL', 10, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'SYS', 6, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'RO', 14, 17);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'CPTA', 12, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'ADA', 8, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'MKTG', 13, 15);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2316, 'ACSI', 16, 8);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2316, 'PRL', 12, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2316, 'SYS', 8, 14);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'ANGL2', NULL, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2422, 'BD', NULL, 13);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2201, 'ACSI', 10, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2202, 'ACSI', 9, 10);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2207, 'ACSI', 13, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2209, 'ACSI', 6, NULL);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2201, 'BD', 15, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2202, 'BD', 17, NULL);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2207, 'BD', 13, 12);
INSERT INTO Note (numEt, code, moyCC, moyTest) VALUES (2209, 'BD', 6, NULL);

PROMPT "Fin de la création de la base de données Gestion pédagogique";