How to Model Subtype in ERD

When a few entities are subgrouped under a particular entity in an entity type, it means those entities share common attributes or relationships.

The following teaches you how to develop subtypes of Party in ERD:

  1. Open a new ERD through either Diagram Navigator or toolbar.
  2. Create an entity from diagram toolbar and name it as Party.

    Create an entity

    Create an entity

  3. Move the mouse over Party entity, press its resource icon One-to-One Relationship -> Entity and then drag it to your preferred place to create another entity. Name the newly created entity as Person.

    Create another entity through resource icon

    Create another entity through resource icon

  4. Right click the connector between Party and Person and select Subtype from the pop-up menu. The connector will then be changed as shown below:

    The connector is changed

    The connector is changed

  5. Create one more entity by following the previous steps. Name the entity as Organization.

    Create Organization entity

    Create Organization entity

  6. You can modify the two connectors linking to Party entity to indicate clearly that Person and Organization are subgrouped under Party.

    The completed ERD

    The completed ERD

How to try the sample

Download ERD and unzip it to get the .vpp file.

49 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply