ATM

idatm_idlocationownercapabilities
1ATM1New YorkBank AContactless Transaction
2ATM2Los AngelesBank BCard Swipe Only

POINT_OF_SALE_TERMINAL

terminal_idstore_nameaddressownercapabilities
1Supermarket XChicagoStore OwnerContactless Transaction
2Depot YDallasStore OwnerCard Swipe Only

ACCOUNTS

account_numbercustomer_namebalanceinterest_rate
1John Doe1000.03.5
2Jane Smith800.03.75
3Emma Johnson600.03.25
4Michael Brown500.03.5
5Olivia Wilson900.03.75

TRANSACTIONS

transaction_idaccount_numberamountdate
(→ ACCOUNTS.account_number)
11-200.02022-01-01
22-100.02022-01-02
33-50.02022-01-03

EMPLOYEES

employee_idfirst_namelast_namehire_dateposition
1AliceSmith2021-01-01Manager
2BobJohnson2021-02-01Teller
3CarolWilliams2021-03-01Branch Manager
4DavidBrown2021-04-01Teller
5EvaMartinez2021-05-01Assistant Branch Manager

BANK_BRANCHES

branch_idbranch_namecityphone_numbermanager_employee_id
(→ EMPLOYEES.employee_id)
1Bank A HeadquartersNew York123-456-78901
2Bank B DowntownLos Angeles987-654-32102
3Bank A MidtownChicago555-555-55553
4Bank B UptownDallas444-444-44444
5Bank A WestsideSan Francisco333-333-33335