1 %\RequirePackage{snapshot} % stats of included files: $filename.dep
3 \documentclass[a4paper]{scrartcl}
4 \usepackage[utf8]{inputenc}
5 \usepackage[naustrian]{babel}
6 \usepackage[T1]{fontenc}
7 \usepackage{amsmath,enumerate}
14 \lstset{language=sql,basicstyle=\small,keywordstyle=\ttfamily,morekeywords={REFERENCES,DEFERRED}}
16 \PassOptionsToPackage{hyphens}{url}\usepackage{hyperref}
20 \pagestyle{scrheadings}
22 % includable git commit info
23 \usepackage[missing=run\ build.sh\ or\ gitinfohook.sh]{gitinfo}
25 \newcommand{\ul}[1]{\underline{#1}}
26 \newcommand{\ra}{\rightarrow}
27 \newcommand{\R}{\ensuremath{\mathcal{R}}}
29 \newtheorem{ex}{Aufgabe}
30 \newenvironment{exercise}[2]%
36 \begin{ex}[#1][#2 Punkt\ifx\points\tmp\else e\fi]
46 \definecolor{backcolour}{rgb}{0.95,0.95,0.92}
47 \lstdefinestyle{block}{
48 backgroundcolor=\color{white},
49 basicstyle=\small\ttfamily,
52 showstringspaces=false
54 \lstdefinestyle{command}{
55 backgroundcolor=\color{backcolour},
56 basicstyle=\small\ttfamily,
60 showstringspaces=false,
69 \newcolumntype{P}[1]{>{\centering\arraybackslash}p{#1}}
70 \newcolumntype{M}[1]{>{\arraybackslash}p{#1}}
75 %% Die vorgegebene Formatierung der Loesung ist nur als
76 %% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
80 \title{Exercise Sheet 3, 2019}
81 \subtitle{6.0 VU Advanced Database Systems}
82 \author{David Kaufmann (00700719)\\Jan VALES (00726236)}
94 \subsubsection*{Version}
96 \url{https://git.somenet.org/priv/jan/adbs.git}\\
97 This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
98 \end{footnotesize}\newpage
101 \begin{exercise}{Distributed Joins}{2}
106 \begin{exercise}{Denormalization}{3}
111 \begin{exercise}{Graph Databases}{5}