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

A data model, called the entity-relationship model, which incorporates the semantic information in the real world is proposed. A special diagramatic technique is introduced for exhibiting entities and relationships. An example of data base design and description using the model and the diagramatic technique is given. The implications on data integrity, information retrieval, and data manipulation are discussed.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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