Abstract
Nowadays, the Entity-Relationship Model (ERM) is the most important and widely used method for modeling data and designing databases. On the other hand, the Unified Modeling Language (UML) is expected to become more and more popular in object-oriented analysis and design (OOA/OOD). As a by-product of OOA/OOD, a database design can be derived by mapping of objects to entities. The purpose of this paper is to define a mapping between UML and ERM. The translation of a UML class diagram to and from an ER diagram is also elaborated. This work is part of a multi-model multi-tool database application engineering framework that is being designed and prototyped at University Konstanz.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
BATINI, C., CERI, S., and NAVATHE, S. (1992): Conceptual Database Design: An Entity-Relationship Approach. The Benjamin/Cummings Publishing Company, Inc., California.
BOOCH, G., RUMBAUGH, J., and JACOBSON, I. (1997): Unified Modeling Language, Version 1.0. Rational Software Corporation, 2800 San Tomas Expressway, Santa Clara, CA 95051–0951 (USA), URL: http://www.rational.com
BOOCH, G. (1994): Object-Oriented Analysis and Design with Applications, Second Edition. The Benjamin/Cummings Publishing Company, Inc., California.
CHEN, P. P. (1976): The Entity-Relationship Model — Toward a Unified View of Data. ACM Transactions on Database Systems, Vol. 1, No. 1, 9–36.
ELMASRI, R. and NAVATHE, S.B. (1994): Fundamentals of Database Systems, Second Edition. The Benjamin/Cummings Publishing Company, Inc., California.
HAINAUT, J.-L., ENGLEBERT, V., HENRARD, J., HICK, J.-M., ROLAND, D. (1994): Database Evolution: the DB-MAIN Approach. In: P. Loucopoulos (Ed.): Proceedings of the conference on the ER Approach — ER’94. LNCS, Springer-Verlag, Germany, 112–131.
JACOBSON, I., CHRISTERSON, M., JONSSON, P., and OVERGAARD, G. (1992): Object- Oriented Software Engineering. Workingham, England, Addison-Wesley Publishing Company.
RUMBAUGH, J., BLAHA, M., PREMERLANI, W., EDDY, F., and LORENSEN, W. (1991): Object-Oriented Modeling and Design. Englewood Cliffs, New Jersey, Prentice-Hall.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Physica-Verlag Heidelberg
About this paper
Cite this paper
Ou, Y. (1998). On Mapping Between UML and Entity-Relationship Model. In: Schader, M., Korthaus, A. (eds) The Unified Modeling Language. Physica-Verlag HD. https://doi.org/10.1007/978-3-642-48673-9_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-48673-9_4
Publisher Name: Physica-Verlag HD
Print ISBN: 978-3-7908-1105-6
Online ISBN: 978-3-642-48673-9
eBook Packages: Springer Book Archive