Common use of Table Designer Clause in Contracts

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create Logical Models‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations to Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create Logical Models‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose select File -> New Model from the main menumenu bar. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations to Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in the canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose select File -> New Model from the main menumenu bar. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in the canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in the canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connectorconnecter. Delete Vertex Delete a vertex on a foreign key connectorconnecter. Delete All Vertices Delete all vertices on a foreign key connectorconnecter. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create a Logical Models‌ Model‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose select File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data sourceschemas.  Model Conversion - convert from a physical/conceptual model. Add Entities an Entity to a Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations a Relation to a Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name Name option in the Properties pane. When you move your mouse over a relation connectorconnecter, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connectorconnecter. Delete Vertex Delete a vertex on a relation connectorconnecter. Delete All Vertices Delete all vertices on a relation connectorconnecter. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create a Conceptual Models‌ Model‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose select File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data sourceschemas.  Model Conversion - convert from a physical/logical model. Add Entities an Entity to a Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connectorconnecter. Delete Vertex Delete a vertex on a foreign key connectorconnecter. Delete All Vertices Delete all vertices on a foreign key connectorconnecter. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create a Logical Models‌ Model‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose select File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities an Entity to a Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations a Relation to a Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name Name option in the Properties pane. When you move your mouse over a relation connectorconnecter, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connectorconnecter. Delete Vertex Delete a vertex on a relation connectorconnecter. Delete All Vertices Delete all vertices on a relation connectorconnecter. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create a Conceptual Models‌ Model‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose select File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities an Entity to a Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – 6 - Logical Models‌ Create Model About Logical Models‌ Models Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  • Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  • Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ Model To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you rightcontrol-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. COMMAND-F. Add Relations a Relation to a Logical Model‌ Model To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in the canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, entity_name1 One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete Xxxxxx Xxxxxx a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create Logical Models‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menumenu bar. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you rightcontrol-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities objects to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. COMMAND-F. Add Relations a Relation to a Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in the canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menumenu bar. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in the canvas include: Option Description Add Related Objects Add all related entities objects to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in the canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View Diagram -> Show Grid Lines from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – 6 - Logical Models‌ Create Model‌ About Logical Models‌ Model‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations to Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 7 - Conceptual Models‌ Create Model‌ About Conceptual Models‌ Model‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 8 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menumenu bar.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – Logical Models‌ Create Logical Models‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  • Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  • Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations to Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 - Conceptual Models‌ Create Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  • Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  • Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menu.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – 6 - Logical Models‌ Create Model‌ About Logical Models‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you rightcontrol-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities objects to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. COMMAND-F. Add Relations a Relation to a Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in the canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, entity_name1 One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 7 - Conceptual Models‌ Create Model‌ About Conceptual Models‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in the canvas include: Option Description Add Related Objects Add all related entities objects to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in the canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – 8 - Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View Diagram -> Show Grid Lines from the menumenu bar. Snap to Grid To align objects on the canvas with the grid, choose Diagram -> Snap to Grid from the menu bar.

Table Designer. Cardinality on table_name1 Set the cardinality on table_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on table_name2 Set the cardinality on table_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a foreign key connector. Delete Vertex Delete a vertex on a foreign key connector. Delete All Vertices Delete all vertices on a foreign key connector. Go to Source Go to and select the source (child) table. Go to Target Go to and select the target (parent) table. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Chapter 5 – 6 - Logical Models‌ Create Model‌ About Logical Models‌ Model‌ Navicat Data Modeler allows you to create logical models, including entities, attributes and relations. To create a logical model, choose File -> New Model from the main menu. In the New Model window, choose Logical as Model Type. You can also use the following features to create a logical model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/conceptual model. Add Entities to Logical Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. For Default diagram notation, the icon means the attribute is a primary key. The icon indicates that the attribute serves as an index. Note: If you right-click an attribute, you can choose to add, insert, delete, rename the attribute and set the attribute as primary key. The pop-up menu options of the entity object in the canvas include: Option Description Design Entity Edit the entity structure in an Entity Designer, e.g. attributes and relations. Add Related Objects Add all related entities to the selected entity. Add Attribute Add attributes to the existing entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Entity Designer Entity Designer is the basic Navicat Data Modeler tool for working with entities. It allows you to create, edit and drop entity's attributes, relations, etc. In the Attributes tab, you can search an attribute name by pressing CTRL+F. Add Relations to Logical Model‌ To add a relation, click the Relation button from the toolbar and drag and drop an attribute from the child entity to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. Also, the referenced attributes and the referencing attributes are highlighted. The pop-up menu options of the relation in the canvas include: Option Description Design Relation Edit the relation in an Entity Designer. Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 6 7 - Conceptual Models‌ Create Model‌ About Conceptual Models‌ Model‌ Navicat Data Modeler allows you to create conceptual models, including entities and relations. To create a conceptual model, choose File -> New Model from the main menu. In the New Model window, choose Conceptual as Model Type. You can also use the following features to create a conceptual model:  Import from Database - reverse engineer from existing databases/schemas or ODBC data source.  Model Conversion - convert from a physical/logical model. Add Entities to Conceptual Model‌ To add a new entity, click the Entity button from the toolbar and click anywhere on the canvas. To add an existing entity from the Explorer's Model tab, simply drag and drop the selected entity from the Model tab to the canvas. The pop-up menu options of the entity object in the canvas include: Option Description Add Related Objects Add all related entities to the selected entity. Cut Remove the entity from the diagram and put it on the clipboard. Copy Copy the entity from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Entities Select all entities in the diagram. Delete from Diagram / Delete from Diagram and Model Delete an entity from the diagram or from both diagram and model. Rename Change the name of the entity. Color Change the color of the entity. Size to Fit Resize the entity automatically to fit its contents. Bring to Front Bring the entity to the foreground. Send to Back Move the entity to the background. Add Relations to Conceptual Model‌ To add a relation, click the Relation button from the toolbar and drag the child entity and drop to the parent entity. To show/hide the linked name label, simply check/uncheck the Show name option in the Properties pane. When you move your mouse over a relation connector, the border of the parent and the child entities turn to green and blue respectively. The pop-up menu options of the relation in the canvas include: Option Description Cardinality on entity_name1 Set the cardinality on entity_name1: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Cardinality on entity_name2 Set the cardinality on entity_name2: None, One and Only One, Many, One or Many, Zero or One, Zero or Many. Add Vertex Add a vertex on a relation connector. Delete Vertex Delete a vertex on a relation connector. Delete All Vertices Delete all vertices on a relation connector. Go to Source Go to and select the source (child) entity. Go to Target Go to and select the target (parent) entity. Paste Paste the content from the clipboard into the diagram. Select All Relations Select all relations in the diagram. Delete from Diagram and Model Delete a relation from both diagram and model. Color Change the color of the relation. Chapter 7 – 8 - Diagram Layout‌ Work with Diagram Canvas‌ Show Grid To turn the grid on in the diagram canvas, choose View -> Show Grid from the menumenu bar.