Training
Tables |
Columns |
Foreign Keys |
abteilung |
(
abtnr
,
abtname
,
budget
,
chefnr
)
|
chefnr » personal.persnr
|
akte |
(
persnr
,
datum
,
position
,
gehalt
)
|
persnr » personal.persnr
|
personal |
(
persnr
,
vname
,
nname
,
projnr
,
telefonnr
,
gehalt
)
|
projnr » projekt.projnr
|
projekt |
(
projnr
,
budget
,
abtnr
)
|
abtnr » abteilung.abtnr
|
DB: PostgreSQL
Explanation: TABLE, PRIMARY KEY, FOREIGN KEY
persnr |
vname |
nname |
projnr |
telefonnr |
gehalt |
1 |
Donald |
Duck |
1 |
1201 |
1000.00 |
2 |
Dagobert |
Duck |
1 |
1202 |
200.00 |
3 |
Zita |
Delle |
1 |
1203 |
50.00 |
4 |
Axel |
Nässe |
1 |
1203 |
50.00 |
5 |
Anna |
Bolika |
1 |
1203 |
50.00 |
6 |
Gustav |
Gans |
23 |
2201 |
2000.00 |
8 |
Daniel |
Düsentrieb |
2 |
2203 |
5000.00 |
10 |
Klaas |
Klever |
1 |
1204 |
50.00 |
21 |
Klaus |
Trophobie |
3 |
3201 |
2000.00 |
51 |
Rainer |
Wein |
6 |
6202 |
100.00 |
52 |
Rainer |
Zufall |
6 |
6203 |
100.00 |
71 |
Micky |
Maus |
3 |
3201 |
3000.00 |
72 |
Anna |
Nass |
3 |
3202 |
1000.00 |
73 |
Minni |
Maus |
3 |
3203 |
2000.00 |
81 |
Tick |
- |
7 |
5201 |
1500.00 |
82 |
Trick |
- |
7 |
5201 |
1500.00 |
83 |
Franz |
Gans |
7 |
5205 |
2000.00 |
84 |
Track |
- |
4 |
4201 |
2000.00 |
90 |
Klaus |
Trophobie |
4 |
4201 |
2000.00 |
91 |
Axel |
Schweiss |
4 |
4201 |
2000.00 |
93 |
Fenn |
Sterputz |
4 |
4203 |
2000.00 |