A database is being constructed to keep track of Banks, Customers, and Loans A bank has a name, an address, and a unique identification number Any bank can have many branches Each branch has an address, and a unique identification number among other branches in the same bank A customer has a SSN, multiple phone numbers, name (First, Middle, and Last), gender, and an address Each customer may have more than one account An account has a unique identification number, a type, and a balance Each account belongs to a single branch Each customer can have one or more loans from his her branch only A loan has a unique identification number, an amount, and a type Draw an ERD for this database

Question

A database is being constructed to keep track of Banks, Customers, and Loans  A bank has a name, an address, and a unique identification number  Any bank can have many branches  Each branch has an address, and a unique identification number among other branches in the same bank  A customer has a SSN, multiple phone numbers, name (First, Middle, and Last), gender, and an address  Each customer may have more than one account  An account has a unique identification number, a type, and a balance  Each account belongs to a single branch  Each customer can have one or more loans from his her branch only  A loan has a unique identification number, an amount, and a type  Draw an ERD for this database

Accepted Answer

The Answer is in the image, click to view ...

Question

A database is being constructed to keep track of Banks, Customers, and Loans. A bank has a name, an address, and a unique identification number.

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Learning MySQL Get A Handle On Your Data

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question