Sean Lange (4/25/2013)
Personally I think this over complicates this greatly. The number of rows sharing the same phone number is likely going to be relatively small. There will be a performance hit to normalize to this point. It also adds a little more complexity which to me seems overkill.
Lynn Pettis (4/25/2013)
So, you want to store a phone number only once. You could have 100 people using the number 800-555-1212 and you want to store this only once in your database, correct?
No, the phone number is unique only to a single object and is not shared. In that sense it is a one to many relationship as the object could own multiple phone numbers.
G.
Btw, thanks everyone for contributing! 🙂