Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started