I have a table
persons with the columns
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.