I have a table persons
with the columns per_id
, per_passport
, per_name
and per_address
.
Two or more persons can live in the same address (like families or room-mates) so if this happened, the data is repeated. I think it should be avoided due to a normal form.
So should I create a table addresses
to store all the addresses of the persons?
Also some persons may be in the home address or in the work address. It means persons can have multiple addresses. So should I create a per_add
intermediate table?
I have the same problem to store email addresses and phone numbers.
I use PostgreSQL.