insert into professoren values 
(1, 'Meier', 'C4', -1234),
(2, 'Schmidt', 'C4', -1235),
(3, 'Hansen', 'C3', 1234),
(4, 'Peters', 'C3', 2345);

insert into assistenten values 
(101, 'Gollum', 1),
(102, 'Frodo', 1),
(103, 'Gimli', 1),
(201, 'Aragorn', 2),
(202, 'Merry', 2),
(301, 'Pippin', 3),
(401, 'Legolas', 4);

insert into hoersaele values
(1001, 500),
(1002, 300),
(1003, 240),
(1004, 210);

insert into vorlesungen values
(10001, 1, 'Mo', 1001),
(10002, 2, 'Di', 1002),
(10003, 2, 'Mi', 1003),
(10004, 3, 'Di', 1003),
(10005, 3, 'Fr', 1003),
(10006, 4, 'Fr', 1004);

insert into diplomanden values
(100001, 101, 'Thema 1'),
(100002, 201, 'Thema 2'),
(100003, 202, 'Thema 3');