Modeling dynamic relationship types for subsets of entity type instances and across entity types

0
99

Authors: Anushree Khandekar, Kamalakar Karlapalem, P. Radha Krishna

Tags: 2016, conceptual modeling

In a traditional ER model, once we specify a subclass or superclass relationship, any changes to that relationship are treated as schema evolution. Further, ER models are rigid in the sense that once a relationship type is specified across a set of entity types, an instance of relationship type occur when one instance of all participating entity types are specified. Therefore, it is difficult to introduce in a simplified manner all relationship types across subsets of given set of entity types. In this paper, we provide mechanisms to model in our extended ER model: (i) specification of dynamic relationship types across subsets of instances of entity types, (ii) a simplified specification of relationships across subsets of given set of entity types, and (iii) mapping our extended ER model to relational database schema. We also show through an e-contract example the utility of our extended ER model.

Read the full paper here: https://www.journals.elsevier.com/information-systems