## Savings_Accounts

AccountID | CustomerName | OpenDate | Balance | Interest_Rate
--- | --- | --- | --- | ---
1 | John Doe | 2023-01-01 | 1000.0 | 1%
2 | Jane Smith | 2023-01-01 | 2000.0 | 2%

## Checking_Accounts

AccountID | CustomerName | OpenDate | Balance | OverdraftLimit | Interest_Rate
--- | --- | --- | --- | --- | ---
1 | John Doe | 2023-01-01 | 500.0 | 250.0 | 1%
2 | Jane Smith | 2023-01-01 | 750.0 | 350.0 | 2%

## Customers

CustomerID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1990-01-01 | john.doe@example.com
2 | Jane | Smith | 1992-01-01 | jane.smith@example.com

## Loans

LoanID | CustomerID | Amount | StartDate | EndDate | Rate
--- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |
1 | 1 | 5000 | 2023-01-01 | 2026-01-01 | 4.5
2 | 2 | 10000 | 2023-01-01 | 2028-01-01 | 4.75

## Transactions

TransactionID | AccountID | Type | Amount | DateAndTime
--- | --- | --- | --- | ---
| (→ Savings_Accounts.AccountID) |  |  |
1 | 1 | Deposit | 500.0 | 2023-01-01 12:00:00
2 | 2 | Withdrawal | 250.0 | 2023-01-01 13:00:00