Abstract
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.
The major part of this research was performed when the author was affiliated with the Sloan School of Management, Massachusetts Institute of Technology, Cambridge, Massachusetts 02139. This research was supported in part by the National Science Foundation, Grant No. MCS 78-20005 and MCS 77-20829.
Preview
Unable to display preview. Download preview PDF.
References
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).
Yao, S.B., Navathe, S. and Weldon, J.L.,:The Logical Database Design Process," NYU Working Paper #78-14(c).
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.
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.
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.
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.
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.
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.
Hubbard, G.U., "Technique for Automated Logical Database Design," Proceedings of N.Y.U. Symposium on Database Design. (May 1978) N.Y.C.
Brown, R., Lecture Notes, UCLA and private communications.
Hall, P., Owlett, Todd, S., "Relations and Entities," Proceedings of IFIP TC-2 Working Conference, Jan. 1976, Black Forest, Germany 430–458.
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.
Kahn, B.K., "A Method for Describing Information Required by the Database Design Process," Proceedings of ACM SIGMOD Conference, June 1976.
Moulin, P., Randon, J., Teboul, M., et.al., Conceptual Model as a Database Design Tool," Proceedings IFIP TC-2 Working Conference, Jan. 1976. Black Forest, Germany, 459–479.
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.
Tozer, E.E., "Database Systems Analysis and Design," Technical report, Software Sciences Limited, England, April 1976.
Teichroew, D., et.al., "An Introduction to PSL/PSA, "University of Michigan, Dept. of Industrial Engineering, ISDOS Working Paper #86, Marnh, 1974.
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.)
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)
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.
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, USA
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1982 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chen, P.PS. (1982). Applications of the Entity-Relationship model. In: Yao, S.B., Navathe, S.B., Weldon, J.L., Kunii, T.L. (eds) Data Base Design Techniques I:. DBDT 1978. Lecture Notes in Computer Science, vol 132. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-11214-6_5
Download citation
DOI: https://doi.org/10.1007/3-540-11214-6_5
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-11214-3
Online ISBN: 978-3-540-39051-0
eBook Packages: Springer Book Archive