diff options
-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}))$ | ||