1)Create 1 query that INSERTS 3 address VALUES and only INSERTS non-duplicate records in the home table. At least 1 address should be a duplicate of an address that already resides in the table.
2)Create 1 query that INSERTS 3 people into your people table. The query should make sure these entries exist and if they do only update the non-primary key information. 2 of the VALUES should be entries already existing in you table