Customers

customerIDfirstNamelastNameemailphoneNumber
1JohnSmithjohnsmith@example.com123456789
2JaneDoejanedoe@example.com987654321

Accounts

accountIDcustomerIDbalance
(→ Customers.customerID)
111000.0
222000.0

Loans

loanIDcustomerIDamountinterestRateterm
(→ Customers.customerID)
115000.05.012
2210000.04.024

Investments

investmentIDcustomerIDfundTypedividendamount
(→ Customers.customerID)
11Closed-End Fund2% Annual5000.0
22Closed-End Fund3% Annual6000.0
31Exchange-Traded Fund2% Annual4000.0
42Exchange-Traded Fund4% Annual8000.0

Transactions

transactionIDaccountIDdatetypeamount
(→ Accounts.accountID)
112022-01-01Deposit1000.0
212022-01-15Withdrawal500.0
322022-02-01Deposit2000.0
422022-02-15Withdrawal1000.0