1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
INSERT INTO ETUDIANTES (N_INSCRIPTION, NOM, PRENOM) VALUES (100, 'marin', 'david');
INSERT INTO ETUDIANTES (N_INSCRIPTION, NOM, PRENOM) VALUES (101, 'mula', 'young');
INSERT INTO ETUDIANTES (N_INSCRIPTION, NOM, PRENOM) VALUES (102, 'ford', 'ilisa');
COMMIT;
INSERT INTO MODULES (CODE_MODULE, NOM_MODULE, COEFFICIENT) VALUES ('1', 'ALGO', 4);
INSERT INTO MODULES (CODE_MODULE, NOM_MODULE, COEFFICIENT) VALUES ('2', 'DELPHI', 4);
INSERT INTO MODULES (CODE_MODULE, NOM_MODULE, COEFFICIENT) VALUES ('3', 'anglais', 1);
INSERT INTO MODULES (CODE_MODULE, NOM_MODULE, COEFFICIENT) VALUES ('4', 'francais', 2);
COMMIT;
INSERT INTO SEMESTRES (CODE_SEMESTRE) VALUES ('S1');
INSERT INTO SEMESTRES (CODE_SEMESTRE) VALUES ('S2');
COMMIT;
INSERT INTO AFFECTATION_MODULES (CODE_MODULE, CODE_SEMESTRE, DUREE) VALUES ('1', 'S1', 120);
INSERT INTO AFFECTATION_MODULES (CODE_MODULE, CODE_SEMESTRE, DUREE) VALUES ('4', 'S1', 60);
INSERT INTO AFFECTATION_MODULES (CODE_MODULE, CODE_SEMESTRE, DUREE) VALUES ('2', 'S2', 140);
INSERT INTO AFFECTATION_MODULES (CODE_MODULE, CODE_SEMESTRE, DUREE) VALUES ('3', 'S2', 140);
COMMIT;
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (100, '2', 'S2', 12, 13, 11.5, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (100, '4', 'S1', 10, 15, 14, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (100, '3', 'S2', 17, 18, 19, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (101, '1', 'S1', 13, 14, 18, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (101, '2', 'S2', 14.5, 15.5, 16.5, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (101, '3', 'S2', 9.5, 5, 7, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (101, '4', 'S1', 8.5, 9.5, 10.5, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (102, '1', 'S1', 16, 17, 19, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (102, '2', 'S2', 17.5, 14.25, 19.5, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (102, '3', 'S2', 11.5, 16.5, 17, NULL);
INSERT INTO RESULTATS (N_INSCRIPTION, CODE_MODULE, CODE_SEMESTRE, CONTROLE1, CONTROLE2, EXAMEN, OBSRVATION) VALUES (102, '4', 'S1', 10.75, 17.5, 16, NULL);
COMMIT; |
Partager