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 |