ex3/main.tex

   1 %\RequirePackage{snapshot} % stats of included files: $filename.dep
   2
   3 \documentclass[a4paper]{scrartcl}
   4 \usepackage[utf8]{inputenc}
   5 \usepackage[naustrian]{babel}
   6 \usepackage[T1]{fontenc}
   7 \usepackage{amsmath,enumerate}
   8 \usepackage{amsfonts}
   9 \usepackage{graphicx}
  10 \usepackage{multicol}
  11 \usepackage{subfig}
  12 \usepackage{float}
  13 \usepackage{listings}
  14 \lstset{language=sql,basicstyle=\small,keywordstyle=\ttfamily,morekeywords={REFERENCES,DEFERRED}}
  15 \usepackage{tabularx}
  16 \PassOptionsToPackage{hyphens}{url}\usepackage{hyperref}
  17 \usepackage{enumitem}
  18
  19 \usepackage{scrpage2}
  20 \pagestyle{scrheadings}
  21
  22 % includable git commit info
  23 \usepackage[missing=run\ build.sh\ or\ gitinfohook.sh]{gitinfo}
  24
  25 \newcommand{\ul}[1]{\underline{#1}}
  26 \newcommand{\ra}{\rightarrow}
  27 \newcommand{\R}{\ensuremath{\mathcal{R}}}
  28
  29 \newtheorem{ex}{Aufgabe}
  30 \newenvironment{exercise}[2]%
  31 {\def\tmp{}%
  32         \ifx\points\tmp
  33         \begin{ex}
  34                 \else
  35                 \def\tmp{1}%
  36                 \begin{ex}[#1][#2 Punkt\ifx\points\tmp\else e\fi]
  37                         \fi
  38                         \normalfont
  39                 }%
  40                 {\end{ex} %
  41 }
  42
  43 \usepackage{listings}
  44 \usepackage{xcolor}
  45
  46 \definecolor{backcolour}{rgb}{0.95,0.95,0.92}
  47 \lstdefinestyle{block}{
  48         backgroundcolor=\color{white},
  49         basicstyle=\small\ttfamily,
  50         columns=flexible,
  51         breaklines=true,
  52         showstringspaces=false
  53 }
  54 \lstdefinestyle{command}{
  55         language=C,
  56         backgroundcolor=\color{backcolour},
  57         basicstyle=\small\ttfamily,
  58         columns=flexible,
  59         breaklines=true,
  60         showspaces=false,
  61         showstringspaces=false,
  62         tabsize=2,
  63         frame=single
  64 %       xleftmargin=0pt,
  65 %       xrightmargin=0pt,
  66 %       breakindent=0pt,
  67 %       resetmargins=true
  68 }
  69 \lstset{style=block}
  70 \usepackage{array}
  71 \newcolumntype{P}[1]{>{\centering\arraybackslash}p{#1}}
  72 \newcolumntype{M}[1]{>{\arraybackslash}p{#1}}
  73
  74
  75 %% HINWEIS!
  76 %%
  77 %% Die vorgegebene Formatierung der Loesung ist nur als
  78 %% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
  79 %% werden.
  80
  81
  82 \title{Exercise Sheet 3, 2019}
  83 \subtitle{6.0 VU Advanced Database Systems}
  84 \author{David Kaufmann (00700719)\\Jan VALES (00726236)}
  85
  86 \automark{section}
  87 \ohead{\pagemark}
  88 \makeatletter
  89 \chead{@author}
  90 \makeatother
  91 \cfoot{}
  92
  93 \begin{document}
  94 \maketitle
  95 \vspace{\fill}
  96 \subsubsection*{Version}
  97 \begin{footnotesize}
  98 \url{https://git.somenet.org/priv/jan/adbs.git}\\
  99 This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
 100 \end{footnotesize}\newpage
 101
 102 \section*{Exercises}
 103 \begin{exercise}{Distributed Joins}{2}
 104 \input{main_1.tex}
 105 \end{exercise}
 106 \newpage
 107
 108 \begin{exercise}{Denormalization}{3}
 109 \input{main_2.tex}
 110 \end{exercise}
 111 \newpage
 112
 113 \begin{exercise}{Graph Databases}{5}
 114 \input{main_3.tex}
 115 \end{exercise}
 116 \newpage
 117
 118
 119 \end{document}