%\RequirePackage{snapshot} % stats of included files: $filename.dep

\documentclass[a4paper]{scrartcl}
\usepackage[utf8]{inputenc}
\usepackage[naustrian]{babel}
\usepackage[T1]{fontenc}
\usepackage{amsmath,enumerate}
\usepackage{amsfonts}
\usepackage{graphicx}
\usepackage{multicol}
\usepackage{subfig}
\usepackage{float}
\usepackage{listings}
\lstset{language=sql,basicstyle=\small,keywordstyle=\ttfamily,morekeywords={REFERENCES,DEFERRED}}
\usepackage{tabularx}
\PassOptionsToPackage{hyphens}{url}\usepackage{hyperref}
\usepackage{enumitem}

\usepackage{scrpage2}
\pagestyle{scrheadings}

% includable git commit info
\usepackage[missing=run\ build.sh\ or\ gitinfohook.sh]{gitinfo}

\newcommand{\ul}[1]{\underline{#1}}
\newcommand{\ra}{\rightarrow}
\newcommand{\R}{\ensuremath{\mathcal{R}}}

\newtheorem{ex}{Aufgabe}
\newenvironment{exercise}[2]%
{\def\tmp{}%
	\ifx\points\tmp
	\begin{ex}
		\else
		\def\tmp{1}%
		\begin{ex}[#1][#2 Punkt\ifx\points\tmp\else e\fi]
			\fi
			\normalfont
		}%
		{\end{ex} %
}

\usepackage{listings}
\usepackage{color}

\definecolor{backcolour}{rgb}{0.95,0.95,0.92}
\lstdefinestyle{block}{
	backgroundcolor=\color{white},
	basicstyle=\small\ttfamily,
	columns=flexible,
	breaklines=true,
	showstringspaces=false
}
\lstdefinestyle{command}{
	backgroundcolor=\color{backcolour},
	basicstyle=\small\ttfamily,
	columns=flexible,
	breaklines=true,
	showspaces=false,
	showstringspaces=false,
	tabsize=2,
	frame=single
%	xleftmargin=0pt,
%	xrightmargin=0pt,
%	breakindent=0pt,
%	resetmargins=true
}
\lstset{style=block}
\usepackage{array}
\newcolumntype{P}[1]{>{\centering\arraybackslash}p{#1}}
\newcolumntype{M}[1]{>{\arraybackslash}p{#1}}


%% HINWEIS!
%% 
%% Die vorgegebene Formatierung der Loesung ist nur als
%% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
%% werden.


\title{Exercise Sheet 3, 2019}
\subtitle{6.0 VU Advanced Database Systems}
\author{David Kaufmann (00700719)\\Jan VALES (00726236)}

\automark{section}
\ohead{\pagemark}
\makeatletter
\chead{@author}
\makeatother
\cfoot{}

\begin{document}
\maketitle
\vspace{\fill}
\subsubsection*{Version}
\begin{footnotesize}
\url{https://git.somenet.org/priv/jan/adbs.git}\\
This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
\end{footnotesize}\newpage

\section*{Exercises}
\begin{exercise}{Distributed Joins}{2}
\input{main_1.tex}
\end{exercise}
\newpage

\begin{exercise}{Denormalization}{3}
\input{main_2.tex}
\end{exercise}
\newpage

\begin{exercise}{Graph Databases}{5}
\input{main_3.tex}
\end{exercise}
\newpage


\end{document}
