Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bank Management System Database The Bank management system has a database that shows the relationships between the entities such as a Customer, Branch , and

image text in transcribed

Bank Management System Database The Bank management system has a database that shows the relationships between the entities such as a Customer, Branch , and Loan_Application. Entities and Attributes a) Customer Entity: It has Customer ID, Name, Phone, City. b) Branch Entity: It has Branch Number, Branch Name, and Branch City c) Loan_Application Entity: It has Loan Number, Limited Required, Limited approved, and Date. b) Any Branch can have many Customers, but each customer is assigned to one branch. c) Each branch can manage many loans, as well as each loan is managed by many branch. Notice: Database should record the number of year to pay back the loan in the management relation. 1- Create a complete ER diagram for the previous scenario (Including all the requirements). 2- Map your ERD to Relation Model according to what you have learned in theory lectures

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

Data Infrastructure For Medical Research In Databases

Authors: Thomas Heinis ,Anastasia Ailamaki

1st Edition

1680833480, 978-1680833485

More Books

Students also viewed these Databases questions