Auto Generalization

I am a newbie and I am looking for a software where I do following:-

  1. create ERD
  2. Generate class diagram from ERD
  3. Create auto generalization classes from generated class diagram, I mean creating sub classes of duplicate fields.

Can visual paradigm help me on this ?

Thanks / Luqman

Hi luqmanusman,

Thank you for your post. The Standard Edition of Visual Paradigm (desktop) fits your needs. Some of the related features:

  • ERD modeling tool
  • UML modeling tool
  • Generate/Update class diagram from ERD
  • Generate/Update ERD from class diagram
  • Generate database from ERD
  • Generate ORM from ERD / class model

More about database modeling and engineering
https://www.visual-paradigm.com/features/database-engineering-tools/

Visual Paradigm download page:
https://www.visual-paradigm.com/download/

I am not fully clear about your point 3 though. Could you explain a bit more? Perhaps with an example or diagrams.

Look forward to hearing from you.

Best regards,
Jick Yeung

Hi Jick,

Regarding my point no. 3, say I have generated 2 classes from ERD, with the common field: CustomerID.

Class1
CustomerID : int
CustomerName: String

Class2
OrderNo: int
OrderDate: Date
CustomerID: int

Now, I want your software to auto detect the common fields ie. customerID in both the classes and create a new subclass ie Class3 of CustomerID, and remove the CustomerID from Class1 and Class2.

So, final shape will be as under;-

Class1
CustomerName: String

Class2
OrderNo: int
OrderDate: Date

Class3
CustomerID: int

And class3 will be connected to Class1 and Class2 with Generalization Arrow.

Hope you understand what I mean.

Thanks / Luqman

Hi Luqman,

Thank you for your explanation. While the situation you described may be true, it is not always true. For example, both the entity “Student” and “School” can have the “Name” column but they certainly do not share the same superclass. Therefore, we do not support the behavior you described.

Best regards,
Jick Yeung