\begin{frame} \frametitle{Quiz} \begin{quiz}{\textwidth}{} A table with homework grades: \begin{center} {\ttfamily\footnotesize\centering \colorbox{rellight}{% \begin{tabular}{|r|r|r|r|r|r|} \multicolumn{6}{c}{HomeworkResults} \\ \hline \hd{sid} & \hd{first} & \hd{last} & \hd{exercise} & \hd{points} & \hd{maxPoints} \\ \hline 100 & Andrew & Smith & 1 & 9 & 10 \\ 101 & Dave & Jones & 1 & 8 & 10 \\ 102 & Maria & Brown & 1 & 10 & 10 \\ 101 & Dave & Jones & 2 & 11 & 12 \\ 102 & Maria & Brown & 2 & 10 & 12 \\ \hline \end{tabular}% }} \end{center} Which FDs should hold for this table in general? \begin{itemize} \pause \item $\sql{sid} \to \sql{first}, \sql{last}$ \pause \item $\sql{exercise} \to \sql{maxPoints}$ \pause \item $\sql{sid}, \sql{exercise} \to \sql{first}, \sql{last}, \sql{points}, \sql{maxPoints}$ \quad\iremark{(a key)} \end{itemize} \pause Identify FDs that hold in this table but not in general. \begin{itemize} \pause \item $\sql{first} \to \sql{last}$ \pause \item $\sql{first},\sql{last} \to \sql{sid}$ \quad\iremark{(prevents students with same name)} \end{itemize} \end{quiz} \end{frame}