INSERT INTO Departement VALUES ('1','MIDO');
INSERT INTO Departement VALUES ('2','LSO');
INSERT INTO Departement VALUES ('3','MSO');


INSERT INTO Etudiant VALUES ('1','GAMOTTE', 'Albert','1979/02/18','50, Rue des alouettes','PARIS','75021','0143567890',NULL,'gamotal4@etud.dauphine.fr');
INSERT INTO Etudiant VALUES ('2','HIBULAIRE', 'Pat','1980/08/23','10, Avenue des marguerites','POUILLON','40000','0678567801',NULL,'pat@yahoo.fr');
INSERT INTO Etudiant VALUES ('3','ODENT', 'Jamal','1978/05/12','25, Boulevard des fleurs','PARIS','75022','0145678956','0145678956','odent@free.fr');
INSERT INTO Etudiant VALUES ('4','DEBECE', 'Gill','1979/07/15','56, Boulevard des fleurs','PARIS','75022','0678905645',NULL,'deby@hotmail.com');
INSERT INTO Etudiant VALUES ('5','DEBECE', 'Aude','1979/08/15','45, Avenue des abeilles','PARIS','75022',NULL,NULL,NULL);

INSERT INTO Enseignant VALUES('1',(SELECT Departement_id FROM Departement WHERE nom_departement='MIDO') ,'MANOUVRIER','Maude','MCF','4185','4091','maude.manouvrier@dauphine.fr');
INSERT INTO Enseignant VALUES('2','1','BELHAJJAME','Khalid ','MCF','','','khalid.belhajjame[at]dauphine.fr');
INSERT INTO Enseignant VALUES('3','1','NEGRE','Elsa ','MCF','','','elsa.negre[at]dauphine.fr');
INSERT INTO Enseignant VALUES('4','1','MURAT','Cecile ','MCF','','','cecile.murat[at]dauphine.fr');

INSERT INTO Salle VALUES('B','020','15');
INSERT INTO Salle VALUES('B','022','15');
INSERT INTO Salle VALUES('A','301','45');
INSERT INTO Salle VALUES('C','Amphi 8','500');
INSERT INTO Salle VALUES('C','Amphi 4','200');


INSERT INTO Cours VALUES ('1','1','Bases de Données Relationnelles','Niveau Licence (L3) : Modélisation E/A et UML, Modèle relationnel, Algèbre Relationnelle, Calcul relationel, SQL, dépendances fonctionnelles et formes normales');
INSERT INTO Cours VALUES ('2','1','Langage C++','Niveau Master 1');
INSERT INTO Cours VALUES ('3','1','Mise à Niveau Bases de Données','Niveau Master 2 - Programme Licence et Master 1 en Bases de Données');

INSERT INTO Reservation VALUES ('1','B','022','1','1',(SELECT Enseignant_id FROM Enseignant WHERE Nom='MANOUVRIER'),'2016/10/15','08:30:00','11:45:00','3');
INSERT INTO Reservation VALUES ('2','B','022','1','1','2','2016/11/04','08:30:00','11:45:00','3');
INSERT INTO Reservation VALUES ('3','B','022','1','1','2',DEFAULT,'08:30:00','11:45:00','3');
INSERT INTO Reservation VALUES ('4','B','020','1','1','1',DEFAULT,'08:30:00','11:45:00','3');