Risks

RiskIDRiskName
1Inflation_Risk
2Interest_rate_risk
3Credit_risk
4Liquidity_risk
5Operational_risk

Banks

BankIDBankNameLocation
1First NationalNew York
2Global BankLondon
3Regional BankChicago
4Local BankBoston
5Trust CompanySan Francisco

Customers

CustomerIDNameAge
1John Doe32
2Jane Smith28
3Mike Johnson45
4Emily Davis36
5David Brown55

Accounts

AccountIDAccountNumberBalanceOpenDate
1123456789010000.02021-01-01
223456789015000.02021-02-01
3345678901215000.02021-03-01
4456789012320000.02021-04-01
5567890123425000.02021-05-01

Transactions

TransactionIDAccountIDAmountDate
(→ Accounts.AccountID)
11500.02021-06-01
21-200.02021-06-15
32300.02021-06-01
42-100.02021-06-15
53400.02021-06-01
63-150.02021-06-15
74500.02021-06-01
84-200.02021-06-15
95600.02021-06-01
105-250.02021-06-15

Bank_Products

ProductIDProductNameInterestRate
1Checking Account0.01
2Savings Account0.02
3Fixed Deposit0.03
4Variable Deposit0.04
5Loan0.05

Bank_Customers

BankIDCustomerID
(→ Banks.BankID)(→ Customers.CustomerID)
11
12
23
24
35
31
42
43
54
55

Bank_Accounts

BankIDAccountID
(→ Banks.BankID)(→ Accounts.AccountID)
11
12
23
24
35
31
42
43
54
55

Bank_Products_Risks

ProductIDRiskID
(→ Bank_Products.ProductID)(→ Risks.RiskID)
11
12
21
22
31
33
41
44
51
55