Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions

Question

2. What rewards do you get from engaging in your habit behavior?

Answered: 1 week ago

Question

Examine various types of executive compensation plans.

Answered: 1 week ago

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago