14/224
\begin{frame}
  \frametitle{Attribute References}
  
  \structureStudentsResults
  \smallskip
  
  Let $R$ be a tuple variable and $A$ an attribute of $R$.
  \begin{goal}{}
    \emph{Attributes are referenced} in the form
    \begin{tcenter}
      $R\,.\,A$
    \end{tcenter}
    If $R$ is the \emph{only} tuple variable with attribute $A$, then it suffices
    \begin{tcenter}
      $A$
    \end{tcenter}
  \end{goal}
  \smallskip\pause
  
    
  For example,
  \begin{tcenter}
    \begin{code}{0.9\textwidth}{}
      \small
      \BUseVerbatim{query}
    \end{code}
  \end{tcenter}
  \begin{itemize}
    \item \sql{first}, \sql{last} can only refer to \sql{S}
    \item \sql{category}, \sql{number}, \sql{points} can only refer to \sql{R}
    \item \sql{sid} on its would be \emph{ambiguous} (could refer to \sql{S} or \sql{R})
  \end{itemize}
\end{frame}