gegebene Relationen
Kurs2
KursNr | Thema | Jahrgangsstufe |
---|---|---|
11 | Mechanik I | 11/I |
12 | Mechanik I | 11/I |
25 | Short Stories | 12/I |
3 | Datenbanken | 11/I |
KursLR
KursNr | Lehrer | Raum |
---|---|---|
11 | Müller I | 123 |
12 | Schulze | 124 |
27 | Bauer | 14 |
15 | Maier | 14 |
17 | Maier | 17 |
3 | Zange | 211 |
Abfrage
\text{Kurs2} \times \text{KursLR}Ergebnis
KursNR | Thema | Jahrgangsstufe | KursNr | Lehrer | Raum |
---|---|---|---|---|---|
11 | Mechanik I | 11/I | 11 | Müller I | 123 |
11 | Mechanik I | 11/I | 12 | Schulze | 124 |
11 | Mechanik I | 11/I | 27 | Bauer | 14 |
11 | Mechanik I | 11/I | 15 | Maier | 14 |
11 | Mechanik I | 11/I | 17 | Maier | 17 |
11 | Mechanik I | 11/I | 3 | Zange | 211 |
12 | Mechanik I | 11/I | 11 | Müller I | 123 |
12 | Mechanik I | 11/I | 12 | Schulze | 124 |
12 | Mechanik I | 11/I | 27 | Bauer | 14 |
12 | Mechanik I | 11/I | 15 | Maier | 14 |
12 | Mechanik I | 11/I | 17 | Maier | 17 |
12 | Mechanik I | 11/I | 3 | Zange | 211 |
25 | Short Stories | 12/I | 11 | Müller I | 123 |
25 | Short Stories | 12/I | 12 | Schulze | 124 |
25 | Short Stories | 12/I | 27 | Bauer | 14 |
25 | Short Stories | 12/I | 15 | Maier | 14 |
25 | Short Stories | 12/I | 17 | Maier | 17 |
25 | Short Stories | 12/I | 3 | Zange | 211 |
3 | Datenbanken | 11/I | 11 | Müller I | 123 |
3 | Datenbanken | 11/I | 12 | Schulze | 124 |
3 | Datenbanken | 11/I | 27 | Bauer | 14 |
3 | Datenbanken | 11/I | 15 | Maier | 14 |
3 | Datenbanken | 11/I | 17 | Maier | 17 |
3 | Datenbanken | 11/I | 3 | Zange | 211 |