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

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

  CONSTRAINT PK_STUDIENGANG_PINDEX  PRIMARY KEY(PINDEX)
);


CREATE TABLE Student(
  PINDEX  INTEGER,
  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_STUDENT_PINDEX  PRIMARY KEY(PINDEX),
  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 Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ichida', 'Simone', 'Blauer Weg 33', '09405', 'Gornau (im Erzgebirge)', 8, '02398/261811', 7); 






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 (  'Ichida', 'Simone', 'Blauer Weg 33', '09405', 'Gornau (im Erzgebirge)', 8, '02398/261811', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lanius', 'Egon', 'Nelkenstraße 62', '16306', 'Hohenselchow', 16, '09661/5472855', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rosner', 'Siegmund', 'Fichtenweg 21', '14641', 'Paulinenaue', 22, '05613/7358565', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Weigel', 'Lisa', 'Dorfstraße 80', '86660', 'Tapfheim', 23, '08657/1059806', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Schehrun', 'Daniel', 'Mühlweg 45', '24321', 'Klamp', 27, '06662/1762102', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ping', 'Steffen', 'August-Bebel-Straße 82', '06184', 'Gröbers', 32, '08943/3313721', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wegener', 'Kordula', 'Asternweg 35', '07407', 'Heilingen', 38, '01356/3361070', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'DeCarmo', 'Waldemar', 'Tulpenweg 83', '06547', 'Stolberg (im Harz)', 43, '09935/9201755', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Struppelpeter', 'Katrin', 'Marktplatz 71', '49843', 'Gölenkamp', 44, '04906/4707420', 18); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Vollmer', 'Sepp', 'Im Winkel 17', '39517', 'Bertingen', 49, '01238/4695458', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kruschwitz', 'Hannes', 'Jägerstraße 20', '56337', 'Kadenbach', 50, '02149/2791431', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Eggert', 'Adam', 'Veilchenweg 94', '03172', 'Grabko', 59, '07455/7186786', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Freier', 'Enrico', 'Im Winkel 22', '84091', 'Attenhofen', 67, '09473/6960270', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Greiff', 'Franz', 'Nelkenweg 19', '72116', 'Mössingen', 71, '01542/4393294', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Sharma', 'Olga', 'Erlenweg 13', '72379', 'Hechingen', 75, '05591/2599011', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Stolzenburg', 'Carlo', 'Lindenweg 57', '24326', 'Ascheberg', 79, '06501/4465193', 12); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Gupta', 'Fritz', 'Nordstraße 90', '98599', 'Brotterode', 84, '07378/1756984', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bohne', 'Eckehard', 'Blauer Weg 61', '63930', 'Neunkirchen', 89, '03260/3548338', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hubertus', 'Hans-Günther', 'Weidenweg 76', '18375', 'Wieck', 98, '01884/5813986', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Balzert', 'Avinder', 'Finkenweg 73', '31698', 'Lindhorst', 105, '09588/8271398', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wulff', 'Avinder', 'Heckenweg 43', '94261', 'Kirchdorf (im Wald)', 114, '02258/6639716', 12); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Linder', 'Lotte', 'Nordstraße 85', '29355', 'Beedenbostel', 116, '0435/1633217', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Jesing', 'Bianca', 'Lindenweg 35', '49688', 'Lastrup', 119, '04706/4047923', 9); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Daske', 'Magarete', 'Geschwister-Scholl-Straße 95', '66904', 'Brücken', 127, '02985/8751851', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hoyer', 'Ronny', 'Rosenweg 38', '55595', 'Bockenau', 128, '05490/1021439', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Block', 'Camita', 'Birkenstraße 10', '89604', 'Allmendingen', 134, '08094/5107326', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hamann', 'Hagen', 'Buchenweg 37', '06317', 'Lüttchendorf', 135, '06253/5237323', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Niwa', 'Claudio', 'Burgstraße 24', '06925', 'Löben', 144, '07200/775863', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Rössler', 'Judith', 'Ulmenweg 63', '06333', 'Hettstedt', 147, '01957/5153917', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kraus', 'Betrix', 'Mühlstraße 7', '32457', 'Porta Westfalica', 151, '06812/5785940', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Büchsel', 'Avinder', 'Schillerstraße 40', '23911', 'Groß Disnack', 159, '01959/2734779', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kühlhorn', 'Carlo', 'Gartenstraße 57', '84164', 'Moosthenning', 160, '0485/9820520', 3); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kaiser', 'Norbert', 'Burgstraße 91', '38557', 'Osloß', 168, '04111/3255698', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Gentsch', 'Ramona', 'Lindenstraße 60', '85386', 'Eching', 174, '03769/7461260', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Eggert', 'Kordula', 'Steinweg 20', '31707', 'Bad Eilsen', 178, '03589/5791667', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Cellini', 'Jutta', 'Sandweg 52', '17391', 'Stolpe', 179, '03608/9296782', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Miehe', 'Willy', 'Sudetenstraße 67', '89198', 'Westerstetten', 180, '07400/9811618', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hahn', 'Elvira', 'Ludwigstraße 66', '38877', 'Benneckenstein', 188, '07897/8179861', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Tyan', 'Sandra', 'Kastanienweg 92', '39264', 'Buhlendorf', 191, '085/3744680', 2); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Halbe', 'Dirk', 'Amselweg 71', '92266', 'Ensdorf', 198, '04081/4317411', 2); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bode', 'Käthe', 'Rotdornweg 76', '39579', 'Bellingen', 200, '07861/6461973', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lampadius', 'Marion', 'Rosenweg 88', '91233', 'Neunkirchen (am Sand)', 207, '08336/3252125', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Phong', 'Denise', 'Tulpenstraße 43', '06632', 'Schleberoda', 210, '09/4701357', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Strutz', 'Theresia', 'Wilhelmstraße 51', '37345', 'Stöckey', 213, '07711/5227432', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Luther', 'Uwe', 'Kirchenweg 52', '71397', 'Leutenbach', 216, '02997/2376422', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Heinrich', 'Sandra', 'Ahornstraße 27', '94486', 'Osterhofen', 220, '09952/3006323', 23); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Radinsky', 'Ronny', 'Grabenstraße 97', '89291', 'Holzheim', 223, '07695/4112795', 1); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fonda', 'Jana', 'Heideweg 26', '24980', 'Nordhackstedt', 227, '06810/6646042', 8); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Braun', 'Gerda', 'Steinweg 33', '55758', 'Bruchweiler', 229, '0488/5383561', 7); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kießlich', 'Hilde', 'Eichenstraße 41', '01594', 'Hirschstein', 231, '04411/4901437', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Caurich', 'Mike', 'Talstraße 17', '02763', 'Bertsdorf-Hörnitz', 232, '02474/1094330', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Arpke', 'Walbert', 'Birkenstraße 81', '24811', 'Ahlefeld', 238, '01150/8149355', 4); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Frahm', 'Adam', 'Kirchstraße 72', '24873', 'Havetoft', 242, '0698/9824930', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Foede', 'Marco', 'Friedrichstraße 93', '71364', 'Winnenden', 249, '04873/371183', 8); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Simon', 'Sepp', 'Blaue Allee 26', '67317', 'Altleiningen', 251, '03188/4198927', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Weber', 'Niels', 'Veilchenweg 35', '06773', 'Bergwitz', 257, '0819/7817289', 20); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Hein', 'Jens', 'Rober-Koch-Straße 15', '74385', 'Pleidelsheim', 259, '05780/5769875', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wernicke', 'Michelle', 'Meisenweg 80', '29451', 'Dannenberg (an der Elbe)', 266, '03294/9288987', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fisher', 'Wilhelm', 'jahnstraße 87', '36404', 'Martinroda', 269, '09907/8573677', 14); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kircheis', 'Elisabeth', 'Nelkenweg 34', '26632', 'Ihlow', 271, '0510/9398923', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ballhause', 'Rolf', 'Alte Dorfstraße 45', '76889', 'Steinfeld', 278, '08328/4180398', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Stehr', 'Timo', 'Tulpenweg 44', '9610', 'Quakenbrück', 282, '07474/9816049', 5); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Luther', 'Frieda', 'Nelkenweg 65', '89189', 'Neenstetten', 285, '06888/1290508', 19); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Mingram', 'Rudi', 'Ruhige Straße 21', '78098', 'Triberg', 293, '01886/7383760', 11); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wolf', 'Rudolf', 'Geschwister-Scholl-Straße 29', '84549', 'Engelsberg', 298, '0940/7033933', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Neubauer', 'Bernd', 'Feldweg 63', '85465', 'Langenpreising', 302, '022/8816791', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kolb', 'Karl-Peter', 'Rathausstraße 17', '26670', 'Uplengen', 305, '041/8442970', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Stary', 'Hagen', 'Wiesengrund 13', '06682', 'Schelkau', 312, '0289/7398256', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Becksmann', 'Ines', 'Finkenweg 29', '57612', 'Busenhausen', 321, '03866/8929641', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Fonda', 'Michael', 'Karlstraße 2', '27259', 'Varrel', 324, '03545/1898357', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zanker', 'Jens', 'Dorfplatz 86', '67278', 'Bockenheim', 328, '05591/7616118', 12); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Yanowski', 'Sepp', 'Lerchenstraße 94', '06308', 'Annarode', 336, '06277/441706', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Schütt', 'Gurpal', 'Leipziger Straße 18', '56191', 'Weitersburg', 339, '03316/8142090', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Peglow', 'Guido', 'Kurze Straße 48', '09405', 'Gornau (im Erzgebirge)', 348, '01728/5350462', 9); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Beckmann', 'Walbert', 'Asternweg 58', '97486', 'Königsberg (in Bayern)', 353, '05212/2580741', 26); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Heidenreich', 'Sonja', 'Lange Gasse 89', '25524', 'Bekmünde', 362, '07398/9901921', 10); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Draeger', 'Karla', 'Heckenweg 54', '01909', 'Großharthau', 363, '06101/5617050', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Schultze-Hagen', 'Anton', 'Wiesenweg 61', '54619', 'Lichtenborn', 367, '06027/14864', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Green', 'Britta', 'Friedrichstraße 43', '24802', 'Groß Vollstedt', 376, '03393/3725127', 12); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kettig', 'Nancy', 'Kastanienweg 71', '35647', 'Waldsolms', 381, '06048/5914613', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Komm', 'Virgine', 'Wilhelmstraße 11', '86504', 'Merching', 382, '05661/3614537', 17); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Sierks', 'Avinder', 'Im Wiesengrund 41', '76848', 'Schwanheim', 391, '073/6087517', 10); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Turianskyi', 'Cornelia', 'Nelkenweg 50', '83052', 'Bruckmühl', 393, '06370/8488092', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wild', 'Eckehard', 'Rosenweg 50', '25872', 'Wittbek', 394, '04260/6030369', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Meinhard', 'Marie', 'Neue Straße 85', '07987', 'Mohlsdorf', 395, '03306/9133178', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Knöfler', 'Steffen', 'Blaue Allee 30', '56412', 'Nentershausen', 396, '01507/5784988', 13); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Römer', 'Theresia', 'Fichtenweg 76', '04463', 'Großpösna', 399, '04389/5310295', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Baum', 'Betrix', 'Grabenstraße 24', '17111', 'Hohenbollentin', 407, '06807/5969505', 25); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Lampe', 'Kordula', 'Lindenstraße 6', '39326', 'Gutenswegen', 413, '06543/224099', 21); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Heuke', 'Andrea', 'Dorfplatz 86', '24594', 'Mörel', 422, '05885/5707317', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Wilpert', 'Andreas', 'Im Winkel 84', '56422', 'Wirges', 425, '05562/7223129', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Kunze', 'Victor', 'Lerchenstraße 35', '24894', 'Tolk', 432, '02233/3838639', 24); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Ferrari', 'Virgine', 'Dahlenweg 73', '57629', 'Müschenbach', 439, '05004/4540022', 15); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zenkner', 'Hans-Hermann', 'Kurze Straße 20', '24109', 'Melsdorf', 445, '08206/7612114', 16); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Eckert', 'Harro', 'Kirchberg 52', '54552', 'Utzerath', 448, '0811/5071654', 6); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Sharov', 'Christa', 'Geschwister-Scholl-Straße 65', '89284', 'Pfaffenhofen (an der Roth)', 453, '0783/4620272', 22); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Weiss', 'Michelle', 'Beethovenstraße 82', '99628', 'Guthmannshausen', 457, '08048/6145793', 28); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Bocker', 'Siegmund', 'Talstraße 96', '87662', 'Osterzell', 463, '01316/3154165', 27); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Zedler', 'Hanjo', 'Fliederstraße 63', '36323', 'Grebenau', 465, '05582/6256991', 8); 

insert into Student (NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  'Paulin', 'Kurt', 'Lindenstraße 38', '03205', 'Bischdorf', 472, '08774/4163955', 16); 

