I'm not sure that your example that Address_2 should allow NULLs is particularly convincing.

The approach I was taught (and still follow) is that if NULL "means something" in relation to...