173/296
\begin{frame}
\frametitle{Splitting Relations}

It is important that this splitting transformation is
\emph{lossless}, i.e., that the original relation can be
reconstructed by a join.
$\begin{array}{r@{~~}l} \sql{CREATE} & \sql{VIEW COURSES (CRN, TITLE, INAME, PHONE)} \\ \sql{AS} \\ \sql{SELECT} & \sql{I.CRN, I.TITLE, I.INAME, P.PHONE} \\ \sql{FROM} & \sql{INTSTRUCTORS I, PHONEBOOK P} \\ \sql{WHERE} & \sql{I.INAME = P.INAME} \end{array}$