## Customers

CustomerID | Name | Email | PhoneNumber
--- | --- | --- | ---
1 | John Doe | john@example.com | 1234567890
2 | Jane Smith | jane@example.com | 0987654321

## Accounts

AccountID | CustomerID | AccountType | Balance
--- | --- | --- | ---
| (→ Customers.CustomerID) |  |
1 | 1 | Checking | 1000.0
2 | 2 | Savings | 500.0

## Assets

AssetID | AccountID | AssetName | AssetValue
--- | --- | --- | ---
| (→ Accounts.AccountID) |  |
1 | 1 | Stock A | 1000.0
2 | 2 | Bond B | 500.0

## Funds

FundID | FundStructure | MarketShare | TotalAssets
--- | --- | --- | ---
1 | Hedge Fund | 2% | 10000.0
2 | Hedge Fund | 5% | 20000.0
3 | Mutual Fund | 2% | 15000.0
4 | Mutual Fund | 3% | 25000.0

## Transactions

TransactionID | FromAccountID | ToAccountID | Amount | TransactionDate
--- | --- | --- | --- | ---
| (→ Accounts.AccountID) | (→ Accounts.AccountID) |  |
1 | 1 | 2 | -250.0 | 2021-10-01
2 | 2 | 1 | 200.0 | 2021-10-02
3 | 1 | 2 | -200.0 | 2021-10-03
4 | 2 | 1 | -250.0 | 2021-10-04
5 | 1 | 2 | 100.0 | 2021-10-05

## Investments

InvestmentID | AccountID | FundID | Shares
--- | --- | --- | ---
| (→ Accounts.AccountID) | (→ Funds.FundID) |
1 | 1 | 1 | 10
2 | 2 | 2 | 20
3 | 1 | 3 | 5
4 | 2 | 4 | 10
5 | 1 | 1 | 15