database - Resolve many to many relationship -

Is there a process or approach to determining how to reload multiple-to-many leaks in a relational database? ? Here's my scenario. I have a group of contacts and a group of phone numbers. Each contact can be linked to several phone numbers and each phone number can be connected to multiple contacts.

A simple example of this situation is two Negatives (E1 and A2), a main voice line (v1), a private voice line (v2). E1 is the CEO therefore their own voice line, V1, but can be reached by asking for main line, v2, and CEO. E2 is just an employee and can only be reached by calling V2.

So, E1 should be related to v1; V2 E2 should be related to v2 In contrast, v1 should be related to e1 and v2 should be e1 & amp; E2.

The goal here is to be able to run questions such as "Can be reached at number 1" and "Whether employees can be reached on v2" etc. On intermediate tables or tables, I have the right architecture Unable to nail.

employee:

  eID, eName 1, e1 2, e2  

Phone number:

  pID, pNumber 1, v1 2, v2  

employee phones:

  EID, PID1, 1, 2, 2, 2  

Then you get connected from inside. If you need to know what reached number (s) (T-SCL):

SELECT E.EName, PPNMER FO debobo. Economic E Inner JOIN Job Debo. E.E.D. at Empirefiffe EP. EPEID Inner Join DB.PONIPIPID = PEED where EE name = 'E1' I believe this work (Test this now ...)

EDIT: I took a few minutes to type, sorry for the repetition ...