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

Question 1

In Microsoft Visio 2016,when the Entity object is placed in a diagram,it is labeled explicitly as a table.

Answer 1

False

Question 2

In Microsoft Visio 2016,the data models in this book are created using ________.

A) the Chen's Database Notation template
B) the UML database Notation template
C) the IDEF1X Database Notation template
D) the Crow's Foot Database Notation template
E) the Wireframe Database Diagram template

Answer 2

D

Question 3

In Microsoft Visio 2016,the arrow end of the Relationship connector object points to the table containing the foreign key.

Answer 3

False

Question 4

In Microsoft Visio 2016,the Crow's Foot Database Notation stencil objects include ________.

A) an Entity object
B) a Relationship object
C) a Dynamic connector object
D) Both A and B
E) A, B, and C

Question 5

In Microsoft Visio 2016,the Crow's Foot Database Notation stencil objects include a Recursive Relationship object.

Question 6

Microsoft Visio 2016 can be used to create ________.

A) data models
B) data designs
C) database models
D) database designs
E) Both A and D

Question 7

In Microsoft Visio 2016,the arrow end of the Dynamic connector object points to the table containing the primary key.

Question 8

In Microsoft Visio 2016,clicking the File command tab opens the Backstage view.

Question 9

In Microsoft Visio 2016,we can create database designs using Entity and Dynamic connector objects.

Question 10

In Microsoft Visio 2016,when the Entity object is placed in a diagram,it is labeled as a(n)________.

A) entity
B) table
C) relationship
D) dynamic connector
E) category

Question 11

In Microsoft Visio 2016,the Crow's Foot Database Notation stencil objects include a Category object.

Question 12

In Microsoft Visio 2016,a group of template objects is called a stencil.

Question 13

In Microsoft Visio 2016,clicking the FILE command tab opens ________.

A) the File menu
B) the Backstage view
C) the Open dialog box
D) the Save As dialog box
E) the Save dialog box

Question 14

In Microsoft Visio 2016,the cardinalities of the relationship are set using the Set Begin Symbol and Set End Symbol commands.

Question 15

In Microsoft Visio 2016,Relationship connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.

Question 16

Microsoft Visio 2016 can be used to create data models,but not database designs.

Question 17

Microsoft Visio 2016 is a component of Microsoft Office 2016.

Question 18

In Microsoft Visio 2016,both data models and database designs are created using the Crow's Foot Database Notation template.

Question 19

In Microsoft Visio 2016,we can create data models using Entity and Relationship objects.

Question 20

In Microsoft Visio 2016,Dynamic connector objects can be formatted with the line end symbols needed to create IE Crow's Foot notation.

Question 21

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]

Question 22

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

Question 23

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]

Question 24

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]

Question 25

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.

Question 26

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.

Question 27

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

Question 28

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

Question 29

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.

Question 30

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?

Question 31

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.

Question 32

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

Question 33

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