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.

3. Update the revised model to answer the following: Which managers having savings accounts with the bank manage employees having savings accounts with the bank?

4. Indicate whether the following question can be answered by the original bank data model show above and explain why.

What is the average savings account balance for manufacturers having over 500 employees?

5. Indicate whether the following question can be answered by the original bank data model show above and explain why. How many women opened checking accounts on December 5, 2008?

\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}