Abstract
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 [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 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Atzeni, P., Parker, D.S.: Assumptions in relational database theory. In: Proceedings of the 1st ACM Symposium on Principles of Database Systems (March 1982)
Badia, A.: Entity-Relationship Modeling Revisited. SIGMOD Record 33(1), 77–82 (2004)
Batini, C., Ceri, S., Navathe, S.: Conceptual Database Design. Benjamin/Cummings (1992)
Camps Paré, R.: From Ternary Relationship to Relational Tables: A Case against Common Beliefs. SIGMOD Record 31(20), 46–49 (2002)
Chen, P.: The Entity-Relationship Model – towards a Unified View of Data. ACM Transactions on Database Systems 1(1), 9–36 (1976)
Connolly, T., Begg, C.: Database Systems, 3rd edn. Addison-Wesley, Reading (2002)
Dietrich, S., Urban, S.: Beyond Relational Databases. Prentice-Hall, Englewood Cliffs (to appear)
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)
Dullea, J., Song, I.-Y., Lamprou, I.: An Analysis of Structural Validity in Entity- Relationship Modeling. Data and Knowledge Engineering 47(3), 167–205 (2003)
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 4th edn. Addison-Wesley, Reading (2003)
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)
Jones, T., Song, I.-Y.: Analysis of binary/ternary cardinality combinations in entityrelationship modeling. Data & Knowledge Engineering 19(1), 39–64 (1996)
Jones, T., Song, I.-Y.: Binary Equivalents of Ternary Relationships in Entity- Relationship Modeling: a Logical Decomposition Approach. Journal of Database Management 11(2), 12–19 (2000)
MacLane, S.: Categories for the Working Mathematician. Springer, Heidelberg (1971)
Markowitz, V., Shoshani, A.: Representing Extended Entity-Relationship Structures in Relational Databases: A Modular Approach. ACM Transactions on Database Systems 17(3), 423–464 (1992)
McAllister, A.: Complete rules for n-ary relationship cardinality constraints. Data & Knowledge Engineering 27, 255–288 (1998)
Rumbaugh, J., Jacobson, I., Booch, G.: The Unified Modeling Language Reference Manual. Addison-Wesley, Reading (1999)
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)
Teorey, T.: Database Modeling & Design, 3rd edn. Morgan Kaufmann, San Francisco (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Goelman, D., Song, IY. (2004). Entity-Relationship Modeling Re-revisited. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, TW. (eds) Conceptual Modeling – ER 2004. ER 2004. Lecture Notes in Computer Science, vol 3288. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30464-7_5
Download citation
DOI: https://doi.org/10.1007/978-3-540-30464-7_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-23723-5
Online ISBN: 978-3-540-30464-7
eBook Packages: Springer Book Archive