Get Access to World’s largest Template Library & Tools

How to Make a Supertype and Subtype in Microsoft Visio

With a wide selection of categories and templates, Microsoft Visio allows its users to create and flowcharts, diagrams, and floor plans with advanced but user-friendly tools and features. Convenience is also levelled up as editing and collaborating with friends in real-time are made possible with Microsoft Visio.

How to Make Supertype and Subtype in Microsoft Visio

Microsoft Visio offer various categories and types of diagrams for different purposes. The steps below will discuss how to make supertypes and subtypes in Microsoft Visio:

  • Step 1: Create a Diagram

    how to make a supertype and subtype in microsoft visio step 0

    To create an ERD or Entity Relationship Diagram, go to New and select Crow’s Foot Database Notation. If you can’t find it on the main selections, you can go to Categories, scroll down then click Software and Database. There you will find the Crow’s Foot Database along with other types of databases.

  • Step 2: Draw a Supertype Entity

    Begin forming the diagram by drawing the supertype entity, or basically the root of the hierarchy, by dragging the Entity stencil on the left-hand side of the screen. The entity will include the name or title and the attributes that describe it. For database, there are keys that must be identified which are Primary, Foreign, and Artificial—titles or names are generally determined as primary keys whether it is a supertype or a subtype but attributes can become either of the keys, too.

  • Step 3: Make Subtype Entity

    After filling out the title and attributes of the supertype, you now need to make the subtype or subtypes (depending on how many are appropriate to complete the database). Click the Entity stencil and drag it to the page, then fill out the title and attributes with data that are related that are similar to that of the supertype and that are necessary to make it more comprehensible. Moreover, just as supertypes can have as much subtypes, subtypes can also have subtypes of their own.

  • Step 4: Determine Relationship Between Entities

    how to make a supertype and subtype in microsoft visio step 0

    To distinguish the supertype from the subtype more, their relationship must be determined. Together with the Entity stencil is the Relationship stencil or simply the arrows that connect each entity present in the diagram. Click the stencil and drag it to the entity or attribute you want to connect together.

FAQs

What is a supertype entity?

A supertype is an entity type that is generic and has a relationship with one or more subtypes.

What is a subtype in Microsoft Visio?

A subtype is a sub-grouping of entities that is meaningful to the supertype and that shares a relationship with other sub-groups.

What is a primary key?

A primary key is an attribute or a list of attributes that identify a particular entity.

What is a foreign key?

A foreign key is an attribute or attributes that fulfill the relationship by determining the parent entity; also, it provides a method of sustaining the data’s integrity.

How to determine which is the end and beginning of the Relationship stencil in Microsoft Visio?

To determine which side is the end or beginning of the Relationship stencil, click the arrow and you will see two different dots on both ends—the solid dot signifies the beginning or root and the dot with an outer circle is the end.

More in Microsoft Office

How Can I Run Microsoft Visio on MacHow to Create Custom Shapes in Microsoft Visio
Microsoft PublisherHow to Use Microsoft SharePoint in Business
How to Edit Body Header in Microsoft VisioHow to Add Legend in Microsoft Visio
How to Flatten an Image in Microsoft PublisherHow to Add a Subscript/Superscript to Microsoft Visio
How Can I Insert People in Microsoft Visio DiagramsHow To Create UML Diagrams in Microsoft Visio
How to Know the Version of Microsoft PublisherHow to Use Layers in Microsoft Visio
How To Create a Gantt Chart in Microsoft VisioHow to Add a Background in Microsoft Publisher
How to Use Microsoft SharePoint in BusinessHow Can Multiple People Edit a Document in Microsoft Visio
How to Add Arrow in Microsoft VisioHow to Make a Copy Group Form in Microsoft Forms for Reusing
How to Open a Microsoft Publisher Document Without PublisherHow to Download Multiple Files from Microsoft SharePoint Online
How to Create a Website Page Using Microsoft PublisherHow to Turn On Content Approval in SharePoint
How to Convert SharePoint Online Site to Microsoft TeamsHow to Stop Microsoft Teams from Automatically Opening
How to Print a Booklet in Microsoft PublisherHow to Create Flows in Microsoft Teams
How to Run Microsoft Publisher on ChromebookHow to Use Microsoft Teams with Other Platforms
How to Build a Microsoft SharePoint Site Multi-Lingual SiteHow to Add a Chat to Microsoft SharePoint
How to Edit Microsoft Publisher Files on MacHow to Import/Export Excel Into Microsoft SharePoint
How to Save Microsoft Forms as a TemplateHow to Change the Time Zone in Microsoft Teams
How to Use Multiple Sharing Options in Microsoft FormsHow to Change Status on Microsoft SharePoint
How To Make/Create a Mirror Image in Microsoft Publisher [Templates + Examples] 2023How to Create Sequence Diagram Using Microsoft Visio
How to Make a Supertype and Subtype in Microsoft VisioHow to Create Link to Download File in Microsoft SharePoint
How to Download Folder From Microsoft SharepointHow to Share a Microsoft SharePoint Site Externally
How To Make/Create a Booklet in Microsoft Publisher [Templates + Examples] 2023How to Flip Shape in Microsoft Visio
How to Make a Calendar in Microsoft PublisherHow to Trim Shapes and Lines in Microsoft Visio
How to Print a Brochure on Microsoft PublisherHow Do I Upgrade to 64-bit Microsoft Visio
How to Make a Brochure in Microsoft PublisherHow to Create a Poster in Microsoft Publisher
How to Build Organization Chart Microsoft VisioHow to Increase Print Resolution of Image in Microsoft Publisher
How to Record Microsoft Teams MeetingHow to Change Border Title in Microsoft Visio
How to Make Microsoft Teams Stay GreenHow to Mute/Unmute a Chat in Microsoft Teams
How to Create a Banner in Microsoft PublisherHow to Convert Microsoft Visio to PDF
How to Add Microsoft Visio to Office 365How to Register for a Microsoft Office Account to Use for Microsoft Teams
How to See Multiple People at the Same Time in a Meeting on Microsoft TeamsHow to Join a Microsoft Teams Meeting
How to Access Microsoft VisioHow to Create a Logo in Microsoft Publisher
How to Create Class Diagram in Microsoft VisioHow to Delete/Remove a Page in Microsoft SharePoint
How to Change Logo on Microsoft SharePointHow to Use Microsoft Sharepoint
How to Print Microsoft Visio DocumentHow to Embed a Modern Calendar to Microsoft SharePoint
How To Create a Book in Microsoft PublisherHow to Convert Microsoft Visio Object to JPEG
How to Copy and Paste Objects in Microsoft PublisherHow to Delete A File in Microsoft SharePoint
How to Fully Close Microsoft TeamsHow to Send a Form on a Group Chat in Microsoft Teams
How to Create a Flowchart in Microsoft VisioHow to Blur Background on Microsoft Teams
How to Change Background on Microsoft TeamsMicrosoft Teams
How to Create a Simple Microsoft SharePoint BlogHow to Convert Microsoft Publisher File to PDF
How to Open a Microsoft Publisher FileHow to Print in Microsoft Publisher
How to Create a Folder in Microsoft SharepointHow to Switch Microsoft Word from Dark Mode
How to Set Margins in Microsoft WordHow to Insert Horizontal Lines in Microsoft Word
How to Landscape on Microsoft WordHow To Make/Create a Document in Microsoft Publisher [Templates + Examples] 2023
How to Create A Team in Microsoft TeamsHow to Block Someone on Microsoft Teams
How to View the Microsoft Teams Meeting Link in OutlookHow do I Merge Microsoft Publisher Files
How to Change Name/Status on Microsoft TeamsHow to Add Multiple Users in a Chat Group in Microsoft Teams
How to Make/Create a Border in Microsoft Publisher [Templates + Examples] 2023How to Add Someone External to Microsoft Teams
How to Sign in/Sign Out of Microsoft TeamsHow to Create a Newsletter in Microsoft Publisher
bottom banner