CREATE TABLE DBVERSION(
  DBVERSION  INTEGER  DEFAULT 1,
  DBDATE  VARCHAR(10)  DEFAULT '01.01.2023',
  BEM  VARCHAR(100)  DEFAULT 'Initialisierung'
);


CREATE TABLE Student(
  PINDEX  INTEGER  NOT NULL,
  NACHNAME  VARCHAR(50) DEFAULT '',
  VORNAME  VARCHAR(50) DEFAULT '',
  STRASSE  VARCHAR(50) DEFAULT '',
  PLZ  VARCHAR(5) DEFAULT '',
  ORT  VARCHAR(50) DEFAULT '',
  MNR INTEGER DEFAULT 0,
  TELNR  VARCHAR(30) DEFAULT '',
  STDGINDEX INTEGER,

  CONSTRAINT PK_STUDENT_PINDEX  PRIMARY KEY(PINDEX)
);


CREATE TABLE Studiengang(
  PINDEX  INTEGER  NOT NULL,
  NAME  VARCHAR(100),
  FB  VARCHAR(50),

  CONSTRAINT PK_STUDIENGANG_PINDEX  PRIMARY KEY(PINDEX)
);



CREATE SEQUENCE SEQ;

ALTER SEQUENCE seq RESTART WITH 200;



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 (PINDEX, NAME, FB)
 VALUES (  1, 'Informatik', 'AI'); 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  1, 'Halbe', 'Thomas', 'Rotdornweg 51', '54668', 'Niederweis', 6, '06049/5504488', 21); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  2, 'Lüer', 'Angela', 'Geschwister-Scholl-Straße 95', '96346', 'Wallenfels', 13, '05994/4921441', 9); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  3, 'Lenz', 'Hilde', 'Wilhelmstraße 81', '23813', 'Blunk', 21, '05481/3036388', 1); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  4, 'Kloth', 'Grit', 'Friedrichstraße 87', '38889', 'Wienrode', 30, '0495/7849304', 28); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  5, 'Rothermund', 'Hartmut', 'Ruhige Straße 38', '98701', 'Großbreitenbach', 37, '04651/5736873', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  6, 'Heinrich', 'Heidrun', 'Neue Straße 48', '99869', 'Weingarten', 38, '03985/3574228', 1); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  7, 'Tschaikowsky', 'Arthur', 'Siemensstraße 44', '16306', 'Groß Pinnow', 40, '06259/1414547', 8); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  8, 'Klepel', 'Lieselotte', 'Weiherstraße 81', '78567', 'Fridingen (an der Donau)', 42, '08054/849940', 2); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  9, 'Gergs', 'Camita', 'Am Markplatz 93', '06780', 'Löberitz', 45, '08506/856740', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  10, 'Fisher', 'Gerda', 'Ludwigstraße 4', '56281', 'Schwall', 50, '09573/8968547', 26); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  11, 'Fahr', 'Siegmund', 'Ringstraße 39', '06254', 'Zöschen', 53, '04914/6826364', 6); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  12, 'Hausdorf', 'Katrin', 'Veilchenweg 48', '24598', 'Boostedt', 57, '09737/3886553', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  13, 'Züchner', 'Mario', 'Bergstraße 96', '96369', 'Weißenbrunn', 61, '08241/5254540', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  14, 'Bloch', 'Gurpal', 'Dahlenweg 98', '56379', 'Hömberg', 70, '02571/1297692', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  15, 'Pele', 'Thoralf', 'Kiefernstraße 83', '17509', 'Katzow', 73, '0517/1321735', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  16, 'Halbe', 'Regine', 'Lärchenweg 94', '08352', 'Raschau', 79, '09608/4513051', 2); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  17, 'Borrmann', 'Annelie', 'Steinstraße 26', '17153', 'Ritzerow', 87, '02704/17214', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  18, 'Rose', 'Sabine', 'Kirchstraße 51', '19294', 'Malliß', 91, '07/9032618', 13); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  19, 'Buntschuh', 'Holger', 'Falkenweg 99', '09517', 'Zöblitz', 99, '07735/5538357', 6); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  20, 'Gansen', 'Walbert', 'Teichstraße 75', '29339', 'Wathlingen', 104, '08499/2800729', 15); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  21, 'Foltan', 'Doreen', 'Rathausstraße 2', '92714', 'Pleystein', 112, '04362/2232370', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  22, 'Maier', 'Kurt', 'Schützenstraße 41', '16928', 'Steffenshagen', 113, '01752/8232397', 7); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  23, 'Micus', 'Nadja', 'Forstweg 88', '85445', 'Oberding', 120, '06730/82269', 26); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  24, 'Tutschka', 'Angela', 'Robert-Bosch-Straße 35', '39249', 'Gnadau', 123, '08451/3387349', 14); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  25, 'Kleine', 'Margott', 'Am Friedhof 26', '15848', 'Friedland', 130, '07117/7312067', 14); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  26, 'Hensel', 'Elisabeth', 'Forstweg 56', '15910', 'Pretschen', 139, '03177/7777971', 28); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  27, 'Senitz', 'André', 'Rotdornweg 88', '19372', 'Matzlow-Garwitz', 148, '09162/5484019', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  28, 'Schleußner', 'Horst', 'Sonnenstraße 51', '39606', 'Rossau', 149, '05518/3940667', 7); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  29, 'Mehlig', 'Lisa', 'Jägerstraße 19', '97769', 'Bad Brückenau', 151, '02265/3156378', 3); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  30, 'Billing', 'Richard', 'Marktplatz 67', '87700', 'Memmingen', 157, '02372/9687768', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  31, 'Klix', 'Steffi', 'Poststraße 26', '26180', 'Rastede', 164, '06512/8461202', 19); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  32, 'Kerger', 'Daniel', 'Tulpenstraße 35', '04928', 'Kahla', 166, '06856/3250215', 25); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  33, 'Klix', 'Freya', 'Ulmenweg 75', '97788', 'Neuendorf', 172, '08990/6869754', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  34, 'Kost', 'Willi', 'Lindenweg 38', '02977', 'Hoyerswerda', 177, '04949/6041353', 17); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  35, 'Stahnke', 'Christl', 'Grüner Weg 21', '99428', 'Ottstedt (am Berge)', 181, '04699/4913665', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  36, 'Dorge', 'Malka', 'Am Anger 65', '18442', 'Pantelitz', 185, '06922/2898030', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  37, 'Borrmann', 'Lothar', 'Am Sportplatz 34', '66851', 'Bann', 191, '01514/734081', 9); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  38, 'Wuttke', 'Ruth', 'Dorfplatz 14', '94336', 'Hunderdorf', 198, '05711/1457860', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  39, 'Weber', 'Malka', 'Kirchgasse 92', '54662', 'Speicher', 201, '034/2078555', 3); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  40, 'Tute', 'Bärbel', 'Gartenstraße 49', '97618', 'Unsleben', 202, '05919/5179634', 2); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  41, 'Jürgens', 'Sonja', 'Amselweg 20', '63931', 'Kirchzell', 204, '0209/1730511', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  42, 'Schneewittchen', 'Klara', 'Kirchenweg 81', '55758', 'Langweiler', 209, '07832/4800521', 20); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  43, 'Ichida', 'Rosemarie', 'Bergweg 14', '71720', 'Oberstenfeld', 211, '04819/2627410', 25); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  44, 'Sierks', 'Jutta', 'Tulpenweg 29', '56368', 'Berghausen', 217, '06870/392671', 21); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  45, 'Montgomery', 'Alfred', 'Grenzweg 25', '06537', 'Kelbra', 224, '03254/8259018', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  46, 'Schütz', 'Timo', 'Am Anger 26', '24211', 'Honigsee', 225, '03950/4695097', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  47, 'Fritsche', 'Marco', 'Tulpenweg 62', '24329', 'Grebin', 234, '02462/5958507', 26); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  48, 'Rockstroh', 'Arthur', 'Dorfplatz 25', '87766', 'Memmingerberg', 241, '07603/6494998', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  49, 'Kluge', 'Frieda', 'Forstweg 48', '56291', 'Laudert', 244, '07388/8823419', 9); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  50, 'Mahnkopf', 'Friedrich', 'Kirchstraße 91', '27432', 'Alfstedt', 252, '08105/2789785', 9); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  51, 'Pfeiffer', 'Mario', 'Pappelweg 45', '28865', 'Lilienthal', 258, '08359/4689338', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  52, 'Pape', 'Marie', 'Weidenweg 63', '47509', 'Rheurdt', 264, '06391/1310465', 2); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  53, 'Maimom', 'Katrin', 'Ulmenstraße 57', '19065', 'Godern', 271, '06240/7412746', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  54, 'Willmann', 'Adam', 'Am Berg 7', '03149', 'Wiesengrund', 280, '04693/2951547', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  55, 'Siegl', 'André', 'Hölderlinstraße 7', '16306', 'Woltersdorf', 281, '03488/8995263', 5); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  56, 'Bess', 'Senta', 'Sonnenstraße 44', '19294', 'Karenz', 289, '07655/4947637', 22); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  57, 'Schmietendorf', 'Niels', 'Wacholderweg 87', '56412', 'Görgeshausen', 296, '0832/9364335', 20); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  58, 'Kolb', 'Steffen', 'Mörikestraße 14', '06809', 'Petersroda', 299, '07805/7759032', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  59, 'Idle', 'Volker', 'Kirchgasse 62', '39615', 'Krüden', 306, '05785/424744', 24); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  60, 'Hollerith', 'Sven', 'Lindenweg 97', '09627', 'Hilbersdorf', 312, '01994/4225264', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  61, 'Baustian', 'Alexander', 'Schloßstraße 76', '36404', 'Völkershausen', 314, '03202/3500501', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  62, 'Lauda', 'Franklin', 'Ringstraße 63', '54340', 'Schleich', 320, '04220/7035451', 1); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  63, 'Kraus', 'Carsten', 'Kantstraße 20', '06909', 'Trebitz', 328, '08696/9376569', 13); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  64, 'Stary', 'Franklin', 'Wiesenweg 56', '03205', 'Bronkow', 335, '05313/2210735', 20); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  65, 'Bregulla', 'Virgine', 'Grüner Weg 93', '96184', 'Rentweinsdorf', 338, '08681/934661', 7); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  66, 'Fantu', 'Enrico', 'Grenzweg 75', '94167', 'Tettenweis', 341, '05446/8987444', 18); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  67, 'Wetterich', 'Gildo', 'Waldstraße 41', '79235', 'Vogtsburg (im Kaiserstuhl)', 349, '06727/9880908', 15); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  68, 'Foede', 'Lieselotte', 'Erlenweg 55', '19399', 'Goldberg', 353, '09752/9657615', 26); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  69, 'Hunter', 'Regina', 'Sonnenstraße 73', '15848', 'Tauche', 354, '06065/8046670', 25); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  70, 'Büttner', 'Egon', 'Lilienweg 56', '76756', 'Bellheim', 360, '0784/6059053', 8); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  71, 'Kriebel', 'Helene', 'Blumenweg 67', '49477', 'Ibbenbüren', 369, '07440/1968202', 20); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  72, 'Block', 'Petra', 'Brückenstraße 72', '19288', 'Ludwigslust', 377, '03555/2392171', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  73, 'Kuche', 'Renate', 'Mark 48', '55435', 'Gau-Algesheim', 383, '09481/885286', 10); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  74, 'Bregulla', 'Guido', 'Sonnenstraße 98', '17039', 'Sponholz', 392, '01514/1982578', 17); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  75, 'Krume', 'Betrix', 'Blauer Weg 86', '63538', 'Großkrotzenburg', 397, '03855/6518042', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  76, 'Finke', 'Reinhard', 'Burgstraße 51', '23896', 'Walksfelde', 400, '07195/3051325', 8); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  77, 'Agile', 'Sepp', 'Lerchenstraße 94', '17498', 'Wackerow', 406, '05952/2868886', 11); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  78, 'Tutschka', 'Ursula', 'Hochstraße 31', '16244', 'Altenhof', 411, '02009/8282977', 24); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  79, 'Dally', 'Avinder', 'Dahlenweg 43', '06242', 'Krumpa', 419, '07952/5912093', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  80, 'Schalli', 'Frank', 'Flurstraße 88', '99735', 'Hainrode', 426, '06596/1337989', 7); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  81, 'Dumke', 'Hans-Hermann', 'Dahlenweg 32', '55471', 'Kümbdchen', 432, '01462/4986834', 9); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  82, 'Klinner', 'Adam', 'Stettiner Straße 9', '56412', 'Stahlhofen', 439, '04907/674314', 13); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  83, 'Lohmann', 'Ines', 'Goethestraße 99', '57629', 'Merkelbach', 443, '06227/1610228', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  84, 'Micus', 'Helene', 'Parkstraße 91', '15328', 'Küstriner Vorland', 445, '02929/5225103', 3); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  85, 'Reckter', 'Bodo', 'Forstweg 57', '86415', 'Mering', 454, '05176/97320', 23); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  86, 'Green', 'Friedrich', 'Pfarrgasse 3', '63825', 'Blankenbach', 462, '02370/8390356', 24); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  87, 'Duve', 'Brigitte', 'Weizengrund 10', '97355', 'Rüdenhausen', 464, '04607/739431', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  88, 'Risch', 'Harro', 'Im Wiesengrund 12', '99947', 'Tottleben', 470, '05843/1278657', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  89, 'Bohne', 'Thoralf', 'Friedrich-Ebert-Straße 58', '38471', 'Rühen', 479, '05483/4917303', 4); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  90, 'Agile', 'Judith', 'Kreuzstraße 11', '39524', 'Hohengöhren', 480, '03438/6116948', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  91, 'Tanenbaum', 'Sandra', 'Stettiner Straße 44', '23824', 'Tensfeld', 485, '08061/6826018', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  92, 'Grünberg', 'Ilse', 'Oststraße 7', '37345', 'Weißenborn-Lüderode', 493, '06946/3420163', 26); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  93, 'Tafelberg', 'Uwe', 'Veilchenweg 57', '24161', 'Altenholz', 499, '0324/4439882', 18); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  94, 'Kannenberg', 'Anita', 'Bergweg 32', '19374', 'Herzberg', 504, '06248/2401240', 25); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  95, 'Herntrich', 'Ingeborg', 'Kirchgasse 82', '17375', 'Liepgarten', 513, '04217/6139647', 1); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  96, 'Stackfelth', 'Marlis', 'Nordstraße 95', '19230', 'Hülseburg', 520, '01644/2646871', 16); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  97, 'Fahldieck', 'Margott', 'Lessingstraße 37', '90602', 'Pyrbaum', 529, '08499/561629', 14); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  98, 'Gentsch', 'Ronald', 'Kurze Straße 91', '17166', 'Dalkendorf', 537, '0115/4329903', 24); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  99, 'Wendlang', 'Klara', 'Finkenweg 35', '97253', 'Gaukönigshofen', 546, '05735/8475445', 27); 

insert into Student (PINDEX, NACHNAME, VORNAME, STRASSE, PLZ, ORT, MNR, TELNR, STDGINDEX)
 VALUES (  100, 'Körbs', 'Liselotte', 'Friedensstraße 64', '87629', 'Füssen', 547, '09357/7088989', 19); 

