## Branch

ID | Name | Address | PhoneNumber | Services_Offered | ManagerName
--- | --- | --- | --- | --- | ---
1 | First Branch | 123 Main St | 555-1234 | Balance | John Doe
2 | Second Branch | 456 Elm St | 555-5678 | Checking & Savings | Jane Smith

## Online_Bank

ID | Name | Website | CustomerSupportPhoneNumber | Services_Offered | SecurityMeasures
--- | --- | --- | --- | --- | ---
1 | MyBank | https://www.mybank.com | 555-9999 | Balance | Two-factor authentication, Encrypted communication channels
2 | AnotherBank | https://www.anotherbank.com | 555-8888 | Checking & Savings | Biometric access control, Secure API

## Customers

ID | FirstName | LastName | DateOfBirth | Email | PhoneNumber | AccountID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Accounts.ID)
1 | Alice | Wonderland | 1990-01-01 | alice@example.com | 555-1111 | 1
2 | Bob | Builder | 1985-02-02 | bob@example.com | 555-2222 | 2
3 | Charlie | Chaplin | 1992-03-03 | charlie@example.com | 555-3333 | 3
4 | David | Davis | 1988-04-04 | david@example.com | 555-4444 | 4
5 | Eve | Evans | 1991-05-05 | eve@example.com | 555-5555 | 5

## Transactions

TransactionID | Amount | Type | Timestamp | AccountID | CustomerID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Accounts.ID) | (→ Customers.ID)
1 | 1000 | Deposit | 2021-01-01 10:00:00 | 1 | 1
2 | -500 | Withdrawal | 2021-01-01 11:00:00 | 2 | 2
3 | 200 | Transfer | 2021-01-02 12:00:00 | 3 | 3
4 | -150 | Payment | 2021-01-03 13:00:00 | 4 | 4
5 | 1200 | Deposit | 2021-01-04 14:00:00 | 5 | 5

## Accounts

ID | AccountNumber | Balance | InterestRate | OpenDate | CurrentBranchID | IsActive
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Branch.ID) |
1 | 12345678 | 10000 | 0.5 | 2021-01-01 10:00:00 | 1 | 1
2 | 98765432 | 5000 | 0.4 | 2021-01-02 11:00:00 | 2 | 1
3 | 54321098 | 8000 | 0.6 | 2021-01-03 12:00:00 | 1 | 0
4 | 65432109 | 2000 | 0.3 | 2021-01-04 13:00:00 | 2 | 1
5 | 12345678 | 3000 | 0.2 | 2021-01-05 14:00:00 | 1 | 1