| ClientID | FirstName | LastName | EmailAddress | PhoneNumber |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@email.com | +123456789 |
| 2 | Jane | Doe | janedoe@email.com | +987654321 |
| AccountID | ClientID | Balance | InterestRate |
|---|---|---|---|
| (→ Clients.ClientID) | |||
| 1 | 1 | 5000.0 | 0.05 |
| 2 | 2 | 10000.0 | 0.03 |
| LoanID | ClientID | Principal | InterestRate | TermYears | MonthlyPayment |
|---|---|---|---|---|---|
| (→ Clients.ClientID) | |||||
| 1 | 1 | 15000 | 0.06 | 5 | 400 |
| 2 | 2 | 20000 | 0.05 | 10 | 500 |
| ProductID | Name | Type | Price | CollateralizedDebtObligations | CollateralizedMortgageObligations | OtherValues |
|---|---|---|---|---|---|---|
| 1 | CDO1 | Collateralized Debt Obligation | 1000.0 | None | None | Details about CDO1 |
| 2 | CDO2 | Collateralized Debt Obligation | 1200.0 | None | None | Details about CDO2 |
| 3 | CMO1 | Collateralized Mortgage Obligation | 1000.0 | None | None | Details about CMO1 |
| 4 | CMO2 | Collateralized Mortgage Obligation | 1500.0 | None | None | Details about CMO2 |