Journal of Information Systems Education (JISE)

Volume 18

Volume 18 Number 4, Pages 393-398

Winter 2007


Teaching Tip
Specification and Enforcement of Semantic Integrity Constraints in Microsoft Access


Mohammad Dadeshzadeh
Oakland University
Rochester, MI 48309, USA

Abstract: Semantic integrity constraints are business-specific rules that limit the permissible values in a database. For example, a university rule dictating that an incomplete grade cannot be changed to an A constrains the possible states of the database. To maintain database integrity, business rules should be identified in the course of database design and must be enforced during database implementation. Unfortunately, the manner by which current database management systems (DBMS) support the specification and enforcement of semantic integrity constraints varies considerably. This paper categorizes semantic integrity constraints and presents a simple approach for teaching users how to implement each of the five categories in Microsoft Access.

Keywords: Database management systems, Semantic integrity constraints, Validation rules, SQL, Microsoft Access

Download this article: JISE - Volume 18 Number 4, Page 393.pdf


Recommended Citation: Dadashzadeh, M. (2007). Teaching Tip: Specification and Enforcement of Semantic Integrity Constraints in Microsoft Access. Journal of Information Systems Education, 18(4), 393-398.