Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ER diagram accordingly to the following user requirements. A bank application keeps track of customer information, including SSN, first name, last name, phone

Draw an ER diagram accordingly to the following user requirements.

A bank application keeps track of customer information, including SSN, first name, last name, phone number, and address. When a person either owns an account or borrows a loan, the person becomes a customer of the bank. The bank database keeps track of account information, including account balance, type of account (e.g. saving, checking), and when the account is opened by a customer. When a customer opens a new account, the date to open the account is the same as the date the customer owns the account. New customers can be added to an account after the account was opened. We need the date when a customer starts to own an account. A customer can own many accounts. An account must be owned by at least one customer. The bank application also keeps track of loan information. A loan has a loan number (unique), total amount of the loan, the loan type (e.g. car). A loan has a number of payments. Each payment has a payment number that is unique with respect to a loan. Each payment has an amount, the method for the payment, and a status (paid, not paid), and a due date. A customer can borrow many loans. A loan can be borrowed by many customers, at least one. The application also keeps track of the information of branches of the bank. Each branch has a branch name (unique) and an address. Each customer has one favorite branch that he/she visits most frequently. If a customer never goes to a branch (for example, only use online banking), he/she does not have a favorite branch. A branch can be the favorite of many customers, at least one.

Nothing Extra No extra features or anything!

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_2

Step: 3

blur-text-image_3

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

List the major prohibitions of the Canadian Human Rights Act .

Answered: 1 week ago