Customers

CustomerIDFirstNameLastNameDateOfBirthDigital_SolutionsSign_in_Options
1JohnDoe2019-06-23NoneNone
2JaneSmith2018-07-12NoneNone
3AliceWonderland2001-01-01NoneNone
4BobBuilder1980-12-31NoneNone
5CharlieBanks2002-04-02NoneNone
6DavidStone1993-07-15Mobile Banking AppBiometric Authentication
7EvaGreen1994-08-16Mobile Banking AppPassword
8FrankWilliams1985-09-17Internet Banking PlatformBiometric Authentication
9GraceHopper1906-12-09Internet Banking PlatformPIN

AccountTypes

AccountTypeIDAccountTypeName
1Checking Account
2Savings Account
3Credit Card
4Mortgage Loan
5Business Loan

Accounts

AccountIDCustomerIDAccountTypeIDOpenDateBalance
(→ Customers.CustomerID)(→ AccountTypes.AccountTypeID)
1112020-01-011000.0
2222021-01-015000.0
3332022-01-01-1000.0
4442023-01-012000.0
5552024-01-013000.0

Transactions

TransactionIDAccountIDAmountTypeDate
(→ Accounts.AccountID)
11500.0Deposit2020-02-01
221000.0Withdrawal2021-03-01
33-200.0Transfer In2022-04-01
44800.0Interest2023-05-01
551500.0Loan Payment2024-06-01