Question 1

In Microsoft Visio 2016,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in the Symbol menu is ________.
A) 1 and only 1
B) 1 or more
C) Zero or 1
D) Zero or more
E) Range [At least][At most]

Accepted Answer

The "1 and only 1" setting correctly represents a one-mandatory relationship on the child side, indicating that each child must be associated with exactly one parent entity in the relationship.

Question 2

In Microsoft Visio 2016,how do we create data models?

Accepted Answer

The answer of In Microsoft Visio 2016,how do we create...

Question 3

In Microsoft Visio 2016,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in the Symbol menu is ________.
A) 1 and only 1
B) 1 or more
C) Zero or 1
D) Zero or more
E) Range [At least][At most]

Accepted Answer

For a many-mandatory relationship on the child side, the correct setting is "1 or more," indicating that at least one instance of the child entity is required in the relationship.

Question 4

In Microsoft Visio 2016,for a Relationship object relationship that is one-optional on the child side of the relationship,the correct setting in the Symbol menu is ________.
A) 1 and only 1
B) 1 or more
C) Zero or 1
D) Zero or more
E) Range [At least][At most]

Accepted Answer

For a one-optional relationship on the child side, the correct setting in the Symbol menu is "Zero or 1". This means that the child entity can have either a single parent entity or no parent entity at all. The other options (1 and only 1, 1 or more, zero or more, and range [at least][at most]) do not accurately represent a one-optional relationship on the child side.

Question 5

In Microsoft Visio 2016,we can create data models using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) Category and Relationship connector objects
E) We cannot create data models in Microsoft Visio 2016.

Accepted Answer

In Microsoft Visio 2016, one can create data models using Entity and Relationship connector objects. These objects allow us to visually represent tables/entities and their relationships in a database schema.

Question 6

Using Microsoft Visio 2016 standard template objects,we can create supertype/subtype relationships in data models using ________.
A) Entity and Dynamic connector objects
B) Table and Relationship connector objects
C) Category and Dynamic connector objects
D) Category and Relationship connector objects
E) There are no separate objects to create supertype/subtype, so we use standard objects.

Accepted Answer

The answer of Using Microsoft Visio 2016 standard template objects,we...

Question 7

In Microsoft Visio 2016,how do we create database designs?

Accepted Answer

The answer of In Microsoft Visio 2016,how do we create...

Question 8

In Microsoft Visio 2016,the cardinalities of the Relationship connector object end points are formatted using ________.
A) the Set Begin Symbol command
B) the Set End Symbol command
C) the Set Non-primary Key Unique column
D) the Set Non-foreign Key Unique column
E) Both A and B

Accepted Answer

The cardinalities of the Relationship connector object end points are formatted using both the Set Begin Symbol command and the Set End Symbol command in Microsoft Visio 2016. These commands allow users to customize the symbols used to represent cardinality, such as the crow's foot notation commonly used in Entity-Relationship diagrams. Therefore, both option A and B are required to properly format the cardinalities of the Relationship connector object endpoints. Options C and D are unrelated to formatting cardinalities in Visio.

Question 9

In Microsoft Visio 2016 standard template objects,we can create supertype/subtype relationships in database designs using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) Category and Relationship connector objects
E) We cannot create database designs in Microsoft Visio 2016.

Accepted Answer

The answer of In Microsoft Visio 2016 standard template objects,we...

Question 10

In Microsoft Visio 2016,how do we format line ends in data models to represent the symbols used in the IE Crow's Foot notation?

Accepted Answer

The answer of In Microsoft Visio 2016,how do we format...

Question 11

In Microsoft Visio 2016,we can create database designs using ________.
A) Entity and Dynamic connector objects
B) Entity and Relationship connector objects
C) Category and Dynamic connector objects
D) Category and Relationship connector objects
E) We cannot create database designs in Microsoft Visio 2016.

Accepted Answer

The answer of In Microsoft Visio 2016,we can create database...

Question 12

When using Microsoft Visio 2016,how do we create a blank diagram for use with a data model?

Accepted Answer

The answer of When using Microsoft Visio 2016,how do we...

Question 13

In Microsoft Visio 2016,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?
A) Dynamic connector object
B) Relationship connector object
C) Category object
D) Parent to category connector object
E) Category to child connector object

Accepted Answer

The Relationship connector object can be formatted with the line end symbols needed to create IE Crow's Foot notation.

Quiz 14: Learn how to create E-R data models in Microsoft Visio 2016

In Microsoft Visio 2016,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in the Symbol menu is ________.

In Microsoft Visio 2016,how do we create data models?

In Microsoft Visio 2016,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in the Symbol menu is ________.

In Microsoft Visio 2016,for a Relationship object relationship that is one-optional on the child side of the relationship,the correct setting in the Symbol menu is ________.

In Microsoft Visio 2016,we can create data models using ________.

Using Microsoft Visio 2016 standard template objects,we can create supertype/subtype relationships in data models using ________.

In Microsoft Visio 2016,how do we create database designs?

In Microsoft Visio 2016,the cardinalities of the Relationship connector object end points are formatted using ________.

In Microsoft Visio 2016 standard template objects,we can create supertype/subtype relationships in database designs using ________.

In Microsoft Visio 2016,how do we format line ends in data models to represent the symbols used in the IE Crow's Foot notation?

In Microsoft Visio 2016,we can create database designs using ________.

When using Microsoft Visio 2016,how do we create a blank diagram for use with a data model?

In Microsoft Visio 2016,which object can be formatted with the line end symbols needed to create IE Crow's Foot notation?