Entity-relationship modeling re-revisited

Paper presented at the 23rd International Conference on Conceptual Modeling (ER 2004), Shanghai, China, November 2004. Lecture Notes in Computer Science 3288, pp. 43-52 (http://springerlink.metapress.com/link.asp?id=xt88y6nmtyabjdlv). Retrieved 6/26/2006 from http://www.cis.drexel.edu/faculty/song/publications/p_ER_Revisited_ER2004-Final.pdf.Since its introduction, the Entity-Relationship (ER) model has been the vehicle of choice in communicating the structure of a database schema in an implementation-independent fashion. Part of its popularity has no doubt been due to the clarity and simplicity of the associated pictorial Entity-Relationship Diagrams (“ERD’s”) and to the dependable mapping it affords to a relational database schema. Although the model has been extended in different ways over the years, its basic properties have been remarkably stable. Even though the ER model has been seen as pretty well “settled,” some recent papers, notably [4] and [2 (from whose paper our title is derived)], have enumerated what their authors consider serious shortcomings of the ER model. They illustrate these by some interesting examples. We believe, however, that those examples are themselves flawed. In fact, while not claiming that the ER model is perfect, we do believe that the overhauls hinted at are probably not necessary and possibly counterproductive