On Mapping Between UML and Entity-Relationship Model

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 Uni ed Modeling Language (UML) is expected to become more and more popular in ob ject-oriented analysis and design (OOA/OOD). As a byproduct of OOA/OOD, a database design can be derived by mapping of ob jects to entities. The purpose of this paper is to de ne 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.