## Customers

CustomerID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +1234567890
2 | Jane | Smith | jane.smith@example.com | +0987654321

## Accounts

AccountID | CustomerID | AccountType | Balance
--- | --- | --- | ---
| (→ Customers.CustomerID) |  |
1 | 1 | Checking | 500.0
2 | 2 | Savings | 1000.0

## Loans

LoanID | CustomerID | Amount | InterestRate | TermYears
--- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |
1 | 1 | 15000.0 | 6.0 | 5
2 | 2 | 10000.0 | 5.5 | 3

## Deposits

DepositID | AccountID | Amount | Date
--- | --- | --- | ---
| (→ Accounts.AccountID) |  |
1 | 1 | 500.0 | 2024-02-19 14:31:33
2 | 2 | 1000.0 | 2024-02-19 14:31:33

## Transactions

TransactionID | AccountID | Type | Amount | Date
--- | --- | --- | --- | ---
| (→ Accounts.AccountID) |  |  |
1 | 1 | Deposit | 500.0 | 2024-02-19 14:31:33
2 | 2 | Withdrawal | 200.0 | 2024-02-19 14:31:33

## Bank

BankName | HeadquarterLocation | FoundedYear | TotalAssets | NumberOfBranches | WebsiteURL
--- | --- | --- | --- | --- | ---
Example Bank | New York | 2000 | 1000000.0 | 50 | https://www.examplebank.com/

## Branch

BranchID | BankName | BranchName | Address | City | State | ZipCode
--- | --- | --- | --- | --- | --- | ---
| (→ Bank.BankName) |  |  |  |  |
1 | Example Bank | Main Branch | 123 Main St | New York | NY | 10001
2 | Example Bank | East Side Branch | 456 East Ave | New York | NY | 10010

## BankingProducts

ProductID | BankName | ProductName | Description | AnnualInterestRate | MinimumDepositAmount | MaximumDepositAmount | BranchName
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Bank.BankName) |  |  |  |  |  | (→ Branch.BranchID)
1 | Example Bank | High-Yield Savings | A high interest rate savings account with no monthly fees. | 1.0 | 1000.0 | None | 1
2 | Example Bank | CD Special | Certificate of deposit offering a fixed annual percentage yield. | 2.5 | 1000.0 | 1000000.0 | 2