NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ832869
Record Type: Journal
Publication Date: 2007
Pages: 6
Abstractor: As Provided
Reference Count: 5
ISSN: ISSN-1055-3096
Specification and Enforcement of Semantic Integrity Constraints in Microsoft Access
Dadashzadeh, Mohammad
Journal of Information Systems Education, v18 n4 p393-398 2007
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. (Contains 1 table and 4 figures.)
Journal of Information Systems Education (JISE). c/o Al Harris, JISE Editor, Department of Computer Information Systems, Walker College of Business, Appalachian State University, Boone, NC 28608. Tel: 828-262-6180; Fax: 828-262-6190; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A