\documentclass{vldb}
\usepackage{graphicx}


\begin{document}

% ****************** TITLE ****************************************

\title{Assignment 1 - <DBMS NAME>}

% ****************** AUTHORS **************************************

\numberofauthors{3} 

\author{
% 1st. author
\alignauthor Student One
% 2nd. author
\alignauthor Student Two
% 3rd. author
\alignauthor Student Three
}


\maketitle

\section{Begin and commit.}

Install your team's DBMS. (At this point locally, on your personal computer. We're working on a server setup.) Answer the following question:

\begin{itemize}
\item What are the keywords to manually begin and commit a transaction in your system? Give an example.
\end{itemize}

Sample SQL code formatting:

\begin{verbatim}
BEGIN;
SELECT * FROM a WHERE b=10;
COMMIT;
\end{verbatim}

\section{Isolation levels.}

The ISO standard specifies certain isolation levels which should be implemented in a DBMS. Answer the following questions:

\begin{itemize}
\item Are all isolation levels specified in the ISO standard implemented in your DBMS?
\item What is the default isolation level in your DBMS?
\item How to manually specify a certain isolation level in your DBMS?
\end{itemize}

\section{Phenomena.}

Consider the three undesired phenomena defined by the ISO standard regarding concurrency. For each phenomenon, provide a minimal example that triggers the phenomenon if the isolation level is too low (1 point for each phenomenon).

\end{document}
