## Customers

customerID | firstName | lastName | email | phoneNumber
--- | --- | --- | --- | ---
1 | John | Smith | johnsmith@example.com | 123456789
2 | Jane | Doe | janedoe@example.com | 987654321

## Accounts

accountID | customerID | balance
--- | --- | ---
| (→ Customers.customerID) |
1 | 1 | 1000.0
2 | 2 | 2000.0

## Loans

loanID | customerID | amount | interestRate | term
--- | --- | --- | --- | ---
| (→ Customers.customerID) |  |  |
1 | 1 | 5000.0 | 5.0 | 12
2 | 2 | 10000.0 | 4.0 | 24

## Investments

investmentID | customerID | fundType | dividend | amount
--- | --- | --- | --- | ---
| (→ Customers.customerID) |  |  |
1 | 1 | Closed-End Fund | 2% Annual | 5000.0
2 | 2 | Closed-End Fund | 3% Annual | 6000.0
3 | 1 | Exchange-Traded Fund | 2% Annual | 4000.0
4 | 2 | Exchange-Traded Fund | 4% Annual | 8000.0

## Transactions

transactionID | accountID | date | type | amount
--- | --- | --- | --- | ---
| (→ Accounts.accountID) |  |  |
1 | 1 | 2022-01-01 | Deposit | 1000.0
2 | 1 | 2022-01-15 | Withdrawal | 500.0
3 | 2 | 2022-02-01 | Deposit | 2000.0
4 | 2 | 2022-02-15 | Withdrawal | 1000.0