ex1/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 %% HINWEIS!
  44 %%
  45 %% Die vorgegebene Formatierung der Loesung ist nur als
  46 %% Beispiel bzw. Hilfe gedacht und kann gerne geaendert
  47 %% werden.
  48
  49
  50 \title{Exercise Sheet 1, 2019}
  51 \subtitle{6.0 VU Advanced Database Systems}
  52 \author{David Kaufmann (00700719)\\Jan VALES (00726236)}
  53
  54 \automark{section}
  55 \ohead{\pagemark}
  56 \makeatletter
  57 \chead{@author}
  58 \makeatother
  59 \cfoot{}
  60
  61 \begin{document}
  62 \maketitle
  63 \vspace{\fill}
  64 \subsubsection*{Version}
  65 \begin{footnotesize}
  66 \url{https://git.somenet.org/priv/jan/adbs.git}\\
  67 This is revision: \textbf{\gitAbbrevHash} Document (.tex) compiled on: \textbf{\today}
  68 \end{footnotesize}\newpage
  69
  70
  71 \begin{exercise}{I/O}{1}
  72 \input{main_1.tex}
  73 \end{exercise}
  74 \newpage
  75
  76 \begin{exercise}{I/O in Query Plans}{2}
  77 \input{main_2.tex}
  78 \end{exercise}
  79 \newpage
  80
  81 \begin{exercise}{Selectivity}{3}
  82 \input{main_3.tex}
  83 \end{exercise}
  84 \newpage
  85
  86 \begin{exercise}{The Query Planner and You}{4}
  87 \input{main_4.tex}
  88 \end{exercise}
  89 \newpage
  90
  91 \begin{exercise}{Optimizing Queries}{5}
  92 \input{main_5.tex}
  93 \end{exercise}
  94 \newpage
  95
  96 \end{document}