| id | city | median_home_price |
|---|---|---|
| 1 | New York | 650000.0 |
| 2 | Los Angeles | 780000.0 |
| 3 | Chicago | 390000.0 |
| 4 | Miami | 550000.0 |
| 5 | San Francisco | 1200000.0 |
| agent_id | name | years_experience |
|---|---|---|
| 1 | John Doe | 10 |
| 2 | Jane Smith | 5 |
| 3 | Michael Brown | 15 |
| 4 | Emily Johnson | 7 |
| 5 | William Davis | 20 |
| agency_id | name | rating |
|---|---|---|
| 1 | Fannie Mae | AAA |
| 2 | Freddie Mac | AAA |
| 3 | Ginnie Mae | AA+ |
| 4 | Quicken Loans | A+ |
| 5 | Wells Fargo Home Mortgage | A+ |
| program_id | description | interest_rate |
|---|---|---|
| 1 | Conventional Loan | 3.5 |
| 2 | Adjustable Rate Mortgage | 3.25 |
| 3 | Fixed-Rate Mortgage | 3.75 |
| 4 | First-Time Home Buyer Program | 3.25 |
| 5 | VA Loan | 2.75 |
| housing_finance_agency_id | loan_program_id |
|---|---|
| (→ Housing_Finance_Agencies.agency_id) | (→ Loan_Programs.program_id) |
| 1 | 4 |
| 2 | 4 |
| 3 | 4 |
| 4 | 4 |
| 5 | 4 |
| 5 | 1 |