Investment_Funds

idfundNametotalAssets
1ABC Fund1000000.0
2XYZ Fund2000000.0
3PQR Fund3000000.0
4LMN Fund4000000.0
5IJK Fund5000000.0

Portfolios

idportfolioTypedescription
1Mutual_FundA diversified mutual fund
2Equity_FundAn equity-focused fund
3Bond_FundA bond-focused fund
4Money_Market_FundA money market fund
5Balanced_FundA balanced fund that invests in both stocks and bonds

Customers

idfirstNamelastNameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceJohnsonalice.johnson@example.com
4BobWilliamsbob.williams@example.com
5CharlieBrowncharlie.brown@example.com

Transactions

transactionIdcustomerIdinvestmentFundIdamounttransactionDate
(→ Customers.id)(→ Investment_Funds.id)
1115000.02024-01-30 19:11:46
2127000.02024-01-30 19:11:46
3238000.02024-01-30 19:11:46
4349000.02024-01-30 19:11:46
54510000.02024-01-30 19:11:46

Investment_Funds_Portfolios

idinvestmentFundIdportfolioId
(→ Investment_Funds.id)(→ Portfolios.id)
111
221
331
441
551