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 | OtherValues |
---|---|---|---|---|
1 | CDO1 | Collateralized Debt Obligation | 1000.0 | Details about CDO1 |
2 | CDO2 | Collateralized Debt Obligation | 1200.0 | Details about CDO2 |
3 | CMO1 | Collateralized Mortgage Obligation | 1000.0 | Details about CMO1 |
4 | CMO2 | Collateralized Mortgage Obligation | 1500.0 | Details about CMO2 |