4.2t 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.
Your teacher will provide instructions on how to submit your homework – either with paper submission or electronic file upload.
Possible options include:
- Hand drawn solutions – can be a paper submission or scanned and uploaded as a pdf file.
- Computer based drawing tool – can be a printed submission, or saved as a pdf file or as jpg images and inserted into a Word Document – and uploaded.
2.1 A powerful and free diagramming tool that runs in a browser is available at Lucid Chart: Saves the data in Lucid Chart Cloud. https://www.lucidchart.com/ Links to an external site.
2.2 A popular Chrome App Plug-In drawing tool called Gliffy – (Requires Chrome) Can save data on local drive. https://chrome.google.com/webstore/detail/gliffy-diagrams/bhmicilclplefnflapjmnngmkkkkpfad?hl=enLinks to an external site.
2.3 Some teachers prefer Microsoft Visio. You can get a trial version here: Not web based. All work and data saved locally. https://products.office.com/en-us/visio/visio-prof…Links to an external site
- What percentage of the bank’s checking account holders are bank employees? (Hint: Add an Employee object set to the model first.)
- How many tellers have savings accounts with the bank?
- Which managers having savings accounts with the bank manage employees having savings accounts with the bank?
- Indicate whether the question can be answered by the bank data model show above and explain why. What is the average savings account balance for manufacturers having over 500 employees?
- Indicate whether the question can be answered by the bank data model show above and explain why. How many women opened checking accounts on December 5, 2008?