Abstract
In the world of Information Systems, the Entity-Relationship model (first defined by Chen in 1976) is widely taught and also widely used in practice. Despite the fact that the ER model is commonly considered a conceptual data model, it violates the Conceptualisation Principle as defined in the International Standards Organization report of 1982. In this paper, we will show that the ER model contains too many different ways to represent (or encode) the same proposition (or fact). Indeed, it is possible to claim that the ER model is essentially a reincarnation of the CODASYL DDL/DML model (as defined in the CODASYL DBTG report of 1971).
As the number of fact-encoding mechanisms increases, so must the complexity of any design procedure. This means that it is very difficult to provide the ER designer with effective prescriptive guidance on how to perform the design task.
The ER graphical notation is often claimed to be a good medium for communication between the users and the EDP professionals. We will show that this graphical notation does not support effective validation procedures that involve the user (the only person who truly knows the semantics of the application).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Batini, C., 1987, Position Statement: E-R Modelling Versus Binary Modelling, Proceedings of the 6th Conference on the Entity-Relationship Approach.
Chen, P. P., 1976, The Entity-Relationship Model–Toward a Unified View of Data, ACM Transactions on Database Systems, Vol. 1, No. 1, March 1976, pp. 9–36.
CODASYL: Database Task Group Report,1971, ACM, New York.
Codd, E. F., 1970, A Relational Model of Data for Large Shared Data Banks, Communications of the ACM, Vol. 13, No. 6, June 1970.
Date, C. J., 1986, An Introduction to Database Systems (Volume 1, 4th Edition),Addison-Wesley.
Dogac, A., and Chen, P. P., 1983, Entity-Relationship Model in the ANSI/SPARC Framework, Entity-Relationship Approach to Infonnation Modelling and Analysis, Chen, P. P., ed., North-Holland, pp. 357–374.
Falkenberg, E., 1982, Foundations of the Conceptual Schema Approach to Information Systems, Lecture Notes of the NATO Advanced Study Institute on Database Management and Applications, June 1–13, 1981, Portugal, North-Holland.
Kent, W., 1983, A Simple Guide to Five Normal Forms in Relational Database Theory, Communications of the ACM, Vol. 26, No. 2, February 1983.
Kent, W., 1986, The Realities of Data: Basic Properties of Data Reconsidered, Proceedings of IFIP Conference on Data Semantics (DS-1), Steel, T. B., Jr., and Meersman, R., eds., Elsevier, North-Holland, pp. 175–188.
Meersman, R., 1988, Towards Models for Practical Reasoning about Conceptual Database Design, Database Semantics (DS-2), Meersman, R., and Sernadas, A., eds., NorthHolland.
Michie, D., 1983, Inductive Rule Generation in the Context of the Fifth Generation, Proceedings of the International Machine Leaming Workshop, pp. 65–70.
Nijssen, G. M., 1975, Two Major Flaws in the CODASYL DDL 1973 and Proposed Corrections, Information Systems 1, Pergamon, pp. 114–132.
Nijssen, G. M., 1986, On Experience with Large-Scale Teaching and Use of Fact-based Conceptual Schemas in Industry and University, Proceedings of IFIP Conference on Data Semantics (DS-1), Meersman, R., and Steel, T. B., Jr., eds., Elsevier North-Holland.
Nijssen, G. M., and Halpin, T. A., 1989, Conceptual Schema and Relational Database Design: A Fact-Based Approach,Prentice-Hall.
Parent, C., and Spaccapietra, S., 1985, Enhancing the Operational Semantics of the Entity-Relationship Model, Database Semantics DS-1, Steel, T. B., jr., and Meersman, R., eds., Elsevier North-Holland.
Rosenthal, A., and Reiner, D., 1987, Theoretically Sound Transformations for Practical Database Design, Proceedings 6th Conference on the Entity-Relationship Approach.
Sowa, J. F., 1988, Knowledge Representation in Databases, Expert Systems, and Natural Language, Proceedings IFIP WG2.6/WG8.1 Conference on the Role of Artificial Intelligence in Databases and Expert Systems, Guangzhou, China, July 1988.
Teorey, R. J., Yang, D., and Fry, J. P., 1986, A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model, Computing Surveys, Vol. 18, No. 2, June 1986, pp. 197–222.
Tsichritzis, D. C., and Lochovsky, F. H., 1976, Hierarchical Database Management: A Survey, ACM Computing Surveys, Vol. 8, No. 1, March 1976.
Twine, S., 1988(a), Towards a Knowledge Engineering Procedure, Proceedings Expert Systems ‘88, Brighton, UK, December 1988.
Twine, S., 1988(b), From Information Analysis Towards Knowledge Analysis, Proceedings 2nd European Workshop on Knowledge Acquisition for Knowledge-Based Systems, Bonn, Federal Republic of Germany, June 1988.
van Griethuysen, J. J., ed., 1982, Concepts and Tenninology for the Conceptual Schema and the Information Base,Report of ISO TC97/SC5/WGS.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1990 Plenum Press, New York
About this chapter
Cite this chapter
Nijssen, G.M., Duke, D.J., Twine, S.M. (1990). The Entity-Relationship Data Model Considered Harmful. In: Zunde, P., Hocking, D. (eds) Empirical Foundations of Information and Software Science V. Springer, Boston, MA. https://doi.org/10.1007/978-1-4684-5862-6_10
Download citation
DOI: https://doi.org/10.1007/978-1-4684-5862-6_10
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4684-5864-0
Online ISBN: 978-1-4684-5862-6
eBook Packages: Springer Book Archive