| CustomerID | FirstName | LastName | DateOfBirth | Digital_Solutions | Sign_in_Options |
|---|---|---|---|---|---|
| 1 | John | Doe | 2019-06-23 | None | None |
| 2 | Jane | Smith | 2018-07-12 | None | None |
| 3 | Alice | Wonderland | 2001-01-01 | None | None |
| 4 | Bob | Builder | 1980-12-31 | None | None |
| 5 | Charlie | Banks | 2002-04-02 | None | None |
| 6 | David | Stone | 1993-07-15 | Mobile Banking App | Biometric Authentication |
| 7 | Eva | Green | 1994-08-16 | Mobile Banking App | Password |
| 8 | Frank | Williams | 1985-09-17 | Internet Banking Platform | Biometric Authentication |
| 9 | Grace | Hopper | 1906-12-09 | Internet Banking Platform | PIN |
| AccountTypeID | AccountTypeName |
|---|---|
| 1 | Checking Account |
| 2 | Savings Account |
| 3 | Credit Card |
| 4 | Mortgage Loan |
| 5 | Business Loan |
| AccountID | CustomerID | AccountTypeID | OpenDate | Balance |
|---|---|---|---|---|
| (→ Customers.CustomerID) | (→ AccountTypes.AccountTypeID) | |||
| 1 | 1 | 1 | 2020-01-01 | 1000.0 |
| 2 | 2 | 2 | 2021-01-01 | 5000.0 |
| 3 | 3 | 3 | 2022-01-01 | -1000.0 |
| 4 | 4 | 4 | 2023-01-01 | 2000.0 |
| 5 | 5 | 5 | 2024-01-01 | 3000.0 |
| TransactionID | AccountID | Amount | Type | Date |
|---|---|---|---|---|
| (→ Accounts.AccountID) | ||||
| 1 | 1 | 500.0 | Deposit | 2020-02-01 |
| 2 | 2 | 1000.0 | Withdrawal | 2021-03-01 |
| 3 | 3 | -200.0 | Transfer In | 2022-04-01 |
| 4 | 4 | 800.0 | Interest | 2023-05-01 |
| 5 | 5 | 1500.0 | Loan Payment | 2024-06-01 |