I need to create a schedule where I allocate a service provider to work for a client.
Eg: The Service Provider John will provide services to the customer condo valley of the sun on the day March 15, 2016 from 10:00 am to 12:00 .
John can not be registered on the same day / time for another client.
Having the Service Provider table with name and PK , Client with SocialSource and PK client_code and Scheduling with DateTime Start, End DateTime, FK_Polder, FK_Customer, and PK
How do I ensure that a service provider is never allocated to different clients at the same time?