## Customers

CustomerID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## Accounts

AccountID | CustomerID | Balance
--- | --- | ---
| (→ Customers.CustomerID) |
1 | 1 | 1000.0
2 | 2 | 500.0

## Loans

LoanID | CustomerID | Amount | InterestRate | StartDate | EndDate
--- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |
1 | 1 | 50000 | 3.5 | 2023-01-01 | 2026-12-31
2 | 2 | 75000 | 3 | 2023-02-01 | 2028-01-31

## Transactions

TransactionID | AccountID | Date | Type | Amount
--- | --- | --- | --- | ---
| (→ Accounts.AccountID) |  |  |
1 | 1 | 2024-02-19 15:10:48 | Deposit | 100.0
2 | 2 | 2024-02-19 15:10:48 | Withdrawal | -50.0

## Banks

BankID | Number_of_Branches | Countries_served | Bank
--- | --- | --- | ---
1 | 100 | USA and Canada | ABC Bank
2 | 200 | Europe | XYZ Bank

## Employees

EmployeeID | FirstName | LastName | Position | Salary | BankID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Banks.BankID)
1 | Alice | Wright | Manager | 50000.0 | 1
2 | Bob | Hanson | Teller | 35000.0 | 2