4.2c Enhancing a Data Model

Assume the following problems are models for a bank. Derive the models for the following problems by adding to the model shown below.

1. Update this model so that you can answer the following question: What percentage of the bank's checking account holders are bank employees? (Hint: Add an Employee object set to the model first.)

2. Update the revised model (from question 1) to answer the following question: How many tellers have savings accounts with the bank?

\begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Customer } \\ \hline CustomerNumberAddress \\ \cline { 4 - 5 } \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Checking Account } \\ \hline & Monthly Fee \\ \hline & Interest Rate \\ \hline \end{tabular}