32/296
\begin{frame}
  \frametitle{Functional Dependencies}
  
  Intuitively, there is a functional dependency 
  \begin{tcenter}
    $\sql{INAME} \to \sql{PHONE}$
  \end{tcenter}
  since the phone number \emph{only depends on the instructor}, not on other course data.
  \pause
          
  \begin{goal}{}
    This functional dependency  read as
    \begin{center}\vspace{-1ex}
      \emph{\sql{INAME} \{functionally, uniquely\} determines \sql{PHONE}}
    \end{center}
  \end{goal}
  \medskip
  \pause
  
  \begin{goal}{}
    Also \emph{\sql{INAME} is a determinant for \sql{PHONE}}\,.
  \end{goal}
  \smallskip
  \pause
  
  A \emph{determinant} is a `minimal' functional dependency.
  \medskip
  \pause

  A determinant is like a \emph{partial key:} 
  \begin{itemize}
  \item uniquely determines some attributes, but not all in general
  \end{itemize}
  \pause
  \begin{exampleblock}{}
    E.g. $\sql{INAME} \to \sql{TITLE}$ is \emph{not} satisfied.
  \end{exampleblock}
\end{frame}