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 |