hi all.
Imagine a situation. There is a big company which has many service centers. These service centers provide different service types - some of them replace car tires, others repair engines, and other ones fill petrol or another fuel.

    No we have the following:

Table of service centers
------------------------
ID
name
address

Table of service types
----------------------
ID
name

Table of work types
-------------------
ID
service_type_ID
name

Now i bind service centers and service types

bind_table
--------------------------------------------
service_center_ID
service_type_ID

And now i want to log which works were done on each service center

Table "works"
-------------
ID (to refer it later in material consumption table etc...)
date_time (date when the work was done)
service_center_ID
work_type_ID

Seems like it's ok, but it is possible to write incorrect record for example work "tire replacement" on service point which only repairs engines (as specified in bind_table). Is it possible to avoid such errors at database level?