\begin{frame}[fragile]
  \frametitle{SQL DDL (Data Definition Language)}
  
  \begin{code}{\textwidth}{Creating a table with constraints}
{\small
%###
\begin{verbatim}
create table Solved (
  id       int          auto_increment,
  name     varchar(40)  not null,
  homework numeric(2,0) not null,
  points   numeric(2,0) not null check (points <= 10),
  primary key (id)
); 
\end{verbatim}
%###
}
  \end{code}
  Note the data types and constraints!

  \begin{center}
  \scalebox{.8}{
  \begin{tabular}{| c | c | c | c |}
  \rowcolor{mblue!20}
  \mc{4}{Solved} 
  \\ \hline \rowcolor{mblue!40}
  \ul{id}  & name & homework & points 
  \\ \hline 
  \end{tabular}
  }
  \end{center}
  \pause
  
  \begin{exampleblock}{Creating a view}
{\small
%###
\begin{verbatim}
create view SolvedHomework as
    select id, name, homework 
    from   Solved;
\end{verbatim}
%###
}
  \end{exampleblock}
\end{frame}

\theme{Concurrent Access \& Transactions}