## Customers

CustomerID | FirstName | LastName | Email
--- | --- | --- | ---
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

## Accounts

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

## Stocks

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

## Investments

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

## Transactions

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

## PortfolioPerformance

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