Banks

idnameheadquarter
1Bank ANew York
2Bank BLondon
3Bank CTokyo
4Bank DParis
5Bank EDubai

Services

idserviceName
1Savings_Account
2Current_Account
3Loan
4Credit_Card
5Mortgage

Customers

idfirstNamelastNamedateOfBirth
1JohnSmith1987-03-25
2JaneDoe1992-06-10
3PeterBlack1980-10-15
4EmilyWhite1995-02-20
5DavidGreen1977-08-25

Accounts

idaccountNumberbalancecustomerId
(→ Customers.id)
112345678910000.01
29876543215000.02
35432109877000.03
465432109820000.04
58765432108000.05

Transactions

idtransactionDateamountdescriptionaccountId
(→ Accounts.id)
12022-01-01 10:00:00500.0Payment1
22022-01-02 15:30:00-300.0Withdrawal2
32022-01-03 09:15:00700.0Deposit3
42022-01-04 12:45:00-400.0Transfer4
52022-01-05 17:00:00900.0Online Purchase5

Banks_Services

bankIdserviceId
(→ Banks.id)(→ Services.id)
11
12
21
22
33
34
31
41
51