| 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 |
| 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 |
| PerformanceID | InvestmentID | Stock_Allocation | Investment_Portfolios |
|---|---|---|---|
| (→ Investments.InvestmentID) | |||
| 1 | 1 | 0.5 | 1000.0 |
| 2 | 2 | 0.3 | 4500.0 |
| 3 | 3 | 0.2 | 2000.0 |
| 4 | 4 | 0.4 | 8000.0 |
| 5 | 5 | 0.6 | 7200.0 |