Looking at the dbo.NextOfKin and dbo.Addresses tables I would remove the NextofKin FK2 from the dbo.Addresses table and have an AddressID FK inserted into the dbo.NextOfKin table instead.

This would then make it similar to the way the dbo.User_Profile table uses the AddressID, as it has an AddressID in it as a foreign key.