2020.01.28-A: Architektur-Datenbank

2020-01-28-A-Architektur.relax

group: 2020.01.28-A: Architektur-Datenbank 

bauwerk = {
id:number, name:string, ort:string, besucheranzahl:number
1, 'Candice', 'Bangladesh', 249
2, 'Kip', 'Budapest', 769
3, 'Garek', 'Bratislava', 497
4, 'Bradly', 'Boston', 871
5, 'Wynn', 'Boston', 317
6, 'Vance', 'Bratislava', 548
7, 'Obie', 'Budapest', 704
8, 'Brod', 'Budapest', 467
9, 'Lock', 'Boston', 751
10, 'Doro', 'Bratislava', 818
11, 'Gino', 'Budapest', 698
12, 'Tilly', 'Wien', 292
13, 'Fowler', 'Bangladesh', 664
14, 'Justinian', 'Budapest', 755
15, 'Mohammed', 'Wien', 600
16, 'Hendrick', 'Budapest', 169
17, 'Chadwick', 'Bratislava', 287
18, 'Marilin', 'Wien', 349
19, 'Vidovik', 'Wien', 600
20, 'Cathee', 'Boston', 744
}

architekt = {
id:number, name:string, geburtsjahr:number, todesjahr:number, nationalitaet:string
1, 'Hurleigh', 1923, 1982, 'BRD'
2, 'Ianthe', 1922, 1960, 'AUT'
3, 'Jory', 1923, 1981, 'USA'
4, 'Sadye', 1893, 1951, 'USA'
5, 'Kinsley', 1925, 1965, 'USA'
6, 'Otha', 1926, 1950, 'AUT'
7, 'Joni', 1918, 1966, 'USA'
8, 'Nita', 1899, 1953, 'USA'
9, 'Brittan', 1903, 1973, 'AUT'
10, 'Batholomew', 1909, 1967, 'AUT'
11, 'Rebeka', 1908, 1970, 'BRD'
12, 'Ede', 1910, 1951, 'USA'
13, 'Peggie', 1897, 1981, 'AUT'
14, 'Dory', 1899, 1970, 'BRD'
15, 'Westbrook', 1915, 1957, 'BRD'
16, 'Kinnie', 1915, 1965, 'USA'
17, 'Renae', 1910, 1966, 'BRD'
18, 'Jarrett', 1917, 1985, 'USA'
19, 'Mabelle', 1922, 1956, 'BRD'
20, 'Audie', 1910, 1966, 'BRD'
21, 'Dunc', 1896, 1968, 'BRD'
22, 'Trixie', 1899, 1973, 'BRD'
23, 'Allen', 1907, 1955, 'USA'
24, 'Vergil', 1925, 1963, 'AUT'
25, 'Delano', 1904, 1961, 'USA'
26, 'Guillaume', 1927, 1974, 'BRD'
27, 'Marleen', 1925, 1979, 'BRD'
28, 'Auguste', 1894, 1967, 'AUT'
29, 'Aleta', 1915, 1963, 'AUT'
30, 'Rriocard', 1892, 1963, 'BRD'
}

erstellt = {
id_bauwerk:number, id_architekt:number, beginn_jahr:number, ende_jahr:number, kosten:number
3, 12, 1843, 1918, 2329585
3, 6, 1822, 1946, 2819450
3, 1, 1822, 1946, 2819450
17, 12, 1804, 1938, 4041240
8, 18, 1805, 1977, 4849114
12, 6, 1810, 1979, 1277175
9, 12, 1804, 1998, 3232593
13, 6, 1835, 1921, 856834
14, 12, 1837, 1980, 2537721
5, 6, 1849, 1916, 4049893
10, 6, 1845, 1949, 4566285
1, 6, 1845, 1949, 235224
1, 10, 1845, 1949, 235224
}