Stockbrokers

idnamecontact_numberemailfees
1John Doe123-456-7890john@example.com1%
2Jane Smith987-654-3210jane@example.com2%
3Alice Johnson555-555-5555alice@example.com1.5%
4Bob Brown111-222-3333bob@example.com0.75%

Mutual_funds

idfund_nametotal_assetsexpense_ratiofees
1ABC Fund1000000.00.011%
2XYZ Fund500000.00.021.25%
3PQR Fund200000.00.032%
4MNO Fund800000.00.0050.5%

Customers

idfirst_namelast_namedate_of_birthphone_numberemail
1JohnDoe1990-01-01123-456-7890john@example.com
2JaneSmith1992-02-02987-654-3210jane@example.com
3AliceJohnson1988-03-03555-555-5555alice@example.com
4BobBrown1991-04-04111-222-3333bob@example.com

Accounts

account_idcustomer_idbalanceinterest_rate
(→ Customers.id)
111000.02.5
222000.03
333000.02
444000.03.5

Transactions

transaction_idaccount_idamounttransaction_date
(→ Accounts.account_id)
11500.02022-01-01 10:00:00
221000.02022-02-01 11:00:00
331500.02022-03-01 12:00:00
442000.02022-04-01 13:00:00

Investments

investment_idstockbroker_idmutual_fund_idcustomer_idquantitypurchase_price
(→ Stockbrokers.id)(→ Mutual_funds.id)(→ Customers.id)
111110100.0
212220200.0
32135150.0
422410250.0
533120300.0
634215350.0