12/77
\begin{frame}
  \frametitle{Relation Schema}

  \begin{block}{Relation schema}
    A \textbf{relation schema} $s$ (of a single relation)
    defines

    \begin{itemize}
    \item a (finite) sequence $A_1, \dots, A_n$ of distinct \textbf{attribute names},
    \smallskip
    
    \item for each attribute $A_i$ a \emph{data type} (or \textbf{domain}) $D_i$.
    \end{itemize}
    A relation schema can be written as 
    \begin{talign}
      s = (A_1:D_1, \dots, A_n:D_n)
    \end{talign}
  \end{block}
  %Let $\var{dom}(A_i) = \dom{D_i}$ be the set of possible values for $A_i$.
  \smallskip
    
  \structureExercises
  
  \begin{code}{1\textwidth}{Creating a relation schema in SQL}
  \small
  \BUseVerbatim{createtable}
  \end{code}
\end{frame}