| CustomerID | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Doe | john@gmail.com | 123456789 |
| 2 | Jane | Smith | jane@gmail.com | 098765432 |
| 3 | Alice | Brown | alice@gmail.com | 555555555 |
| 4 | Bob | White | bob@gmail.com | 222222222 |
| 5 | Charlie | Black | charlie@gmail.com | 333333333 |
| AccountID | CustomerID | Balance |
|---|---|---|
| (→ Customers.CustomerID) | ||
| 1 | 1 | 5000.0 |
| 2 | 2 | 10000.0 |
| 3 | 3 | 20000.0 |
| 4 | 4 | 30000.0 |
| 5 | 5 | 40000.0 |
| InvestmentID | AccountID | StructuredFinanceVehicleType | PriceID | Quantity |
|---|---|---|---|---|
| (→ Accounts.AccountID) | (→ Pricings.PriceID) | |||
| 1 | 1 | Collateralized Debt Obligation | 1 | 100 |
| 2 | 2 | Collateralized Debt Obligation | 2 | 150 |
| 3 | 3 | Collateralized Mortgage Obligation | 3 | 100 |
| 4 | 4 | Collateralized Mortgage Obligation | 4 | 150 |
| 5 | 5 | Equity Fund | 5 | 200 |
| PriceID | Price |
|---|---|
| 1 | 1000.0 |
| 2 | 1200.0 |
| 3 | 1000.0 |
| 4 | 1200.0 |
| 5 | 1500.0 |