I have a simple database that is supposed to manage tenants, houses and rent payment.
I input House details with fields as HouseID, HouseName, and ifOccupied(yes/no) fields.
THere is then another table that stores tenants details as they come in to rent the houses.
The house field in the tenants...