investors

investorIDnameemail
1Alice Spenceralice@example.com
2Bob Johnsonbob@example.com
3Carol Williamscarol@example.com
4David Browndavid@example.com
5Emily Davisemily@example.com

stocks

stockIDtickerSymbolcompanyNameindustry
1AAPLApple Inc.Technology
2GOOGGoogle LLCTechnology
3AMZNAmazon.com, Inc.Retail
4MSFTMicrosoft CorporationTechnology
5FBFacebook, Inc.Technology

portfolio

idinvestorIDstockIDsharesOwned
(→ investors.investorID)(→ stocks.stockID)
111100
22350
33175
442100
55350

earnings

earningsIDdateEPSinvestorIDstockID
(→ investors.investorID)(→ stocks.stockID)
12021-06-303.011
22021-09-304.022
32021-12-313.531
42021-09-302.842
52021-12-314.253

prices

priceIDdatesharePriceinvestorIDstockID
(→ investors.investorID)(→ stocks.stockID)
12021-06-30150.011
22021-09-30160.022
32021-12-31155.031
42021-09-30170.042
52021-12-31165.053