Investors

InvestorIDFirstNameLastNameTotalAssets
(→ Shares.InvestorID)
1JohnDoe1000000.0
2JaneSmith800000.0
3AliceSpencer600000.0

Companies

CompanyIDNameIndustryMarketCapitalization
(→ Shares.CompanyID)
1Apple Inc.Technology2000000000.0
2Amazon Inc.Retail1500000000.0
3Google Inc.Technology900000000.0

Shares

ShareIDCompanyIDInvestorIDPurchaseDateMetrics
(→ Companies.CompanyID)(→ Investors.InvestorID)
1112021-01-01Earnings per Share
2222021-01-01Earnings per Share
3332021-01-01Share Price
4112021-01-01Share Price
5222021-01-01Earnings per Share

Transactions

TransactionIDShareIDQuantityPriceDateOfTransaction
(→ Shares.ShareID)
11101502021-01-02
2252002021-01-02
3371702021-01-02
44151602021-01-02
55201802021-01-02