diff options
Diffstat (limited to 'ws2015/datenbanksysteme/blaetter')
| -rw-r--r-- | ws2015/datenbanksysteme/blaetter/04/abgabe.md | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/ws2015/datenbanksysteme/blaetter/04/abgabe.md b/ws2015/datenbanksysteme/blaetter/04/abgabe.md new file mode 100644 index 0000000..708a249 --- /dev/null +++ b/ws2015/datenbanksysteme/blaetter/04/abgabe.md | |||
| @@ -0,0 +1,15 @@ | |||
| 1 | --- | ||
| 2 | header-includes: | ||
| 3 | - \usepackage{amsmath} | ||
| 4 | - \usepackage{amssymb} | ||
| 5 | --- | ||
| 6 | |||
| 7 | # Natural Join | ||
| 8 | |||
| 9 | Zu $\land$. | ||
| 10 | |||
| 11 | # Anfragen in relationaler Algebra | ||
| 12 | |||
| 13 | a) $\pi_{\texttt{P.pname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P}))$ | ||
| 14 | b) $\pi_{\texttt{T.tnr}} \left ( \sigma_{\texttt{L.lname} = \text{Meier}} \left ( \texttt{L} \bowtie \texttt{LTP} \texttt{T} \right ) \right )$ | ||
| 15 | c) $\pi_{\texttt{T.tname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P} \bowtie \texttt{LTP} \bowtie \texttt{T}))$ | ||
