Customers
CustomerID | FirstName | LastName | Email | PhoneNumber |
1 | John | Doe | john.doe@example.com | 123-456-7890 |
2 | Jane | Smith | jane.smith@example.com | 098-765-4321 |
Savings_Accounts
AccountID | CustomerID | AccountBalance | AnnualInterestRate |
| (→ Customers.CustomerID) | | (→ Interest_Rates.RateID) |
1 | 1 | 1000.0 | 1 |
2 | 1 | 5000.0 | 2 |
Checking_Accounts
AccountID | CustomerID | AccountBalance | MonthlyServiceFee |
| (→ Customers.CustomerID) | | |
1 | 1 | 1500.0 | 10.0 |
2 | 1 | 3000.0 | 20.0 |
Loans
LoanID | PrincipalAmount | YearlyInterestRate | StartDate | EndDate | CustomerID |
| | | | | (→ Customers.CustomerID) |
1 | 5000.0 | 4.0 | 2023-01-01 | 2025-01-01 | 1 |
2 | 10000.0 | 5.0 | 2023-01-01 | 2026-01-01 | 1 |
Transactions
TransactionID | Amount | Type | AccountID | LoanID | Date |
| | | (→ Savings_Accounts.AccountID) | (→ Loans.LoanID) | |
1 | 100 | Deposit | 1 | None | 2023-01-01 |
2 | 50 | Withdrawal | 1 | None | 2023-01-15 |