Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

draw an ER diagram from the following bank requirements. [5 points] - Each customer has a unique ID, full name, email, phone number, and address.

image text in transcribed

draw an ER diagram from the following bank requirements. [5 points] - Each customer has a unique ID, full name, email, phone number, and address. - A customer can have one or more phone numbers. A customer must open an account. - A customer can request a loan from the bank. A customer can borrow at least one loan. - A customer can open more than one account. For the loan, we need to save a unique ID, amount, and type in the database. - The account has a unique number, balance, date of opening, and minimum balance. When a customer takes a loan, the interest rate and payment methods are recorded

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

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

2. Identify conflict triggers in yourself and others

Answered: 1 week ago