Customers

CustomerIDFirstNameLastName
1JohnSmith
2JaneDoe
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
112000.0
223000.0
334000.0
445000.0
556000.0

Transactions

TransactionIDAccountNumberAmountTransactionDate
(→ Accounts.AccountNumber)
11200.02024-02-19 15:02:11
22300.02024-02-19 15:02:11
33400.02024-02-19 15:02:11
44500.02024-02-19 15:02:11
55600.02024-02-19 15:02:11

Shares

ShareIDStockNumberOfShares
1ABC Corporation100
2XYZ Inc.200
3PQR Ltd.300
4LMT LLC400
5KLM & Co.500

ShareTransactions

ShareTransactionIDBuyOrSellCustomerIDShareIDQuantityPriceCommission
(→ Customers.CustomerID)(→ Shares.ShareID)
1BUY1110100.05.0
2SELL11595.04.75
3BUY222080.08.0
4SELL22875.06.0
5BUY331570.07.5

Dividends

DividendIDShareIDDividendAmountExpectedPaymentDateDividend_PercentageDividend_Value
(→ Shares.ShareID)
1110.02023-06-012.020.0
225.02023-06-151.010.0
338.02023-07-012.024.0
443.02023-07-151.06.0
5512.02023-08-013.036.0