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 |