\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}