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 |