Ganga-236835 (4/26/2013)
ChrisM@Work (4/26/2013)
Those are 'organisations'...
Well, not quite. There could be multiple regional offices for "Organizations", with each one having their own unique set of phone numbers. Again, for the purposes of discussions, let's assume that abstracting to a higher level is not possible.
Or rather, if you want to assume that it is possible, that is fine too. You can proceed on the notion that you can abstract it up to 5 higher level objects which could own phone numbers.
The problem still remains as to how to create the "complex many to many" relationships of phone numbers to each of these 5 higher level objects.
G.
You're designing this system, it's not too late to design it properly. You should read Tom's excellent normalisation series of papers. I put links to them in my reply to him. Better still would be some more comment from him...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden