Semantic Integrity Constraints:

 It is based on application semantics and cannot be expressed by the model per se
E.g., “the max. no. of hours per employee for all projects he or she works on is 56 hrs per week”
A constraint specification language may have to be used to express these

SQL-99 allows triggers and ASSERTIONS to allow for some of these.

0 comments