Database Processing, 15e (Kroenke)
Appendix D: Getting Started with Microsoft Visio 2016
1) Microsoft Visio 2016 is a component of Microsoft Office 2016.
2) Microsoft Visio 2016 can be used to create data models.
3) In Microsoft Visio 2016, clicking the File command tab opens the Backstage view.
4) In Microsoft Visio 2016, both data models and database designs are created using the
Database Model Diagram template.
5) In Microsoft Visio 2016, a group of template objects is called a stencil.
6) In Microsoft Visio 2016, when the Entity object is placed in a diagram, it is labeled as a table.
7) In Microsoft Visio 2016, the Crow’s Foot Database Notation stencil objects include a
Recursive Relationship object.
8) In Microsoft Visio 2016, the Crow’s Foot Database Notation stencil objects include a
Category object.
9) In Microsoft Visio 2016, we can create data models using Entity and Relationship objects.
10) In Microsoft Visio 2016, we can create database designs using Entity and Dynamic
connector objects.
11) In Microsoft Visio 2016, Dynamic connector objects can be formatted with the line end
symbols needed to create IE Crow’s Foot notation.
12) In Microsoft Visio 2016, Relationship connector objects can be formatted with the line end
symbols needed to create IE Crow’s Foot notation.
13) In Microsoft Visio 2016, the arrow end of the Relationship connector object points to the
table containing the foreign key.
14) In Microsoft Visio 2016, the arrow end of the Dynamic connector object points to the table
containing the primary key.
15) In Microsoft Visio 2016, the cardinalities of the relationship are set using the Set Begin
Symbol command.
16) 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
17) 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
18) 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
19) 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
20) In Microsoft Visio 2016, the Crow’s Foot Database Notation stencil objects include(s)
________.
A) an Entity object
B) a Relationship object
C) a Dynamic connector object
D) Both A and B are correct
21) 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) Data models cannot be created in Microsoft Visio 2016.
22) 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) We cannot create database designs in Microsoft Visio 2016.
23) In Microsoft Visio 2016, supertype/subtype relationships in data models are created using
________.
A) Entity and Dynamic connector objects
B) Table and Relationship connector objects
C) Category and Relationship connector objects
D) There are no separate objects to create supertype/subtype, so we use standard objects.
24) In Microsoft Visio 2016, 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 Relationship connector objects
D) Database designs cannot be created in Microsoft Visio 2016.
25) In Microsoft Visio 2016, which object can be formatted with the line end symbols needed to
create IE Crow’s Foot notation?
A) Relationship connector object
B) Category object
C) Parent to category connector object
D) Category to child connector object
26) 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) Both A and B are correct
27) 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
28) 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
29) When using Microsoft Visio 2016, how do we create a blank diagram for use with a data
model?
30) In Microsoft Visio 2016, how do we create data models?
31) 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?
32) In Microsoft Visio 2016, how do we create database designs?
33) In Microsoft Visio 2016, describe the possible cardinality settings for a Relationship object
that can be set in the symbols menu in a database design, and how these settings correspond to
the IE Crow’s Foot symbols shown in Figure D-20.