I hope I'm asking this question correctly, and I welcome any suggestions. I am in the process of setting up my ER diagram. I've reached a point where I'm not sure exactly the best way to construct a table(s).
There are 3 tables involved in this scenario
So here's the issue, which I will try to write out. A person (people table) can have a single insurance company (insurance table). They also can have a single supplier (supplier table). The issue is that each supplier can accept multiple insurers. I can't, however, link the insurance table to the supplier table because it's already linked to the people table. I want to avoid having to create a table with the exact same information in it, but I'm not sure if that's possible. Perhaps there's a workaround that I just don't know about?