Welcome to the InfoSci Platform
Reference Hub3
Enhancing the ER Model with Integrity Methods

Enhancing the ER Model with Integrity Methods

Mira Balaban, Peretz Shoval
Copyright: © 1999 |Volume: 10 |Issue: 4 |Pages: 10
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781466638112|DOI: 10.4018/jdm.1999100102
Cite Article Cite Article

MLA

Balaban, Mira, and Peretz Shoval. "Enhancing the ER Model with Integrity Methods." JDM vol.10, no.4 1999: pp.14-23. http://doi.org/10.4018/jdm.1999100102

APA

Balaban, M. & Shoval, P. (1999). Enhancing the ER Model with Integrity Methods. Journal of Database Management (JDM), 10(4), 14-23. http://doi.org/10.4018/jdm.1999100102

Chicago

Balaban, Mira, and Peretz Shoval. "Enhancing the ER Model with Integrity Methods," Journal of Database Management (JDM) 10, no.4: 14-23. http://doi.org/10.4018/jdm.1999100102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Entity Relationship (ER) schemas include cardinality constraints, that restrict the dependencies among entities within a relationship type. The cardinality constraints have direct impact on application transactions, since insertions or deletions of entities or relationships might affect related entities. Application transactions can be strengthened to preserve the consistency of a database with respect to the cardinality constraints in a schema. Yet, once an ER schema is translated into a logical database schema, the direct correlation between the cardinality constraints and application transaction is lost, since the components of the ER schema might be decomposed among those of the logical database schema. We suggest to extend the Enhanced ER (EER) data model with integrity methods that take the cardinality constraints into account. The integrity methods can be fully defined by the cardinality constraints, using a small number of primitive update methods, and are automatically created for a given EER diagram. A translation of an EER schema into a logical database schema can create integrity routines by translating the primitive update methods alone. These integrity routines may be implemented as database procedures, if a relational DBMS is utilized, or as class methods, if an object-oriented DBMS is utilized.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.