I just got following entities Employee, Client and Company. Where Employee and Client have one to many relationship with Company ie A single employee may be mapped to attend to many companies and same for clients too. How would i design a optimized table for this situation. I had thought of below
but since it is one to many companyid would have to be saved as comma seperated company id's. What do i do in this situation.