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 about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of database design and description using the model and the diagrammatic technique is given. Some implications for 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]  Dennis McLeod,et al.  Semantic integrity in a relational data base system , 1975, VLDB '75.

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

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

[4]  Søren Lauesen,et al.  A large semaphore based operating system , 1975, CACM.

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

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

[7]  Hans Albrecht Schmid,et al.  On the semantics of the relational data model , 1975, SIGMOD '75.

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

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

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

[11]  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.

[12]  Edgar H. Sibley,et al.  On the equivalences of data based systems , 1975, SIGFIDET '74.

[13]  Naftaly H. Minsky,et al.  Another look at data-bases , 1974, SGMD.

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

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

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

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

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

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

[20]  Michael E. Senko,et al.  Data Structures and Accessing in Data-Base Systems. I: Evolution of Information Systems , 1973, IBM Syst. J..

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

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

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

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