Question: I REALLY NEED THE EER DIAGRAM Create the ER Model for TMZ Bank. TMZ Bank Database will store details about the branches, customers, employees, and

I REALLY NEED THE EER DIAGRAM

Create the ER Model for TMZ Bank.

TMZ Bank Database will store details about the branches, customers, employees, and the types of accounts they have.

A branch has a unique branch identification number. A Branch also has an Name, Address, office Number.

A Customer has a unique social security number. A customer has a name, address, date of birth, email address and phone number.

A branch hires employees. An employee can be a manager or staff member of that branch. An employee has a unique identification number. An employee also has a name, email and office phone number.

An employee can assist one or more customers and can open one or more accounts. A customer can open an account online as well without the assistance of a TMZ bank employee.

Accounts can be categorized based on their type checking or savings. Accounts have a unique account number, it also has a balance, expiration date, card type, csv number and a category type.

Customers can open both checking or savings accounts.

A savings account has an interest rate.

A checking account has an overdraft fee.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!