Housing_Market

idcitymedian_home_price
1New York650000.0
2Los Angeles780000.0
3Chicago390000.0
4Miami550000.0
5San Francisco1200000.0

RealEstateAgents

agent_idnameyears_experience
1John Doe10
2Jane Smith5
3Michael Brown15
4Emily Johnson7
5William Davis20

Housing_Finance_Agencies

agency_idnamerating
1Fannie MaeAAA
2Freddie MacAAA
3Ginnie MaeAA+
4Quicken LoansA+
5Wells Fargo Home MortgageA+

Loan_Programs

program_iddescriptioninterest_rate
1Conventional Loan3.5
2Adjustable Rate Mortgage3.25
3Fixed-Rate Mortgage3.75
4First-Time Home Buyer Program3.25
5VA Loan2.75

Housing_Finance_Agencies_Loan_Programs

housing_finance_agency_idloan_program_id
(→ Housing_Finance_Agencies.agency_id)(→ Loan_Programs.program_id)
14
24
34
44
54
51