| CustomerID | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1234567890 |
| 2 | Jane | Smith | jane.smith@example.com | +0987654321 |
| AccountID | CustomerID | AccountType | Balance |
|---|---|---|---|
| (→ Customers.CustomerID) | |||
| 1 | 1 | Checking | 500.0 |
| 2 | 2 | Savings | 1000.0 |
| LoanID | CustomerID | Amount | InterestRate | TermYears |
|---|---|---|---|---|
| (→ Customers.CustomerID) | ||||
| 1 | 1 | 15000.0 | 6.0 | 5 |
| 2 | 2 | 10000.0 | 5.5 | 3 |
| 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 |
| 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 |
| BankName | HeadquarterLocation | FoundedYear | TotalAssets | NumberOfBranches | WebsiteURL |
|---|---|---|---|---|---|
| Example Bank | New York | 2000 | 1000000.0 | 50 | https://www.examplebank.com/ |
| 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 |
| 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 |