Right-click the first attribute in the child entity, and select Insert ‘Attribute’ Before.Ĭlick 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. In the parent entity, click the attribute that is denoted with PK, and type the attribute name. In Visio, on the File menu, click New > Software, and then click IDEF1X Database Notation.Ĭhoose between Metric Units or US Units, and click Create.įrom the IDEF1X Database Notation stencil, drag an Entity shape onto the drawing page to create a parent entity.ĭrag another Entity shape onto the drawing page to create a child entity. Define a category in a database model diagram 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. For example, an employee record (the parent) might contain a job-type column category tables for that column might include engineer, technician, and administrator. Categories are child tables of a parent table.