Clients

ClientIDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn@example.com1234567890
2JaneSmithjane@example.com0987654321
3AliceBrownalice@example.com1122334455
4BobWhitebob@example.com6543211234
5CharlieBlackcharlie@example.com5566778899

Accounts

AccountIDClientIDBalance
(→ Clients.ClientID)
111000.0
222000.0
333000.0
444000.0
555000.0

Digital_Solutions

SolutionIDName
1Mobile Banking App
2Internet Banking Platform

Sign_in_Options

OptionIDOptionName
1Biometric Authentication
2Password Authentication

Connected_Accounts

ConnectionIDAccountIDSolutionIDOptionID
(→ Accounts.AccountID)(→ Digital_Solutions.SolutionID)(→ Sign_in_Options.OptionID)
1111
2112
3221
4222
5311

Transactions

TransactionIDAccountIDAmountDate
(→ Accounts.AccountID)
11100.02024-03-13 16:00:36
21-50.02024-03-13 16:00:36
32200.02024-03-13 16:00:36
42-100.02024-03-13 16:00:36
53300.02024-03-13 16:00:36