Entity-Relationship Modeling Re-revisited
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”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  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 questionable. 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.
Unable to display preview. Download preview PDF.
- 1.Atzeni, P., Parker, D.S.: Assumptions in relational database theory. In: Proceedings of the 1st ACM Symposium on Principles of Database Systems (March 1982)Google Scholar
- 3.Batini, C., Ceri, S., Navathe, S.: Conceptual Database Design. Benjamin/Cummings (1992)Google Scholar
- 6.Connolly, T., Begg, C.: Database Systems, 3rd edn. Addison-Wesley, Reading (2002)Google Scholar
- 7.Dietrich, S., Urban, S.: Beyond Relational Databases. Prentice-Hall, Englewood Cliffs (to appear)Google Scholar
- 8.Dullea, J., Song, I.-Y.: An Analysis of Cardinality Constraints in Redundant Relationships. In: Proceedings of Sixth International Conferences on Information and Knowledge Management (CIKM 1997), Las Vegas, Nevada, USA, November 10-14, pp. 270–277 (1997)Google Scholar
- 10.Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 4th edn. Addison-Wesley, Reading (2003)Google Scholar
- 11.Genova, G., Llorenz, J., Martinez, P.: The meaning of multiplicity of n-ary associations in UML. Journal of Software and Systems Modeling 1(2) (2002)Google Scholar
- 14.MacLane, S.: Categories for the Working Mathematician. Springer, Heidelberg (1971)Google Scholar
- 17.Rumbaugh, J., Jacobson, I., Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, Reading (1999)Google Scholar
- 18.Song, I.-Y., Evans, M., Park, E.K.: A Comparative Analysis of Entity-Relationship Diagrams. Journal of Computer and Software Engineering 3(4), 427–459 (1995)Google Scholar
- 19.Teorey, T.: Database Modeling & Design, 3rd edn. Morgan Kaufmann, San Francisco (1999)Google Scholar