Designing a database tables for the following scenario 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

Employee:

Id

Name

CompanyId

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.
Assuming a company can be "attended to" by more than one employee, and likewise for client, you would model like this:



So both relations are 'many:many'. As gbn also said, adding "comma separated ids" would be something of a disaster in database design: you would regret it many times over.