--
-- Table structure for table `Personal`
--

CREATE TABLE Personal (
  Pid int not null auto_increment,
  Vorname varchar(30),
  Name varchar(30),
  Strasse varchar(30),
  Plz varchar(5),
  Ort varchar(30),
  Geburt date,
  Geschlecht varchar(1),
  Gehalt double,
  primary key(Pid)
);

--
-- Data for table `Personal`
--

INSERT INTO Personal VALUES ("1002",'Kai','Müller','Hallesche Str. 16','04838','Eilenburgn','1951-12-28','M',"3400.00");
INSERT INTO Personal VALUES ("1005",'Ede','Pfau','Nicoleiplatz 2','04232','Leipzig','1952-08-02','M',"4500.00");
INSERT INTO Personal VALUES ("1008",'Eiki','Taro','Musterstr. 6','09999','Musterdorf','1947-09-10','M',"5100.00");
INSERT INTO Personal VALUES ("1010",'Jürgen','Marx','Musterstr. 12','09999','Musterdorf','1956-03-22','M',"3677.00");
INSERT INTO Personal VALUES ("1015",'Eerik','Wicki','Boltern-Weg 3','22587','Hamburg','1950-07-09','M',"4533.00");
INSERT INTO Personal VALUES ("1016",'Ulrich','Müller','Weide Str. 2a','04838','Hohenpriessnitz','1951-01-02','M',"8999.00");
INSERT INTO Personal VALUES ("1017",'Klaus','Ecke','Schulze-Str. 11','04808','Wurzen','1955-04-13','M',"2555.00");
INSERT INTO Personal VALUES ("1100",'Kerstin','Gans','Hauptstr. 10','04838','Moerlitz','1961-03-19','W',"6000.00");
INSERT INTO Personal VALUES ("1101",'Guenter','Maus','Bergstrasse 5','06108','Halle/Saale','1948-12-21','M',"4500.00");
INSERT INTO Personal VALUES ("1112",'Hannes','Heik','Musterstr. 145','09999','Musterdorf','1961-02-06','M',"5600.00");
INSERT INTO Personal VALUES ("1113",'Karl','Seppa','Musterstr. 7','09999','Musterdorf','1963-06-24','M',"3400.00");
INSERT INTO Personal VALUES ("1114",'Karsten','Müller','Musterstr. 3','09999','Musterdorf','1963-07-12','M',"4900.00");
INSERT INTO Personal VALUES ("1429",'Torsten','Mieder','Hauptstrasse 16','04838','Laussig','1971-05-15','M',"5400.00");
INSERT INTO Personal VALUES ("1430",'Christine','Schwarz','Musterstr. 8','0999','Musterdorf','1948-04-24','W',"5420.00");
INSERT INTO Personal VALUES ("1431",'Birgit','Gemse','Bauernkoppeln 39','22393','Hamburg','1958-01-13','W',"1200.00");
INSERT INTO Personal VALUES ("1432",'Bernd','Jach','Suelldorferstr.','22589','Hamburg','1959-05-10','M',"2455.00");
INSERT INTO Personal VALUES ("1433",'Silvia','Munter','Treppe 7','22587','Hamburg','1952-04-28','W',"4555.00");
INSERT INTO Personal VALUES ("1434",'Joerg','Schön','Dorfweg 25 a','22589','Hamburg','1969-08-20','M',"5600.00");
INSERT INTO Personal VALUES ("1435",'Peter','Schock','Weststrasse 2','74323','Abstatt','1944-11-02','M',"4700.00");
INSERT INTO Personal VALUES ("1436",'Hans-Juergen','Sieg','Gerberstrasse 10','24568','Winsen','1947-05-22','M',"7000.00");
INSERT INTO Personal VALUES ("1437",'Christa','Renner','Weidenstrasse 26','15469','Halsenbek','1932-12-27','W',"3900.00");
INSERT INTO Personal VALUES ("1438",'Manfred','Stach','Gerbergasse 7','04105','Leipzig','1946-09-26','M',"3500.00");
INSERT INTO Personal VALUES ("1439",'Elfi','Kaufmann','Brandstrasse 15 e','04827','Gerichshain','1966-01-29','W',"3900.00");


--
-- Table structure for table `Teilnehmer`
--

CREATE TABLE Teilnehmer (
  Kid int not null,
  Pid int not null,
  Besucht varchar(2),
  primary key(Kid,Pid)
);

--
-- Dumping data for table `Teilnehmer`
--

INSERT INTO Teilnehmer VALUES ("1","1002",'Ja');
INSERT INTO Teilnehmer VALUES ("1","1017",'Ja');
INSERT INTO Teilnehmer VALUES ("1","1101",'Ja');
INSERT INTO Teilnehmer VALUES ("1","1429",'Ja');
INSERT INTO Teilnehmer VALUES ("2","1114",'Ja');
INSERT INTO Teilnehmer VALUES ("2","1439",'Ja');
INSERT INTO Teilnehmer VALUES ("3","1010",'Ja');
INSERT INTO Teilnehmer VALUES ("3","1015",'Ja');
INSERT INTO Teilnehmer VALUES ("3","1016",'Ja');
INSERT INTO Teilnehmer VALUES ("3","1017",'Ja');
INSERT INTO Teilnehmer VALUES ("4","1432",'Ja');
INSERT INTO Teilnehmer VALUES ("4","1433",'Ja');
INSERT INTO Teilnehmer VALUES ("5","1002",'Ja');
INSERT INTO Teilnehmer VALUES ("5","1435",'Ja');
INSERT INTO Teilnehmer VALUES ("5","1439",'Ja');
INSERT INTO Teilnehmer VALUES ("6","1005",'Ja');
INSERT INTO Teilnehmer VALUES ("6","1100",'Ja');
INSERT INTO Teilnehmer VALUES ("7","1430",'Ja');
INSERT INTO Teilnehmer VALUES ("7","1431",'Ja');
INSERT INTO Teilnehmer VALUES ("8","1438",'Ja');


--
-- Table structure for table `Kurs`
--

CREATE TABLE Kurs (
  Kid int not null auto_increment,
  Name varchar(30),
  Beginn date default NULL,
  Ende date,
  Kosten double,
  Vid int,
  Primary key(Kid)
);

--
-- Dumping data for table `Kurs`
--

INSERT INTO Kurs VALUES ("1",'ABA Schulung','1996-03-14','1996-03-14',"1600.00","1");
INSERT INTO Kurs VALUES ("2",'Laborschulung 2','1996-04-14','1996-04-16',"2000.00","4");
INSERT INTO Kurs VALUES ("3",'Teamtraining','1996-04-07','1996-04-08',"2100.00","5");
INSERT INTO Kurs VALUES ("4",'Grundkurs Excel','1996-11-25','1996-11-26',"1200.00","2");
INSERT INTO Kurs VALUES ("5",'Grundlagen PC/Windows 3.1','1996-12-13','1996-12-13',"900.00","3");
INSERT INTO Kurs VALUES ("6",'Grundkurs Word für Windows','1996-12-14','1996-12-15',"1800.00","4");
INSERT INTO Kurs VALUES ("7",'Grundkurs Powerpoint','1996-01-04','1996-01-04',"1200.00","4");
INSERT INTO Kurs VALUES ("8",'Projektmanagment','1996-11-07','1996-11-07',"1549.00","5");
INSERT INTO Kurs VALUES ("9",'Telefonmarketing-Training','1996-04-26','1996-04-27',"2034.00","5");
INSERT INTO Kurs VALUES ("10",'Personalplanung in der Praxis','1996-09-03','1996-09-04',"1220.00","7");
INSERT INTO Kurs VALUES ("11",'Arbeitszeugnisse formulieren','1996-09-18','1996-09-19',"2440.00","7");


--
-- Table structure for table `Veranstalter`
--

CREATE TABLE Veranstalter (
  Vid int not null auto_increment,
  Name varchar(30),
  Strasse varchar(30),
  Plz varchar(5),
  Ort varchar(30),
  primary key(Vid)
);

--
-- Dumping data for table `Veranstalter`
--

INSERT INTO Veranstalter VALUES ("1",'S&B Mannheim','Alsenweg 3','68305','Mannheim');
INSERT INTO Veranstalter VALUES ("2",'S&B München','Werner-Heisenberg-Allee 25','80939','München');
INSERT INTO Veranstalter VALUES ("3",'S&B Chemnitz','Reichenhainer Straße 154','09125','Chemnitz');
INSERT INTO Veranstalter VALUES ("4",'S&B Leipzig','Grimmaische Straße 6','04109','Leipzig');
INSERT INTO Veranstalter VALUES ("5",'S&B Berlin','Olympischer Platz 1','14053','Berlin');
INSERT INTO Veranstalter VALUES ("6",'S&B Rostock','Trotzenburger Weg 14','18057','Rostock');
INSERT INTO Veranstalter VALUES ("7",'S&B Essen','Hafenstraße 97a','45356','Essen');