CustomerID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Emma | Wilson | emma.wilson@example.com |
5 | David | Jackson | david.jackson@example.com |
AccountNumber | Balance | InterestRate | OpenDate | CustomerID |
---|---|---|---|---|
(→ Customers.CustomerID) | ||||
1 | 1000.0 | 2.0 | 2023-01-01 | 1 |
2 | 800.0 | 1.5 | 2023-01-02 | 2 |
3 | 700.0 | 1.0 | 2023-01-03 | 3 |
4 | 600.0 | 1.0 | 2023-01-04 | 4 |
5 | 900.0 | 2.5 | 2023-01-05 | 5 |
StockSymbol | CompanyName | CurrentPrice |
---|---|---|
AAPL | Apple Inc. | 150.0 |
GOOG | Alphabet Inc. | 2800.0 |
AMZN | Amazon.com Inc. | 130.0 |
MSFT | Microsoft Corporation | 300.0 |
TSLA | Tesla Inc. | 200.0 |
InvestmentID | AccountNumber | StockSymbol | Quantity | PurchaseDate |
---|---|---|---|---|
(→ Accounts.AccountNumber) | (→ Stocks.StockSymbol) | |||
1 | 1 | AAPL | 10 | 2023-01-01 |
2 | 1 | GOOG | 5 | 2023-01-01 |
3 | 2 | AMZN | 20 | 2023-01-02 |
4 | 2 | MSFT | 10 | 2023-01-02 |
5 | 3 | TSLA | 15 | 2023-01-03 |
PerformanceID | InvestmentID | Stock_Percentage | Stock_Value | Investment_Portfolios |
---|---|---|---|---|
(→ Investments.InvestmentID) | ||||
1 | 1 | 0.5 | 5000.0 | 1000.0 |
2 | 2 | 0.3 | 15000.0 | 4500.0 |
3 | 3 | 0.2 | 10000.0 | 2000.0 |
4 | 4 | 0.4 | 20000.0 | 8000.0 |
5 | 5 | 0.6 | 12000.0 | 7200.0 |
TransactionID | AccountNumber | Amount | Type | Date |
---|---|---|---|---|
(→ Accounts.AccountNumber) | ||||
1 | 1 | 200.0 | Deposit | 2023-01-01 |
2 | 1 | -50.0 | Withdrawal | 2023-01-02 |
3 | 2 | 300.0 | Deposit | 2023-01-03 |
4 | 2 | -100.0 | Withdrawal | 2023-01-04 |
5 | 3 | 150.0 | Deposit | 2023-01-05 |