CREATE TABLE DBVERSION(
  DBVERSION  INTEGER  DEFAULT 1,
  DBDATE  TEXT  DEFAULT '01.01.2023',
  BEM  TEXT  DEFAULT 'Initialisierung'
);


CREATE TABLE Student(
  PINDEX  COUNTER,
  NACHNAME  TEXT DEFAULT='',
  VORNAME  TEXT DEFAULT='',
  STRASSE  TEXT DEFAULT='',
  PLZ  TEXT DEFAULT='',
  ORT  TEXT DEFAULT='',
  MNR INTEGER DEFAULT=0,
  TELNR  TEXT DEFAULT='',
  STDGINDEX INTEGER,

  CONSTRAINT PK_PINDEX  PRIMARY KEY(PINDEX)
);


CREATE TABLE Studiengang(
  PINDEX  COUNTER,
  NAME  TEXT,
  FB  TEXT,

  CONSTRAINT PK_PINDEX  PRIMARY KEY(PINDEX)
);


ALTER TABLE Student ADD CONSTRAINT
 FK_Studiengang_Student FOREIGN KEY(STDGINDEX) REFERENCES Studiengang(PINDEX);


insert into DBVERSION(DBVERSION, dbdate, BEM)
 Values(1, '19.01.2023', 'Initialisierung');


insert into Studiengang ( NAME, FB)
 VALUES (  'Informatik', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Informatik_E_Administration', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Ingenieurpädagogik', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Medieninformatik', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Smartautomatisierung', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Verwaltungsdigitalisierung', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Wirtschaftsinformatik', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Wirtschaftsingenieurwesen', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Medien_und_Spielekonzeption', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Technisches_Innovationsmanagement', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Technisches_Innovationsmanagement_International', 'AI'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Öffentliche Verwaltung', 'VW'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Verwaltungsökonomie', 'VW'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Europäisches Verwaltungsmanagement (B.A.)', 'VW'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Public Management', 'VW'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'IT-ManagementVerwaltungsinformatik', 'VW'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Betriebswirtschaftslehre', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Tourismusmanagement', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Marketingmanagement', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Nachhaltiges Management', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'BWL/Dienstleistungsmanagement', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Wirtschaftspsychologie', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'International Business Studies', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'International Tourism Studies', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Business Consulting', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'FACT-Finance, Accounting, Controlling, Taxation & Law', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Konsumentenpsychologie und Marktforschung', 'W'); 

insert into Studiengang ( NAME, FB)
 VALUES (  'Tourism and Destination Management', 'W'); 

INSERT INTO Studiengang( NAME, FB)   VALUES('Chirugie', 'Medizin'); 
INSERT INTO Studiengang(NAME, FB)   VALUES( 'Neurologie', 'Medizin'); 


insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Stefan', 'Gerta', 'Nelkenstraße 85', '16909', 'Heiligengrabe', 5, '06204/6514859', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rohrbach', 'Björn', 'Albert-Schweitzer-Straße 34', '85298', 'Scheyern', 11, '07693/6299241', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Böttcher', 'Camita', 'Rathausplatz 11', '07778', 'Neuengönna', 14, '08835/9130573', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hubert', 'Sebastian', 'Talstraße 38', '16278', 'Welsow', 16, '06808/651922', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Schmidt', 'Elvira', 'Brunnenweg 37', '04880', 'Trossin', 21, '06052/7497376', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Becksmann', 'Peter', 'Mittelstraße 97', '16928', 'Sadenbeck', 29, '02902/6132182', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Cellini', 'Gisela', 'Bergstraße 81', '16247', 'Neugrimnitz', 38, '05668/5704283', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kallert', 'Christine', 'Am See 5', '57537', 'Forst', 41, '07335/7655321', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Linder', 'Hannes', 'Weizengrund 36', '14797', 'Kloster Lehnin', 45, '05338/9256405', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Clinton', 'Franklin', 'Erlenweg 92', '97355', 'Wiesenbronn', 52, '0862/6435124', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rauber', 'Ada', 'Kreuzweg 98', '06809', 'Roitzsch', 60, '07622/8412784', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Jürgens', 'Helene', 'Nordstraße 50', '16798', 'Zootzen', 62, '07006/2044393', 8); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Frahm', 'Heidrun', 'Fliederstraße 52', '67823', 'Unkenbach', 70, '0591/4072339', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kaßner', 'Malka', 'Brückenstraße 50', '19230', 'Bresegard', 74, '04357/4127204', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Gumm', 'Hanjo', 'Kreuzstraße 36', '99880', 'Hörselgau', 79, '06344/12835', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Volk', 'Carlo', 'Schwarzer Weg 46', '08468', 'Heinsdorfergrund', 86, '04960/4267879', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zander', 'Wolfgang', 'Jägerstraße 88', '25779', 'Kleve', 92, '0469/7892', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Büttner', 'Kurt', 'Sonnenstraße 6', '17459', 'Ückeritz', 93, '03995/3544424', 2); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Weihrauch', 'Andrea', 'Fichtenweg 62', '55469', 'Mutterschied', 98, '03385/1752528', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fritsche', 'Michael', 'Sonnenstraße 95', '27632', 'Cappel', 99, '06753/4920221', 10); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Stallmann', 'Heidi', 'Lerchenstraße 61', '06577', 'Gorsleben', 103, '02705/497993', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fieseler', 'Karlheinz', 'Kirchgasse 35', '23896', 'Nusse', 104, '06570/5907626', 12); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fischer', 'Ruth', 'Tannenstraße 51', '25524', 'Kollmoor', 111, '08423/6387069', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'May', 'Frank', 'Fichtenstraße 93', '19230', 'Bresegard', 117, '07330/274742', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lautsch', 'Alfred', 'Poststraße 12', '25709', 'Kaiser-Wilhelm-Koog', 123, '05927/6731966', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Phong', 'Hanjo', 'Dorfstraße 75', '56858', 'Peterswald-Löffelscheid', 127, '06502/5366816', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Böttcher', 'Harro', 'Buchenstraße 94', '18195', 'Zarnewanz', 136, '03621/1832879', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Moskwa', 'Sulakhan', 'Lindenstraße 53', '38855', 'Heudeber', 139, '02462/8673600', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Pundt', 'Lisa', 'Burgweg 34', '39606', 'Kossebau', 147, '08085/7350514', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Huber', 'Christine', 'Mörikestraße 18', '74912', 'Kirchardt', 151, '06281/8389471', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ryberg', 'Heiko', 'Friedhofsweg 87', '89584', 'Ehingen (an der Donau)', 160, '06945/7943899', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Boll', 'Friedrich', 'Schützenstraße 80', '72622', 'Nürtingen', 168, '08928/6393675', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kahn', 'Andrea', 'Mühlenweg 75', '24793', 'Brammer', 170, '04753/450392', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kircheis', 'Christine', 'Daimlerstraße 45', '15910', 'Pretschen', 177, '07390/3770700', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kraus', 'Joachim', 'Südstraße 20', '27624', 'Bad Bederkesa', 182, '0138/2636853', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Sklebe', 'Gildo', 'Weststraße 86', '16278', 'Gellmersdorf', 187, '07638/1519513', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Filter', 'Rosemarie', 'Am Friedhof 96', '18279', 'Lalendorf', 195, '07858/2456915', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Buntschuh', 'Brigitte', 'Kreuzweg 61', '68809', 'Neulußheim', 199, '02432/5923597', 2); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Markworth', 'Ada', 'Seestraße 15', '55576', 'Sprendlingen', 204, '05143/6109147', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zobel', 'Lisa', 'Erlenweg 21', '23911', 'Einhaus', 207, '08596/2744978', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Luther', 'Regine', 'Industriestraße 74', '26487', 'Neuschoo', 216, '07842/8760929', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lee', 'Heidrun', 'Siemensstraße 31', '54646', 'Hisel', 219, '04550/1756793', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Müller', 'Hilda', 'Kirchberg 45', '04936', 'Naundorf', 223, '07459/8883692', 10); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kurch', 'Alwin', 'Schulweg 9', '57610', 'Ingelbach', 227, '07629/742914', 8); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Peterson', 'Jana', 'Bismarkstraße 79', '74427', 'Fichtenberg', 230, '08136/4180376', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hamann', 'Franz', 'An der Kirche 71', '74676', 'Niedernhall', 231, '0863/8578333', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Roweder', 'Margot', 'Meisenweg 48', '96253', 'Untersiemau', 239, '06041/2080623', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ohm', 'Adam', 'Blaue Allee 7', '25764', 'Süderdeich', 242, '0177/9869259', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Masuhr', 'Annegret', 'Mühlweg 18', '17322', 'Bismark', 243, '06712/266175', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Haußmann', 'Kasimir', 'Nelkenweg 24', '18513', 'Gransebieth', 245, '09477/6858172', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Reckter', 'Claudio', 'Römerstraße 29', '15306', 'Vierlinden', 251, '03627/5284159', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Reitzig', 'Siegmund', 'Ulmenweg 88', '18236', 'Altenhagen', 258, '02145/951276', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Nielson', 'Gabriela', 'Lilienweg 58', '56858', 'Altlay', 262, '0389/8777202', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Reulecke', 'Elisabeth', 'Richard-Wagner-Straße 9', '06791', 'Möhlau', 266, '03367/6539250', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Weigel', 'Wilhelm', 'Flurstraße 95', '74597', 'Stimpfach', 272, '03967/8352203', 10); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Neu', 'Regine', 'Rathausstraße 17', '16356', 'Schönfeld', 274, '04811/6534497', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Semmler', 'Ingeborg', 'Eichenstraße 33', '94560', 'Offenberg', 278, '0487/7379716', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rohweder', 'Susanne', 'Rober-Koch-Straße 6', '17111', 'Nossendorf', 281, '09522/3106763', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Willmann', 'Virgine', 'Fichtenweg 47', '25813', 'Schwesing', 288, '01148/2433488', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kahra', 'Wolfgang', 'Am Hang 16', '83122', 'Samerberg', 292, '04437/4712218', 5); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bender', 'Harro', 'Marienstraße 46', '49843', 'Halle', 294, '0227/3234657', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hechler', 'Malte', 'Brunnenweg 61', '07407', 'Großkochberg', 302, '06672/5815298', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Johnson', 'Manuela', 'An der Kirche 35', '83043', 'Bad Aibling', 303, '08622/2960973', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Sierau', 'Denise', 'Drosselweg 21', '21493', 'Basthorst', 309, '0827/8332648', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Verdi', 'René', 'Am See 37', '14728', 'Havelaue', 311, '01131/4084318', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rohrbach', 'Christa', 'An der Kirche 76', '29482', 'Küsten', 317, '05539/3137192', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Nordstrom', 'Michelle', 'An der Post 58', '24802', 'Bokel', 319, '05509/1604922', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ziems', 'Ingeborg', 'Dahlenweg 47', '06618', 'Wethau', 326, '09846/5173620', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Schwarzenegger', 'Karla', 'Hohe Straße 79', '56867', 'Briedel', 335, '09845/6111621', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ferchland', 'Regina', 'Steinweg 65', '82327', 'Tutzing', 343, '05921/9720560', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Illing', 'Gerold', 'Am Friedhof 4', '15868', 'Ullersdorf', 345, '04601/5478641', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fleischer', 'Rolf', 'Grenzweg 92', '89297', 'Roggenburg', 348, '04449/146054', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Siegl', 'Michelle', 'Lindenweg 26', '16928', 'Kemnitz', 357, '0686/3482852', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Moskwa', 'Wolfgang', 'Lindenstraße 13', '27412', 'Tarmstedt', 362, '01495/2279538', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Liebe', 'Cindy', 'Tannenstraße 45', '56729', 'Luxem', 365, '0288/8441314', 2); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Geiger', 'Edith', 'Pfarrgasse 7', '08280', 'Aue', 371, '01236/7291072', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Oetker', 'Margott', 'Lindenallee 11', '39291', 'Parchau', 378, '09942/6610735', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rincker', 'Franz', 'An der Post 55', '36275', 'Kirchheim', 385, '06414/2103931', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Monet', 'Hannelore', 'Lindenweg 16', '06632', 'Schleberoda', 389, '08966/7080201', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Luther', 'Cornelia', 'Mittelstraße 94', '39343', 'Altenhausen', 393, '07350/9489679', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zenkner', 'Günter', 'Hölderlinstraße 93', '82194', 'Gröbenzell', 401, '07659/9809435', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Brennicke', 'Marion', 'Grüner Weg 99', '82409', 'Wildsteig', 409, '09937/8835015', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Meister', 'Freya', 'Fliederstraße 4', '25779', 'Kleve', 413, '08382/8247187', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Heinrich', 'Franklin', 'Bahnshofstraße 51', '14793', 'Buckautal', 419, '0489/6997911', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Geiger', 'Mike', 'Dieselstraße 42', '98553', 'Ahlstädt', 421, '06390/2559073', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Skiebe', 'Mario', 'Lindenweg 24', '06528', 'Edersleben', 422, '05948/7459456', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Richter', 'Gerta', 'Forstweg 2', '15806', 'Groß Machnow', 423, '02805/3038873', 5); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bahß', 'Diana', 'Römerstraße 30', '25868', 'Norderstapel', 426, '09445/6333854', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Killmann', 'Richard', 'Kiefernstraße 62', '56472', 'Nisterau', 433, '08026/9569060', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Klingert', 'Antje', 'Waldstraße 45', '31195', 'Neuhof', 440, '06745/8434041', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Matthey', 'Ilse', 'Hohe Straße 71', '23999', 'Insel Poel', 441, '077/53873', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hüber', 'Hans-Günther', 'Mühlgasse 24', '37318', 'Marth', 447, '05714/8089983', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hunter', 'Thoralf', 'Karlstraße 10', '19260', 'Bennin', 448, '01102/9519755', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Baustian', 'Lothar', 'Geschwister-Scholl-Straße 69', '99428', 'Daasdorf (am Berge)', 453, '02818/3378163', 5); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lambert', 'Hilda', 'Holunderweg 28', '17348', 'Groß Daberkow', 459, '01125/8381792', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Mikitta', 'Jens', 'Marktstraße 51', '89177', 'Ballendorf', 465, '063/3691879', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bobka', 'David', 'Kapellen Weg 79', '06785', 'Horstdorf', 472, '0870/4483629', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Tierpitz', 'Steffen', 'Schillerstraße 60', '19300', 'Steesow', 481, '04310/4785387', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Peterson', 'Carsten', 'Schwalbenweg 42', '38470', 'Parsau', 484, '06092/6497255', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hesse', 'Lothar', 'Akazienweg 86', '88339', 'Bad Waldsee', 487, '05356/3411593', 8); 

