## Housing_Market

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

## RealEstateAgents

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

## Housing_Finance_Agencies

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+

## Loan_Programs

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_Agencies_Loan_Programs

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