Question: COMP Bank has Branches located in different cities and each one is identified by a unique name. Each Branch has yearly budget and the rating

COMP Bank has Branches located in different cities and each one is
identified by a unique name. Each Branch has yearly budget and the
rating (which is a number from 1 to 10) for each branch.
The customer of any branch is identified by their customer's name and
phone number. The bank also keeps track of each customers current
address.
The branch offers accounts and loans to its customers. Each account and
loan has a unique number
Each account is assigned to one or more customers and its balance can
never be negative.
A loan is always assigned to a single customer, has a fixed interest rate
and its balance 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!