The Mapping from Entity Data Model to Relational Data Model

Entity Data Model (EDM) is a new conceptual model developed by Microsoft; it is a Platform-Independent and executable conceptual model. At present, EDM is mainly used for information integration, so Microsoft has developed the tools for transforming Platform Specific Models, such as Relational Data Model (RDM), to EDM. On other hand, EDM as a conceptual model can also be used for designing database, but currently there are few researches in this aspect. To an EDM based Database Design methodology, the transformation from EDM to RDM is very important, and which is based on the mapping from EDM components to RDM components. In this paper the mapping rules are studied and defined, and an algorithm for transforming EDM to RDM is proposed. We believe the research in this paper will enrich the use of EDM.