In planning my database I have clients where there might be multiple providers caring for them, as well as other multiple parties that might be providing input that are not related to the providers.  Am I correct that I would create at least three tables in this scenario?  One for clients; one for providers; and one for non-provider entities.  I would also like to track provider expenses for each client. Is this yet another table?  Thank you!

---

Reply from Alex Hedley:

Yep, just add a Table for each.
You could also use a Junction table say ClientXProvider where you join them so you know which Client has which Provider
See this blog post.