\begin{frame} \frametitle{ISA to Relational Model} \isaexample \pause \vspace{-.5ex} \begin{goal}{Method 1: hierarchy of tables} \begin{itemize} \item a table for the higher-level entity set \item a table for each lover-level entity set; include primary key of higher-level entity set and local attributes \end{itemize} \end{goal} \vspace{-.5ex} \begin{center} {\footnotesize\ttfamily \parbox{.2\textwidth}{ \colorbox{rellight}{% \begin{tabular}[t]{|r|r|} \multicolumn{2}{c}{Person} \\ \hline \hd{\key{id}} & \hd{name} \\ \hline 1 & James \\ 2 & Jones \\ \hline \end{tabular}% }}~\quad~% \parbox{.3\textwidth}{ \colorbox{rellight}{% \begin{tabular}[t]{|r|r|} \multicolumn{2}{c}{Employee} \\ \hline \hd{\key{id}$\;\to\;$Person} & \hd{salary} \\ \hline 1 & 4000 \\ \hline \end{tabular}% }\\[.25ex] \colorbox{rellight}{% \begin{tabular}[t]{|r|r|} \multicolumn{2}{c}{Customer} \\ \hline \hd{\key{id}$\;\to\;$Person} & \hd{credit-rating} \\ \hline 2 & 42 \\ \hline \end{tabular}% }} } \end{center} \emph{Minor drawback:} requires accessing multiple tables. \vspace{10cm} \end{frame}