CREATE TABLE StudentenGF(MatrNr INTEGER, Name VARCHAR(20), Semester INTEGER, Geschlecht CHAR, FakName VARCHAR(20));
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (24002, 'Xenokrates', 18, 'M', 'Philosophie');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (25403, 'Jonas', 12, 'W', 'Theologie');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (26120, 'Fichte', 10, 'W' , 'Philosophie');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (26830, 'Aristoxenos', 8, 'M', 'Philosophie');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (27550, 'Schopenhauer', 6, 'M', 'Philosophie');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (28106, 'Carnap', 3, 'W', 'Physik');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (29120, 'Theophrastos', 2, 'M', 'Physik');
INSERT INTO  StudentenGF(MatrNr, Name, Semester, Geschlecht, FakName) VALUES (29555, 'Feuerbach', 2, 'W', 'Theologie');

CREATE TABLE ProfessorenF(PersNr INTEGER NOT NULL, Name VARCHAR(20), Rang CHAR (2), Raum INTEGER, FakName varchar(20));
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2125, 'Sokrates', 'C4', 226, 'Philosophie');
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2126, 'Russel', 'C4', 232, 'Philosophie'); 
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2127, 'Kopernikus', 'C3', 310, 'Physik');
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2133, 'Popper', 'C3', 052, 'Philosophie');
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2134, 'Augustinus', 'C3', 309, 'Theologie');
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2136, 'Curie', 'C4', 036, 'Physik');
INSERT INTO  ProfessorenF(PersNr, Name, Rang, Raum, FakName) VALUES (2137, 'Kant', 'C4', 007, 'Philosophie');