Applications of the Entity-Relationship model

  • Peter Pin-Shan Chen
Part 2. Logical Data Base Design
Part of the Lecture Notes in Computer Science book series (LNCS, volume 132)


Database design is a very difficult problem. Recently, the Entity-Relationship Model has been found very useful in helping the database designer to identify the information needs of users, and to design logical data structures in databases. In this paper, an application of the Entity-Relationship Model to the design of an order entry database is presented. Applications of the Entity-Relationship Model to other areas (such as DBMS design, data semantics, and distributed databases) are also briefly discussed.


Product Model Entity Type Relationship Type Application Function Order Entry 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Chen, P.P.S. and Yao, S.B., "Design and Performance Tools for Data Base Systems," Proceedings of the Third International Conference On Very Large Data Base Conference, Tokyo. (Oct. 1977) pp. 3–15 (available through ACM).Google Scholar
  2. 2.
    Yao, S.B., Navathe, S. and Weldon, J.L.,:The Logical Database Design Process," NYU Working Paper #78-14(c).Google Scholar
  3. 3.
    Chen, P.P.S., "The Entity-Relationship Model: Toward a Unified View of Data," ACM Transactions on Database Systems 1, 1 (March 1976), 9–36.Google Scholar
  4. 4.
    Chen, P.P.S., "The Entity-Relationship Model: A Basis for the Enterprise View of Data," Proceedings of 1977 National Computer Conference. Dallas, Texas, AFIPS Conference Proceedings, Vol. 46 pp. 77–84.Google Scholar
  5. 5.
    Chen, P.P.S., The Entity-Relationship Approach To Logical Database Design. Q.E.D. Monograph Series, No. 6, 1977, Q.E.D Information Sciences, Inc., 141 Linden Street, Wellesley, MA. 02181.Google Scholar
  6. 6.
    Chen, P.P.S. (ed.), The Entity-Relationship Approach to Systems Analysis and Design, North-Holland Publishing Company, P.O. Box 211, 1000 AE, Amsterdam, The Netherlands, June 1980.Google Scholar
  7. 7.
    Chu, W.W. and Chen, P.P. (eds.), Tutorial:Centralized and Distributed Database Systems, IEEE Computer Society, 5855 Naples Plaza, Suite 301, Long Beach, CA 90803, October 1979.Google Scholar
  8. 8.
    Raver, N. and Hubbard, G.U., "Automated Logical Data Base Design: Concepts and Applications, IBM Systems Journal, Vol. 16, No. 3 (1977), pp. 287–312.Google Scholar
  9. 9.
    Hubbard, G.U., "Technique for Automated Logical Database Design," Proceedings of N.Y.U. Symposium on Database Design. (May 1978) N.Y.C.Google Scholar
  10. 10.
    Brown, R., Lecture Notes, UCLA and private communications.Google Scholar
  11. 11.
    Hall, P., Owlett, Todd, S., "Relations and Entities," Proceedings of IFIP TC-2 Working Conference, Jan. 1976, Black Forest, Germany 430–458.Google Scholar
  12. 12.
    Ho, Thomas, I.M., "New Perspectives for Information Systems Education," AFIP Conference Proceedings, Vol. 46, AFIPS Press, N.H. (1977 National Computer Conference), pp. 569–574.Google Scholar
  13. 13.
    Kahn, B.K., "A Method for Describing Information Required by the Database Design Process," Proceedings of ACM SIGMOD Conference, June 1976.Google Scholar
  14. 14.
    Moulin, P., Randon, J., Teboul, M.,, Conceptual Model as a Database Design Tool," Proceedings IFIP TC-2 Working Conference, Jan. 1976. Black Forest, Germany, 459–479.Google Scholar
  15. 15.
    Teorey, T.J. and Fry, J.P., "Logical Database Design: A Pragmatic Approach,: Technical Report 78 DE 12, Graduate School of Business Administration, University of Michigan, Ann Arbor, Michigan 48109.Google Scholar
  16. 16.
    Tozer, E.E., "Database Systems Analysis and Design," Technical report, Software Sciences Limited, England, April 1976.Google Scholar
  17. 17.
    Teichroew, D.,, "An Introduction to PSL/PSA, "University of Michigan, Dept. of Industrial Engineering, ISDOS Working Paper #86, Marnh, 1974.Google Scholar
  18. 18.
    Poonen, George, "CLEAR: A conceptual Language for Entities and Relationships,: Proceedings of International Conference on Management of Data. Italy, June 1978. (also available through the author, Digital R&D Group, Digital Equipment Corporation, Maynard, Mass. 01754, U.S.A.)Google Scholar
  19. 19.
    Shoshani, Arie,"CABLE: A Language based on the Entity—Relationship Model." presented to the International Conference on Databases: Improving Usability and Responsiveness. Technion, Haifa, Israel, August 1978. (Oral presentation only) (also available through author: Computer Science and Applied Mathematics Department, Lawrence Berkeley Laboratory, Berkeley, CA 94720,USA)Google Scholar
  20. 20.
    Deheneffe, C. and Hennebert, H., "NUL: A Navigation User's Language for a Network Structured Database." Proceedings ACM 1976 SIGMOD Conference, Washington D.C., June 1976, 135–142.Google Scholar
  21. 21.
    Lee, R.M. and Gerritsen, R., "A Hybrid Representation for Database Semantics,: Working paper #78-10-10, Department of Decision Sciences, Wharton School, University of Pennsylvania, Philadelphia, Pennsylvania 19104, USAGoogle Scholar
  22. 22.
    Gardarin G. and Bihan J. Le, "An Approach Towards a Virtual Data Base Protocal for Computer Network: IRIA Working Paper. (available through one of the authors: J. Le Bihan, IRIA Domaine de Voluceau, BP/105-Rocquencourt, 78150, Le Chesnay, France.),Proceedings of AICA '77, Pisa, Italy, 1977.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1982

Authors and Affiliations

  • Peter Pin-Shan Chen
    • 1
  1. 1.Graduate School of ManagementUniversity of California, Los AngelesLos Angeles

Personalised recommendations