Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

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

Learning MySQL Get A Handle On Your Data

Authors: Seyed M M Tahaghoghi

1st Edition

0596529465, 9780596529468

More Books

Students also viewed these Databases questions

Question

Describe a simple approach to quantitative data analysis.

Answered: 1 week ago

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago