Datenbanken ­ Blatt 04

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 @@
+---
+header-includes:
+        - \usepackage{amsmath}
+        - \usepackage{amssymb}
+---
+
+# Natural Join
+
+Zu $\land$.
+
+# Anfragen in relationaler Algebra
+
+a) $\pi_{\texttt{P.pname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P}))$
+b) $\pi_{\texttt{T.tnr}} \left ( \sigma_{\texttt{L.lname} = \text{Meier}} \left ( \texttt{L} \bowtie \texttt{LTP} \texttt{T} \right ) \right )$
+c) $\pi_{\texttt{T.tname}}(\sigma_{\texttt{P.ort} = \text{Berlin}}(\texttt{P} \bowtie \texttt{LTP} \bowtie \texttt{T}))$