INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" )
    VALUES (1000 ,'1' ,'1'  );
INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" ) VALUES (1001 ,'1' ,'3'  );
INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" ) VALUES (1001 ,'2' ,'2'  );
INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" ) VALUES (1001 ,'3' ,'5'  );
INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" ) VALUES (1002 ,'3' ,'2'  );
INSERT INTO "STEPHAN"."BELEGUNG" ("MATRNR" ,"ID_VOR" ,"NOTE" ) VALUES (1002 ,'2' ,'1'  );

INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,
    "ADRESSE" )
    VALUES ('Friebe' ,TO_DATE('27.05.1972', 'dd-Mon-yyyy HH:MI:SS
    AM') ,'kiel' ,'Am Hang 1'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('Franziska Meier' ,TO_DATE('03.06.1982', 'dd-mm-yyyy') ,'Hamburg' ,'Straße 1'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('Franz Lehmann' ,TO_DATE('12.12.1969', 'dd-mm-yyyy') ,'Dresden' ,'Hauptstr. 10'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('Bernd Thalheim' ,TO_DATE('10.03.1952', 'dd-mm-yyyy') ,'Dresden' ,'d'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('HJ Klein' ,TO_DATE('03.05.1952', 'dd-mm-yyyy') ,'Kiel' ,'d'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('M Schneider' ,TO_DATE('17.08.1955', 'dd-mm-yyyy') ,'Köln' ,'d'  );
INSERT INTO "STEPHAN"."PERSON" ("NAME" ,"GEBDATUM" ,"GBURTSORT" ,"ADRESSE" ) VALUES ('Max Friebe' ,TO_DATE('12.12.1970', 'dd-mm-yyyy') ,'Kiel' ,'Hauptstr. 10'  );

INSERT INTO "STEPHAN"."PROFESSOR" ("ID_PRO" ,"GEBDATUM" ,"NAME" ,
    "BESITZT" )
    VALUES (1 ,TO_DATE('10.03.1952', 'dd-mm-yyyy') ,'Bernd Thalheim' ,'a');
    
INSERT INTO "STEPHAN"."PROFESSOR" ("ID_PRO" ,"GEBDATUM" ,"NAME" ,
    "BESITZT" )
    VALUES (2 ,TO_DATE('03.05.1952', 'dd-mm-yyyy') ,'HJ Klein' ,'a');

    INSERT INTO "STEPHAN"."PROFESSOR" ("ID_PRO" ,"GEBDATUM" ,"NAME" ,
    "BESITZT" )
    VALUES (3 ,TO_DATE('17.08.1955', 'dd-mm-yyyy'),'M Schneider' ,'a');

INSERT INTO "STEPHAN"."STUDENT" ("MATRNR" ,"GEBDATUM" ,"NAME" )
    VALUES (1000 ,TO_DATE('03.06.1982', 'dd-mm-yyyy') ,'Franziska Meier'  );
    
INSERT INTO "STEPHAN"."STUDENT" ("MATRNR" ,"GEBDATUM" ,"NAME" )
    VALUES (1001 ,TO_DATE('12.12.1979', 'dd-mm-yyyy'),'Franz Lehmann'  );
    
INSERT INTO "STEPHAN"."KURS" ("KURSBEZ" ,"KURSNR" )
    VALUES ('DB Zertifikat' ,1  );
INSERT INTO "STEPHAN"."KURS" ("KURSBEZ" ,"KURSNR" ) VALUES ('Datenbanken 1' ,2  );
INSERT INTO "STEPHAN"."KURS" ("KURSBEZ" ,"KURSNR" ) VALUES ('Mathematik' ,3  );
INSERT INTO "STEPHAN"."KURS" ("KURSBEZ" ,"KURSNR" ) VALUES ('Verteilte IS' ,4  );

INSERT INTO "STEPHAN"."RAUM" ("RAUM" )
    VALUES ('CAP3'  );
INSERT INTO "STEPHAN"."RAUM" ("RAUM" ) VALUES ('CAP4'  );
INSERT INTO "STEPHAN"."RAUM" ("RAUM" ) VALUES ('HR3/409'  );
INSERT INTO "STEPHAN"."RAUM" ("RAUM" ) VALUES ('HRS3'  );

INSERT INTO "STEPHAN"."SEMESTER" ("SEMESTER" )
    VALUES ('WS 03/04'  );
INSERT INTO "STEPHAN"."SEMESTER" ("SEMESTER" ) VALUES ('SS 04'  );
INSERT INTO "STEPHAN"."SEMESTER" ("SEMESTER" ) VALUES ('WS 04/05'  );

INSERT INTO "STEPHAN"."STUDIENGANG" ("PRUEFUNGSAMTMITARB" ,"ID_STU" ,
    "SNAME" ,"BERATER" )
    VALUES ('' ,1 ,'Informatik' ,'A'  );
INSERT INTO "STEPHAN"."STUDIENGANG" ("PRUEFUNGSAMTMITARB" ,"ID_STU" ,"SNAME" ,"BERATER" ) VALUES ('' ,2 ,'Mathematik' ,'B'  );

INSERT INTO "STEPHAN"."EINGESCHRIEBENIN" ("ID_STU" ,"MATRNR" ,"SNAME" ,
    "VON" ,"BIS" )
    VALUES (1 ,1000 ,'Meier' ,TO_DATE('01.10.2000', 'dd-mm-yyyy') ,TO_DATE('30.09.2005', 'dd-mm-yyyy')  );
INSERT INTO "STEPHAN"."EINGESCHRIEBENIN" ("ID_STU" ,"MATRNR" ,"SNAME" ,"VON" ,"BIS" ) VALUES (2 ,1001 ,'Fritz' ,TO_DATE('01.10.2001', 'dd-mm-yyyy') ,TO_DATE('30.09.2006', 'dd-mm-yyyy')  );
INSERT INTO "STEPHAN"."EINGESCHRIEBENIN" ("ID_STU" ,"MATRNR" ,"SNAME" ,"VON" ,"BIS" ) VALUES (3 ,1004 ,'Friebe' ,TO_DATE('01.10.1995', 'dd-mm-yyyy') ,TO_DATE('30.09.2006', 'dd-mm-yyyy')  );

INSERT INTO "STEPHAN"."VORLESUNG" ("ID_VOR" ,"SEMESTER" ,"RAUM" ,
    "HAELT" ,"KURSNR" )
    VALUES ('1' ,'SS 04' ,'CAP3' ,1 ,1  );
INSERT INTO "STEPHAN"."VORLESUNG" ("ID_VOR" ,"SEMESTER" ,"RAUM" ,"HAELT" ,"KURSNR" ) VALUES ('2' ,'WS 03/04' ,'CAP3' ,2 ,2  );
INSERT INTO "STEPHAN"."VORLESUNG" ("ID_VOR" ,"SEMESTER" ,"RAUM" ,"HAELT" ,"KURSNR" ) VALUES ('3' ,'WS 04/05' ,'CAP4' ,2 ,3  );
INSERT INTO "STEPHAN"."VORLESUNG" ("ID_VOR" ,"SEMESTER" ,"RAUM" ,"HAELT" ,"KURSNR" ) VALUES ('4' ,'WS 04/05' ,'CAP3' ,1 ,2  );

INSERT INTO "STEPHAN"."MITARBEITER" ("VON" ,"BIS" ,"ID_MIT" ,"GEHALT" ,
    "ID_PRO" ,"MATRNR" )
    VALUES (TO_DATE('01.10.2003', 'dd-mm-yyyy') ,
    TO_DATE('', 'dd-mm-yyyy') ,1 ,5500 ,1 , NULL  );
INSERT INTO "STEPHAN"."MITARBEITER" ("VON" ,"BIS" ,"ID_MIT" ,"GEHALT" ,"ID_PRO" ,"MATRNR" ) VALUES (TO_DATE('01.10.1980', 'dd-mm-yyyy') ,TO_DATE('', 'dd-mm-yyyy') ,2 ,5000 ,2 , NULL  );
INSERT INTO "STEPHAN"."MITARBEITER" ("VON" ,"BIS" ,"ID_MIT" ,"GEHALT" ,"ID_PRO" ,"MATRNR" ) VALUES (TO_DATE('01.04.2004', 'dd-mm-yyyy') ,TO_DATE('', 'dd-mm-yyyy') ,3 ,5300 ,3 , NULL  );
INSERT INTO "STEPHAN"."MITARBEITER" ("VON" ,"BIS" ,"ID_MIT" ,"GEHALT" ,"ID_PRO" ,"MATRNR" ) VALUES (TO_DATE('01.01.2004', 'dd-mm-yyyy') ,TO_DATE('30.06.2004', 'dd-mm-yyyy') ,4 ,400 , NULL ,1000 );

INSERT INTO "STEPHAN"."INSTITUT" ("TELEFON" ,"RAUMSEKRETARIAT" ,
    "SPRECHER" ,"INAME" ,"ANSCHRIFT" ,"POSTKASTEN" ,
    "KOSTENSTELLE" )
    VALUES ('345' ,'402' ,'Rosi' ,'Institut für Informatik' ,'HRS
    3' ,'26016' ,100000  );
INSERT INTO "STEPHAN"."INSTITUT" ("TELEFON" ,"RAUMSEKRETARIAT" ,"SPRECHER" ,"INAME" ,"ANSCHRIFT" ,"POSTKASTEN" ,"KOSTENSTELLE" ) VALUES ('123' ,'5' ,'Klaus' ,'Mathematik' ,'Westring' ,'26016' ,250000  );
INSERT INTO "STEPHAN"."INSTITUT" ("TELEFON" ,"RAUMSEKRETARIAT" ,"SPRECHER" ,"INAME" ,"ANSCHRIFT" ,"POSTKASTEN" ,"KOSTENSTELLE" ) VALUES ('789' ,'7' ,'Klein' ,'Wirtschaftswissenschaften' ,'Westring' ,'26016' ,400000  );