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 |