Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone solve this for me? I wanna check if my answer is correct or no Create an ER Diagram of a Bank Database: A

Can someone solve this for me? I wanna check if my answer is correct or no

Create an ER Diagram of a Bank Database:

A bank provides services to customers. Customers either open bank accounts (CURRENT, SAVINGS, etc.) or receive bank loans (DIRECT, INDIRECT, etc.) from the bank. Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Bank branches are identified through their unique codes. The bank stores information for each branch namely: code, name, and address. The bank needs also to store customer info namely: SSN, name, phone, and address. The bank needs also to keep track of customers loans and accounts. Information stored about loans include loan no, amount, and type. Account information stored is account no, balance, and type. The address information stored for any entity includes street no, district, city, and emirate.

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

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions