Database conceptual modeling for integrating E-A model and E-R model

Abstract

Efficient database design and construction is one of the most difficult and hard tasks for constructing information systems. During the database designing process, we have performed data modeling for understanding real world and business process easily. There is E-R model using entity and relationship between entities for supporting data modeling. Unlike E-R model, there is E-A model using specific aspects. Both of these models define entities and are modeling with relationship, so we have understood easily complex real world. E-R model is good for defining entity and relationship, but restrict concepts of abstraction and inheritance. In this paper, we propose a database conceptual modeling procedure, called I-ER modeling, through analyzing similarity and difference between E-A and E-R, applying abstraction concepts of E-A model. Using the I-ER(Improved E-R) modeling we can understand easily real world complexity for modeling entities and relationship.