## Customers

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

## AccountTypes

AccountTypeID | AccountTypeName
--- | ---
1 | Checking Account
2 | Savings Account
3 | Credit Card
4 | Mortgage Loan
5 | Business Loan

## Accounts

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

## Transactions

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