## Investors

InvestorID | FirstName | LastName | TotalAssets
--- | --- | --- | ---
(→ Shares.InvestorID) |  |  |
1 | John | Doe | 1000000.0
2 | Jane | Smith | 800000.0
3 | Alice | Spencer | 600000.0

## Companies

CompanyID | Name | Industry | MarketCapitalization
--- | --- | --- | ---
(→ Shares.CompanyID) |  |  |
1 | Apple Inc. | Technology | 2000000000.0
2 | Amazon Inc. | Retail | 1500000000.0
3 | Google Inc. | Technology | 900000000.0

## Shares

ShareID | CompanyID | InvestorID | PurchaseDate | Metrics
--- | --- | --- | --- | ---
| (→ Companies.CompanyID) | (→ Investors.InvestorID) |  |
1 | 1 | 1 | 2021-01-01 | Earnings per Share
2 | 2 | 2 | 2021-01-01 | Earnings per Share
3 | 3 | 3 | 2021-01-01 | Share Price
4 | 1 | 1 | 2021-01-01 | Share Price
5 | 2 | 2 | 2021-01-01 | Earnings per Share

## Transactions

TransactionID | ShareID | Quantity | Price | DateOfTransaction
--- | --- | --- | --- | ---
| (→ Shares.ShareID) |  |  |
1 | 1 | 10 | 150 | 2021-01-02
2 | 2 | 5 | 200 | 2021-01-02
3 | 3 | 7 | 170 | 2021-01-02
4 | 4 | 15 | 160 | 2021-01-02
5 | 5 | 20 | 180 | 2021-01-02