Question: Construct an E - R diagram COMP Bank has Branches located in different cities and each one is identified bya unique name. Each Branch has

Construct an E-R diagram COMP Bank has Branches located in different cities and each one is identified bya unique name. Each Branch has yearly budget and the rating (which is a numberfrom 1 to 10) for each branch. The customer of any branch is identified by their customer's name and phonenumber. The bank also keeps track of each customers current address. The branch offers accounts and loans to its customers. Each account and loan hasa unique number Each account is assigned to one or more customers and its balance can never benegative. A loan is always assigned to a single customer, has a fixed interest rate and itsbalance cannot be negative either.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!