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 |