15/77
\begin{frame}
  \frametitle{Relational Database Schemas}
  
  \begin{block}{Relational database schema}
    A \textbf{relational database schmema} $S$ defines
    \begin{itemize}
      \item a finite set of \textbf{relation names} $\{\,R_1, \dots, R_m\,\}$,
      \item a \textbf{relation schema} $\schema{R_i}$ for every relation $R_i$,
      \item a set of \textbf{integrity constraints} $C$ (defined later).
    \end{itemize}
    In summary, $S = (\, \{\,R_1, \dots, R_m\,\},\, \var{schema},\, C \,)$.  
  \end{block}
  \medskip
  
  \begin{exampleblock}{Example: relational database schema}
    \begin{itemize}
      \item relation names $\{\;\sql{Students},\; \sql{Exercises},\; \sql{Results}\;\}$
      \item relation schema for every relation name
        \begin{itemize}
          \item \headerStudents
          \item \headerExercises
          \item \headerResultsShort
        \end{itemize}
    \end{itemize}
  \end{exampleblock}
  \remark{Examples of integrity constraints: keys and foreign keys.}
\end{frame}