In planning my database I have clients where thereUpload ImagesLink Sherrie Branson 7 years ago
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.