Problems $1(25$ points$)$

Given the following BANK ER diagram, explain every

part$/$symbol of this diagram including but not limited to: entities,

relationships, constraints, etc.

How to answer the question:

List all the entities, attributes, and keys

List all the relationships: explain in detail the cardinality ratio

$($for ex$.$ Explain the constraints from both directions$),$ explain

the total$/$partial participations for each relationship, and any

attribute a relationship might have.

For example:

Entities:

Bank entity has the following attributes:

Keys for

the Bank entity:

List the remaining entities$/$attributes$/$keys

Relationships:

Branches relationship:

Explain the cardinality ratio from right to left

Explain the cardinality ratio from left to right

Explain the total or partial participation on both ends of the

relationship $($there should be two parts$)$

List the remaining relationships $($and explain them the same

exact way as mentioned in the above example$)$: