## StockBrokers

ID | Name | Address | PhoneNumber | EmailAddress
--- | --- | --- | --- | ---
1 | ABC Brokerage | New York | 1234567890 | abc@example.com
2 | XYZ Brokerage | Los Angeles | 2345678901 | xyz@example.com

## MutualFunds

FundID | Name | TypeOfFund | AssetsUnderManagement | DateEstablished
--- | --- | --- | --- | ---
1 | Aggressive Growth Fund | Equity | 1000000.0 | 2000-01-01
2 | Conservative Income Fund | Fixed Income | 500000.0 | 2005-01-01

## Transactions

TransactionID | ClientId | StockBrokerID | MutualFundID | AmountInvested | FeesPaid
--- | --- | --- | --- | --- | ---
| (→ Clients.ClientID) | (→ StockBrokers.ID) | (→ MutualFunds.FundID) |  |
1 | 1 | 1 | 1 | 10000.0 | 100
2 | 2 | 1 | 2 | 5000.0 | 50
3 | 1 | 2 | 2 | 15000.0 | 150
4 | 2 | 2 | 1 | 20000.0 | 200
5 | 1 | 1 | 1 | 1000.0 | 10

## Clients

ClientID | FirstName | LastName | BirthDate | EmailAddress | PhoneNumber
--- | --- | --- | --- | --- | ---
1 | John Doe | Jane Doe | 1980-01-01 | john.doe@example.com | 1234567890
2 | Alice Smith | Bob Smith | 1990-01-01 | alice.smith@example.com | 2345678901

## Accounts

AccountID | ClientID | Balance | CreatedOn
--- | --- | --- | ---
| (→ Clients.ClientID) |  |
1 | 1 | 100000.0 | 2022-01-01
2 | 2 | 50000.0 | 2022-01-01
3 | 1 | 20000.0 | 2022-01-01
4 | 2 | 30000.0 | 2022-01-01
5 | 1 | 5000.0 | 2022-01-01