gezundhait

select * from adress ;

show columns from adress ;

select name, vorname
from adress
where plz="183-0006";


create table patient(
nr integer primary key,
name char(20),
vorname char(20),
bundesland char(20),
plz char(10),
ort char(25),
strasse char(20),
hausnummer char(5),
telefon char(20),
krankenkasse char(25),
mailadresse char(25)
);



create table Arzt(
nr integer primary key,
titel char(20),
fachgebiet char(20),
name char(20),
vorname char(20),
bundesland char(20),
plz char(10),
ort char(25),
strasse char(20),
hausnummer char(5),
telefon char(20),
mailadresse char(25),
einkommen char(30)
);

create table krankenkasse(
nr integer primary key,
name char(20),
bundesland char(20),
gebiet char(20),
plz char(10),
ort char(25),
strasse char(20),
hausnummer char(5),
telefon char(20),
fax char(20),
mailadresse char(25)
);


insert into patient values(
"1","Moor","Tobias","Bayern","63927","Bürgstadt","Hauptstrasse","34","09371/72382","AOK-Miltenberg","Meyer-Tobias@gmx.de"
);

insert into patient values(
"2","Hennig","Sarah","Bayern","63897","Miltenberg","Schulweg","7","09371/55433","AOK-Miltenberg","h.sarah@gmail.com"
);

insert into patient values(
"3","Beyer","Andreas","Baden-Württemberg","74731","Rippberg","Landstraße","28","06286/67325","AOK-Walldürn","bbeeyyeerr@freenet.com"
);

insert into patient values(
"4","Massong","Monika","Bayern","63937","Weilbach","Brunnenweg","19","09373/34168","AOK-Amorbach","moni.ma@xmails.com"
);

insert into patient values(
"5","Helmstetter","Barbara","Bayern","97070","Würzburg","Mozartweg","85","0931/47637","DAK-Würzburg","b-helmstetter@web.de"
);

insert into patient values(
"6","Kretz","Thomas","Baden-Württemberg","74821","Mosbach","Mastweg","24","06263/742627","TK-Mosbach","kretz.t@freenet.com"
);

insert into patient values(
"7","Klett","Johannes","Bayern","63740","Aschaffenburg","Ludwigsallee","46","06028/404404","KKH-Aschaffenburg","Johannees-Klett@gmail.com"
);


insert into arzt values(
"1","Doktor","Zahnarzt","Äskulap","Serno","Bayern","63897","Miltenberg","Stadtweg","12","09371/64232","Serno@praxismil.de",
);




insert into krankenkasse values(
"1","AOK-Miltenberg","Bayern","Miltenberg","63897","Miltenberg","Winterheltstraße","10","09371/974323","09371/974323","miltenberg@aok.de"
);

insert into krankenkasse values(
"2","AOK-Amorbach","Bayern","Miltenberg","63916","Amorbach","Schloßplatz","1","09373/20460","09373/20460","amorbach@aok.de"
);


insert into patient values(
"8","Müller","Jan","Bayern","63897","Miltenberg","Streckfuss","12","09371/563451","AOK-Miltenberg","mjan@freenet.com"
);