Branch

IDNameAddressPhoneNumberServices_OfferedManagerName
1First Branch123 Main St555-1234BalanceJohn Doe
2Second Branch456 Elm St555-5678Checking & SavingsJane Smith

Online_Bank

IDNameWebsiteCustomerSupportPhoneNumberServices_OfferedSecurityMeasures
1MyBankhttps://www.mybank.com555-9999BalanceTwo-factor authentication, Encrypted communication channels
2AnotherBankhttps://www.anotherbank.com555-8888Checking & SavingsBiometric access control, Secure API

Customers

IDFirstNameLastNameDateOfBirthEmailPhoneNumberAccountID
(→ Accounts.ID)
1AliceWonderland1990-01-01alice@example.com555-11111
2BobBuilder1985-02-02bob@example.com555-22222
3CharlieChaplin1992-03-03charlie@example.com555-33333
4DavidDavis1988-04-04david@example.com555-44444
5EveEvans1991-05-05eve@example.com555-55555

Transactions

TransactionIDAmountTypeTimestampAccountIDCustomerID
(→ Accounts.ID)(→ Customers.ID)
11000Deposit2021-01-01 10:00:0011
2-500Withdrawal2021-01-01 11:00:0022
3200Transfer2021-01-02 12:00:0033
4-150Payment2021-01-03 13:00:0044
51200Deposit2021-01-04 14:00:0055

Accounts

IDAccountNumberBalanceInterestRateOpenDateCurrentBranchIDIsActive
(→ Branch.ID)
112345678100000.52021-01-01 10:00:0011
29876543250000.42021-01-02 11:00:0021
35432109880000.62021-01-03 12:00:0010
46543210920000.32021-01-04 13:00:0021
51234567830000.22021-01-05 14:00:0011