Enforcement of Semantic Integrity Constraint{2}


by David H
This article discuss about how using semantic integrity approach to help the user on how to implement each of five categories in Microsoft Access. In addition, we need to apply the business rule to assert the structure to control the behavior of business. The author also demonstrates there are two categories of semantic integrity constraint which are static and dynamic. By the definition static integrity constraint are those constraints that can be determined to have been violated or when transaction have to be change.  However, there are four types in static integrity constraints which are domain type, tuple type, relation type, and database type. Each of these types has unique characteristic which is limit the value and determines whether the value is out of the range or not. Domain type restricts on values for data field. Tuple type restricts on values data field base on other data field in the same record. Relation type restricts on values base on values of other record that have same table. Database type restricts on value base on the value in other record of other table in database. Dynamic integrity constraint is condition that involve of fact of two or more states of database.

This article is related to class because this article gives us more details about integrity constraint type. Last class, we have been discussed three type of integrity constraint which are domain constraints, entity integrity, and referential integrity but we didn’t get much detail into the constraint type. I think this article is very helpful and useful because it helps us to have better understanding on how does semantic integrity constraint work in database. It is very important to apply these constraints to database because it maintains the accuracy and integrity of data in the database.

 

Reference

Dadashzadeh, M. (2007). Specification and enforcement of semantic integrity constraints in microsoft access. Journal of Information Systems Education, 18(4), 393-398.