## MarketSegments

SegmentID | SegmentName
--- | ---
1 | Technology
2 | Healthcare
3 | Energy

## Benchmarks

BenchmarkID | IndexValue | FactorIndex
--- | --- | ---
|  | (→ Factors.FactorID)
1 | 890.27 | 1
2 | 1234.56 | 2

## Factors

FactorID | FactorValue
--- | ---
1 | 0.75
2 | -0.25

## Products

ProductID | Name | MarketSegmentID | BenchmarkID
--- | --- | --- | ---
|  | (→ MarketSegments.SegmentID) | (→ Benchmarks.BenchmarkID)
1 | TechStockA | 1 | 1
2 | HealthStockB | 2 | 2

## Customers

CustomerID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## Transactions

TransactionID | Date | Amount | ProductID | CustomerID
--- | --- | --- | --- | ---
|  |  | (→ Products.ProductID) | (→ Customers.CustomerID)
1 | 2024-03-13 21:12:51 | 500.0 | 1 | 1
2 | 2024-03-13 21:12:51 | 750.0 | 2 | 2
3 | 2024-03-13 21:12:51 | 1000.0 | 1 | 2
4 | 2024-03-13 21:12:51 | 1500.0 | 2 | 1
5 | 2024-03-13 21:12:51 | 2000.0 | 1 | 1