## 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

## Interest_Rates

RateID | Percentage
--- | ---
1 | 1%
2 | 2%

## 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