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
| nname |
vname |
| Bolika |
Anna |
| Delle |
Zita |
| Duck |
Dagobert |
| Duck |
Donald |
| Düsentrieb |
Daniel |
| Elmann |
Heinz |
| Gans |
Franz |
| Gans |
Gitta |
| Gans |
Gustav |
| Klever |
Klaas |
| Maus |
Micky |
| Maus |
Minni |
| Nass |
Anna |
| Nässe |
Axel |
| Schweiss |
Axel |
| Sterputz |
Fenn |
| Trophobie |
Klaus |
| Trophobie |
Klaus |
| Wein |
Rainer |
| Zufall |
Rainer |
| - |
Tick |
| - |
Track |
| - |
Trick |
