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