Define categories in a Database Model diagram (2024)

Visio Plan 2 Visio Professional 2021 Visio Professional 2019 Visio Professional 2016 Visio Professional 2013 More...Less

Categories are child tables of a parent table. For example, an employee record (the parent) might contain a job-type column; category tables for that column might include engineer, technician, and administrator. Define the category by setting up the primary key in the parent table, and then setting up a foreign key in the child table, and linking the two.

Define a category in a database model diagram

  1. In Visio, on the File menu, click New > Software, and then click IDEF1X Database Notation.

  2. Choose between Metric Units or US Units, and click Create.

  3. From the IDEF1X Database Notation stencil, drag an Entity shape onto the drawing page to create a parent entity.

  4. Drag another Entity shape onto the drawing page to create a child entity.

  5. In the parent entity, click the attribute that is denoted with PK, and type the attribute name.

    Define categories in a Database Model diagram (1)

  6. Complete the parent entity.

  7. Right-click the first attribute in the child entity, and select Insert ‘Attribute’ Before.

    Define categories in a Database Model diagram (2)

  8. Click the newly created attribute in the child entity, and type the attribute name that you entered earlier as the primary key in the parent entity.

  9. Right-click the attribute, and click Set Foreign Key.

    Define categories in a Database Model diagram (3)

  10. Drag a Relationship shape onto the drawing page.

  11. Drag one end of the relationship shape to the middle of the parent entity until a green box appears around the entire shape.

  12. Connect the other end of the relationship shape to the child entity the same way.

  13. Repeat the steps for each child table.

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Define categories in a Database Model diagram (2024)
Top Articles
Latest Posts
Article information

Author: Frankie Dare

Last Updated:

Views: 6341

Rating: 4.2 / 5 (53 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Frankie Dare

Birthday: 2000-01-27

Address: Suite 313 45115 Caridad Freeway, Port Barabaraville, MS 66713

Phone: +3769542039359

Job: Sales Manager

Hobby: Baton twirling, Stand-up comedy, Leather crafting, Rugby, tabletop games, Jigsaw puzzles, Air sports

Introduction: My name is Frankie Dare, I am a funny, beautiful, proud, fair, pleasant, cheerful, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.