## investors

investorID | name | email
--- | --- | ---
1 | Alice Spencer | alice@example.com
2 | Bob Johnson | bob@example.com
3 | Carol Williams | carol@example.com
4 | David Brown | david@example.com
5 | Emily Davis | emily@example.com

## stocks

stockID | tickerSymbol | companyName | industry
--- | --- | --- | ---
1 | AAPL | Apple Inc. | Technology
2 | GOOG | Google LLC | Technology
3 | AMZN | Amazon.com, Inc. | Retail
4 | MSFT | Microsoft Corporation | Technology
5 | FB | Facebook, Inc. | Technology

## portfolio

id | investorID | stockID | sharesOwned
--- | --- | --- | ---
| (→ investors.investorID) | (→ stocks.stockID) |
1 | 1 | 1 | 100
2 | 2 | 3 | 50
3 | 3 | 1 | 75
4 | 4 | 2 | 100
5 | 5 | 3 | 50

## earnings

earningsID | date | EPS | investorID | stockID
--- | --- | --- | --- | ---
|  |  | (→ investors.investorID) | (→ stocks.stockID)
1 | 2021-06-30 | 3.0 | 1 | 1
2 | 2021-09-30 | 4.0 | 2 | 2
3 | 2021-12-31 | 3.5 | 3 | 1
4 | 2021-09-30 | 2.8 | 4 | 2
5 | 2021-12-31 | 4.2 | 5 | 3

## prices

priceID | date | sharePrice | investorID | stockID
--- | --- | --- | --- | ---
|  |  | (→ investors.investorID) | (→ stocks.stockID)
1 | 2021-06-30 | 150.0 | 1 | 1
2 | 2021-09-30 | 160.0 | 2 | 2
3 | 2021-12-31 | 155.0 | 3 | 1
4 | 2021-09-30 | 170.0 | 4 | 2
5 | 2021-12-31 | 165.0 | 5 | 3