Ganga-236835 (4/25/2013)
Well, first they are not many to many then, and second it constrains the software development due to the inability for code reuse.
This doesn't really address the point I raised. If phone number is an attribute of [Person] or [Staff] or whatever, what would you gain by abstracting phone number into a separate table? Surely it can only cost more? Can you raise any argument which might support phone number not being an attribute of [Person]?
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