In this assignment, you will build an entity-relationship (ER) diagram for a relational database. You will once again utilize Lucidchart.com for the creation of this. You are going to design an ER diagram for a bank. Design an ER diagram for the Bank database that should reflect the following requirements:

1. Each bank has a unique ID, name, and headquarters address. Each bank has many branches, and for each branch, we need to keep the branch ID (unique within the bank but not unique across different banks), location, and telephone number.

2. Customers can have many accounts at the same branch or at different branches. An account has a unique account ID, type (E.g., saving, or checking), currency (E.g., dollar, euro), and balance.

3. A customer can take many loans from different branches, however, there is a restriction that a customer cannot take more than one loan from a given branch in the same year. For each loan, we need to keep the loan amount and the year.

4. Each customer has an SSN (unique ID), name, address, and Date of Birth properties.

5. We need to capture the transactions done by each customer over each account. We capture the type of the transaction (E.g., either withdrawal or deposit), the transaction time, and the amount.

NB: THE USE OF THE ENTITY RELATIONSHIP DIAGRAM IS MANDATORY HERE TO AVOID GETTING ZERO IN THIS ASSIGNMENT