--Table Etudiant

--INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (110, 'Dupont', 'Albert', '01-06-1980', 'Rue de Crimée', 69001, 'Lyon');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (222, 'West', 'James', '03-09-1983', 'Studio', ' ', 'Hollywood');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (300, 'Martin', 'Marie', '05-06-1988', 'Rue des Acacias', 69130, 'Ecully');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (421, 'Durant', 'Gaston', '15-11-1980', 'Rue de la Meuse', 69008, 'Lyon');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (575, 'Titgoutte', 'Justine', '28-02-1985', 'Chemin du Château', 69630, 'Chaponost');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (667, 'Dupond', 'Noémie', '18-09-1987', 'Rue de Dôle', 69007, 'Lyon');
INSERT INTO etudiant (numetu, nom, prenom, datenaiss, rue, cp, ville) VALUES (999, 'Phantom', 'Marcel', '30-01-1960', ' ', ' ', ' ');

--Table Matiere

INSERT INTO matiere (codemat, libelle, coef) VALUES ('STA', 'Statistique',0.4);
INSERT INTO matiere (codemat, libelle, coef) VALUES ('INF', 'Informatique',0.4);
INSERT INTO matiere (codemat, libelle, coef) VALUES ('ECO', 'Econometrie',0.2);


--Table Epreuve

INSERT INTO epreuve (numepreuve, datepreuve, lieu, codemat) VALUES (11031, '15-12-2003', 'Salle 191L', 'STA');
INSERT INTO epreuve (numepreuve, datepreuve, lieu, codemat) VALUES (11032, '01-04-2004', 'Amphi G', 'STA');
INSERT INTO epreuve (numepreuve, datepreuve, lieu, codemat) VALUES (21031, '30-10-2003', 'Salle 191L', 'INF');
INSERT INTO epreuve (numepreuve, datepreuve, lieu, codemat) VALUES (21032, '01-06-2004', 'Salle 192L', 'INF');
INSERT INTO epreuve (numepreuve, datepreuve, lieu, codemat) VALUES (31030, '02-06-2004', 'Salle 05R', 'ECO');


--Table Notation

INSERT INTO notation VALUES (110, 11031, 10);
INSERT INTO notation VALUES (110, 11032, 11.5);
INSERT INTO notation VALUES (110, 21031, 8.5);
INSERT INTO notation VALUES (110, 21032, NULL);
INSERT INTO notation VALUES (110, 31030, 13);
INSERT INTO notation VALUES (222, 11031, 9);
INSERT INTO notation VALUES (222, 11032, 14);
INSERT INTO notation VALUES (222, 21031, 12);
INSERT INTO notation VALUES (222, 31030, 20);
INSERT INTO notation VALUES (300, 11031, 14);
INSERT INTO notation VALUES (300, 11032, 20);
INSERT INTO notation VALUES (300, 21031, 20);
INSERT INTO notation VALUES (300, 21032, 13.5);
INSERT INTO notation VALUES (300, 31030, 16);
INSERT INTO notation VALUES (421, 11031, 5.5);
INSERT INTO notation VALUES (421, 11032, 7);
INSERT INTO notation VALUES (421, 21031, 1.5);
INSERT INTO notation VALUES (421, 21032, NULL);
INSERT INTO notation VALUES (421, 31030, 10);
INSERT INTO notation VALUES (575, 11031, 13);
INSERT INTO notation VALUES (575, 11032, 9);
INSERT INTO notation VALUES (575, 21031, 12.5);
INSERT INTO notation VALUES (575, 21032, 14);
INSERT INTO notation VALUES (575, 31030, 7);
INSERT INTO notation VALUES (667, 21032, 16);
INSERT INTO notation VALUES (667, 11032, 20);
INSERT INTO notation VALUES (667, 21031, 8.5);
INSERT INTO notation VALUES (667, 31030, NULL);
