Databases
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:
1. Hand drawn solutions – can be a paper submission or scanned and uploaded as a pdf file.
2. 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
.1.What percentage of the bank’s checking account holders are bank employees? (Hint: Add an Employee object set to the model first.)
2. How many tellers have savings accounts with the bank?
3. Which managers having savings accounts with the bank manage employees having savings accounts with the bank?4.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?
5. 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?
