Rooms

idroomType
1Living Room
2Bedroom
3Dining Room
4Kitchen
5Bathroom

HouseFeatures

idfeatureName
1Garage
2Pool
3Balcony
4Air Conditioning
5Fireplace

Houses

idaddresspricenumOfFloors
(→ Houses_Rooms.houseId)
1123 Main St300000.02
2456 Oak Ave400000.03
3789 Pine St500000.04
4101 Elm Blvd600000.03
5202 Maple Dr700000.02

Houses_Rooms

houseIdroomId
(→ Houses.id)(→ Rooms.id)
14
24
34
44
54
51