Converting a conceptual data model to a relational data model

A conceptual data model can be converted to a relational model. The conversion process e.g. resolves many-to-many relationships, reassigns relationship attributes and considers key dependencies.

It is possible to convert a conceptual data model from the main menu, from the explorer window and from the diagram.



The conversion process creates a new model. You can choose

  • To only convert the model in the active diagram or include all its submodels as well
  • The notation for the target model
  • To absorb optional relationships

Please note to

  • Cleanup the model
  • Verify integrity
before the conversion.

A conceptual model and its converted model are independent from each other, i.e. modifications made after the conversion will not be reflected in the converted model. Each following conversion will not update a previous result, but create another relational model.