Training
| Tabelle |
Spalten |
Fremdschlüssel |
| athlete |
(
aid
,
name
,
gender
)
|
|
| athlete_team |
(
aid
,
tid
,
gid
)
|
aid
»
athlete.aid
tid
»
team.tid
gid
»
games.gid
|
| discipline |
(
did
,
sid
,
name
)
|
sid
»
sport.sid
|
| games |
(
gid
,
year
,
season
,
city
)
|
|
| medals |
(
aid
,
gid
,
did
,
age
,
height
,
weight
,
medal
)
|
aid
»
athlete.aid
gid
»
games.gid
did
»
discipline.did
|
| sport |
(
sid
,
name
)
|
|
| team |
(
tid
,
noc
,
team
)
|
|
DB: PostgreSQL
Legende: TABELLE, PRIMÄRSCHLÜSSEL, FREMDSCHLÜSSEL
| year |
avg_medals_per_team |
| 2016 |
31 |
| 2014 |
23 |
| 2012 |
36 |
| 2010 |
25 |
| 2008 |
36 |
| 2006 |
32 |
| 2004 |
34 |
| 2002 |
32 |
| 2000 |
35 |
| 1998 |
25 |
| 1996 |
35 |
| 1994 |
18 |
| 1992 |
39 |
| 1988 |
43 |
| 1984 |
39 |
| 1980 |
38 |
| 1976 |
45 |
| 1972 |
32 |
| 1968 |
29 |
| 1964 |
26 |
| 1960 |
30 |
| 1956 |
28 |
| 1952 |
24 |
| 1948 |
24 |
| 1936 |
25 |
| 1932 |
23 |
| 1928 |
33 |
| 1924 |
33 |
| 1920 |
37 |
| 1912 |
22 |
| 1908 |
25 |
| 1906 |
18 |
| 1904 |
13 |
| 1900 |
19 |
| 1896 |
11 |
