The entity-relationship model: toward a unified view of data

A data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information in the real world. A special diagramatic technique is introduced as a tool for data base design. An example of data base design and description using the model and the diagramatic technique is given. Some implications on data integrity, information retrieval, and data manipulation are discussed.The entity-relationship model can be used as a basis for unification of different views of data: the network model, the relational model, and the entity set model. Semantic ambiguities in these models are analyzed. Possible ways to derive their views of data from the entity-relationship model are presented.

[1]  Claude Deheneffe,et al.  Relational Model for a Data Base , 1974, IFIP Congress.

[2]  John Mylopoulos,et al.  Using semantic networks for data base management , 1975, VLDB '75.

[3]  Thomas B. Steel.  Data Base Standardization - A Status Report , 1975, IBM Symposium: Data Base Systems.

[4]  Thomas B. Steel,et al.  Data base standardization: a status report , 1975, SIGMOD '75.

[5]  T. William Olle,et al.  Current and Future Trends in Data Base Management Systems , 1974, IFIP Congress.

[6]  E. SenkoM.,et al.  Data structures and accessing in data-base systems , 1973 .

[7]  E. F. Codd,et al.  A data base sublanguage founded on the relational calculus , 1971, SIGFIDET '71.

[8]  Donald D. Chamberlin,et al.  SEQUEL: A structured English query language , 1974, SIGFIDET '74.

[9]  Charles W. Bachman,et al.  Trends in database management: 1975 , 1975, AFIPS '75.

[10]  George G. Dodd.  APL: a language for associative data handling in PL/I , 1966, AFIPS '66 (Fall).

[11]  Paul Lindgreen,et al.  Basic Operations on Information as a Basis for Data Base Design , 1974, IFIP Congress.

[12]  Jean-Luc Hainaut,et al.  An Extensible Semantic Model of Data Base and Its Data language , 1974, IFIP Congress.

[13]  E. F. Codd,et al.  Normalized data base structure: a brief tutorial , 1971, SIGFIDET '71.

[14]  E. F. Codd,et al.  Recent Investigations in Relational Data Base Systems , 1974, ACM Pacific.

[15]  Donald D. Chamberlin,et al.  Functional specifications of a subsystem for data base integrity , 1975, VLDB '75.

[16]  Charles W. Bachman,et al.  Data structure diagrams , 1969, DATB.

[17]  Michael E. Senko,et al.  Data Description Language in the Concept of a Multilevel Structured Description: DIAM II with FORAL , 1975, IFIP TC-2 Special Working Conference on Data Base Description.

[18]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[19]  Robert W. Taylor,et al.  Observations on the Attributes of Database Sets , 1975, IFIP TC-2 Special Working Conference on Data Base Description.

[20]  Dennis Tsichritzis,et al.  A Network Framework for Relation Implementation , 1975, IFIP TC-2 Special Working Conference on Data Base Description.