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 |