\begin{frame} \frametitle{Foreign Key Constraints} Once the foreign key is declared, the \emph{the following update update operations violate the foreign key constraint}: \begin{alertblock}{} \emph{Insertion} into table \sql{Results}\\ without matching tuple in \sql{Students}% \begin{itemize} \smallskip \item DBMS \emph{rejects} the update \end{itemize} \smallskip \end{alertblock} \begin{alertblock}{} \emph{Deletion} from table \sql{Students} \\if the deleted tuple is referenced in \sql{Results} \begin{itemize} \smallskip \item DBMS \emph{rejects} the update, or \smallskip \item deletion \emph{cascades}, that is, tuples in \sql{Results} referencing the deleted tuple will also be deleted, or \smallskip \item the foreign key is \emph{set to null} in \sql{Results}. \end{itemize} Configure using: \sql{on delete cascade | set null | ...} \end{alertblock} \end{frame}