I want to store the details of people and their contact details, but I am not sure how to go about it. I need the database to be able to link people who have the same contact details together, e.g. Mr and Mrs Smith live together, so I only want to store their contact details once in the database. This is what I have so far:
Member ID (Primary Key)
Date of Birth
Phone No. could be a PK of the Contact table, but so could (Flat/House No. & Street Name & Town/City).