summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--ws2015/datenbanksysteme/blaetter/04/abgabe.md15
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---
2header-includes:
3 - \usepackage{amsmath}
4 - \usepackage{amssymb}
5---
6
7# Natural Join
8
9Zu $\land$.
10
11# Anfragen in relationaler Algebra
12
13a) $\pi_{\texttt{P.pname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P}))$
14b) $\pi_{\texttt{T.tnr}} \left ( \sigma_{\texttt{L.lname} = \text{Meier}} \left ( \texttt{L} \bowtie \texttt{LTP} \texttt{T} \right ) \right )$
15c) $\pi_{\texttt{T.tname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P} \bowtie \texttt{LTP} \bowtie \texttt{T}))$