Question
1. Draw an ER diagram for the database of the ABC Bank. The ER diagram should show the cardinality (represented by 1 or M) and
1. Draw an ER diagram for the database of the ABC Bank. The ER diagram should show the cardinality (represented by 1 or M) and participation (represented by single or double lines) of all the relationships. The information stored by the ABC bank database is as follows: (5 points)
a. The ABC bank maintains information about its employees, customers and their accounts.
b. It maintains the customers personal information like SSN, first name, last name and Date of Birth. It keeps a record of full address of its customers which consists of house number, street name and city. It maintains three contact (phone) numbers for each customer.
c. The ABC bank maintains information about the accounts like balance, creation date and last accessed date. It assigns a unique identifier called account number for each account. It also maintains the status of an account. The account status is active if the account is being accessed regularly. The status becomes expired if the account is not accessed for 120 days.
d. The database maintains employee information like name, branch name where the employee works and salary. It assigns a unique identifier called empid to all of its employees.
e. Every customer of the bank must have an account. Some customers can hold multiple accounts. The bank also provides facilities for joint accounts where multiple customers can hold the same account.
f. A bank employee may need to handle a set of customers or a set of bank accounts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started