City

idnamecountry_id
1New York1
2London2
3Tokyo3
4Paris4
5Mumbai5

Country

idname
1USA
2UK
3Japan
4France
5India

Banks

idbank_namecity_idcountry_id
(→ City.id)(→ Country.id)
1Bank A11
2Bank B22
3Bank C33
4Bank D44
5Bank E55

Accounts

account_numberbalanceowner_id
(→ Banks.id)
11000.01
2800.02
31200.03
4900.04
5700.05

Transactions

transaction_iddateamountdebit_account_idcredit_account_id
(→ Accounts.account_number)(→ Accounts.account_number)
12024-02-19 14:18:41100.012
22024-02-19 14:18:41200.034
32024-02-19 14:18:41300.051
42024-02-19 14:18:41400.023
52024-02-19 14:18:41500.045

Customers

customer_idfirst_namelast_namebirth_dateaddressphoneemail
(→ Accounts.owner_id)
1JohnDoe1980-01-01123 Main St555-1234john.doe@example.com
2JaneSmith1985-06-01456 Elm St555-5678jane.smith@example.com
3AliceWilliams1990-12-01789 Oak St555-9012alice.williams@example.com
4BobJohnson1988-03-01135 Pine St555-1314bob.johnson@example.com
5CarolBrown1992-09-01246 Maple St555-1415carol.brown@example.com