I have a <person> table, a <house> table and need to register people's tenancy in these houses.
First thought is to create a <tenancy> table with foreign keys to <person> and <house> tables. So far so good.
A tenancy will have a start date and an end date, no problem there. However, a...