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
projnr |
d_gehalt |
abweichung |
3 |
2000.0 |
408.7 |
23 |
1000.0 |
-591.3 |
1 |
233.3 |
-1358.0 |
4 |
3000.0 |
1408.7 |
6 |
100.0 |
-1491.3 |
7 |
1666.7 |
75.4 |
2 |
5000.0 |
3408.7 |