Synchronize from class diagram to ERD

Entity relationship diagrams (ERD) presents persistent structure of the database while class diagrams presents object structure in memory. There is alignment between ERD and class diagram, for example, the column in entity can map to attribute in class. VP-UML enables users to synchronize changes from class diagram to ERD, and vice versa.

  1. Select ORM-Persistable Class from the diagram palette.
    Create ORM-Persistable class
    Create ORM-Persistable class
  2. Click on the diagram to name it as Supplier, create attributes and association as follow.
    Create Supplier class
    Create Supplier class
  3. Add name attribute to Product_Type class.
    Create attribute
    Create attribute
  4. Right click on diagram, select Synchronize to Entity Relationship Diagram from the popup menu.
    Synchronize to Entity Relationship Diagram
    Synchronize to Entity Relationship Diagram
  5. A Synchronize to Entity Relationship Diagram dialog appears. Select Auto Generate in Select Primary Key table and rename the entity/column if necessary. Click OK button to continue.
    Synchronize to Entity Relationship Diagram dialog box
    Synchronize to Entity Relationship Diagram dialog box
  6. New entities and column are created on the ERD.
    Synchronized ERD
    Synchronized ERD