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{color}
  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         backgroundcolor=\color{backcolour},
  56         basicstyle=\small\ttfamily,
  57         columns=flexible,
  58         breaklines=true,
  59         showspaces=false,
  60         showstringspaces=false,
  61         frame=single
  62 %       xleftmargin=0pt,
  63 %       xrightmargin=0pt,
  64 %       breakindent=0pt,
  65 %       resetmargins=true
  66 }
  67 \lstset{style=block}
  68 \usepackage{array}
  69 \newcolumntype{P}[1]{>{\centering\arraybackslash}p{#1}}
  70 \newcolumntype{M}[1]{>{\arraybackslash}p{#1}}
  71
  72
  73 %% HINWEIS!
  74 %%
  75 %% Die vorgegebene Formatierung der Loesung ist nur als
  76 %% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
  77 %% werden.
  78
  79
  80 \title{Exercise Sheet 3, 2019}
  81 \subtitle{6.0 VU Advanced Database Systems}
  82 \author{David Kaufmann (00700719)\\Jan VALES (00726236)}
  83
  84 \automark{section}
  85 \ohead{\pagemark}
  86 \makeatletter
  87 \chead{@author}
  88 \makeatother
  89 \cfoot{}
  90
  91 \begin{document}
  92 \maketitle
  93 \vspace{\fill}
  94 \subsubsection*{Version}
  95 \begin{footnotesize}
  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
  99
 100 \section*{Exercises}
 101 \begin{exercise}{Distributed Joins}{2}
 102 \input{main_1.tex}
 103 \end{exercise}
 104 \newpage
 105
 106 \begin{exercise}{Denormalization}{3}
 107 \input{main_2.tex}
 108 \end{exercise}
 109 \newpage
 110
 111 \begin{exercise}{Graph Databases}{5}
 112 \input{main_3.tex}
 113 \end{exercise}
 114 \newpage
 115
 116
 117 \end{document}