| ClientID | FirstName | LastName | EmailAddress |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| 3 | Alice | Brown | alice.brown@example.com |
| 4 | Bob | White | bob.white@example.com |
| 5 | Charlie | Black | charlie.black@example.com |
| AccountNumber | ClientID | Balance |
|---|---|---|
| (→ Clients.ClientID) | ||
| 108765432 | 5 | 0.0 |
| 123456789 | 1 | 0.0 |
| 543210987 | 3 | 0.0 |
| 654321098 | 4 | 0.0 |
| 987654321 | 2 | 0.0 |
| InvestmentID | AccountNumber | InvestmentType | InvestmentValue |
|---|---|---|---|
| (→ Accounts.AccountNumber) | |||
| 1 | 123456789 | Stocks | 10000.0 |
| 2 | 987654321 | Bonds | 20000.0 |
| 3 | 543210987 | Mutual Funds | 30000.0 |
| 4 | 654321098 | Real Estate | 40000.0 |
| 5 | 108765432 | Cryptocurrency | 50000.0 |
| FundingID | AccountNumber | FundingAmount | InvestmentType |
|---|---|---|---|
| (→ Accounts.AccountNumber) | |||
| 1 | 123456789 | 5000000.0 | Growth Equity Firm |
| 2 | 123456789 | 7500000.0 | Venture Capital Trust |
| 3 | 987654321 | 5000000.0 | Growth Equity Firm |
| 4 | 987654321 | 7500000.0 | Venture Capital Trust |
| 5 | 543210987 | 1000000.0 | Private Equity |
| CompanyID | Name | Type |
|---|---|---|
| 1 | Growth Equity Firm | Equity |
| 2 | Venture Capital Trust | Trust |
| 3 | Angel Investor | Individual |
| 4 | Seed Accelerator | Accelerator |
| 5 | Private Equity Firm | Firm |
| TransactionID | InvestmentID | CompanyID | Amount | Date |
|---|---|---|---|---|
| (→ Investments.InvestmentID) | (→ InvestmentCompanies.CompanyID) | |||
| 1 | 1 | 1 | 10000.0 | 2022-01-01 00:00:00 |
| 2 | 2 | 2 | 15000.0 | 2022-01-01 00:00:00 |
| 3 | 3 | 3 | 20000.0 | 2022-01-01 00:00:00 |
| 4 | 4 | 4 | 25000.0 | 2022-01-01 00:00:00 |
| 5 | 5 | 5 | 30000.0 | 2022-01-01 00:00:00 |