Database Concepts, 8e (Kroenke)
Appendix G 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, but not database designs.
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 Crow’s
Foot Database Notation 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 explicitly
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 and Set End Symbol commands.
16) 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
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
E) the Save 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
E) the Wireframe Database Diagram 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
E) category
20) 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
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) Category and Relationship connector objects
E) We cannot create data models 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) Category and Relationship connector objects
E) We cannot create database designs in Microsoft Visio 2016.
23) 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.
24) 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.
25) 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
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) the Set Non-foreign Key Unique column
E) Both A and B
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
E) Range [At least][At most]
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
E) Range [At least][At most]
29) 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]
30) When using Microsoft Visio 2016, how do we create a blank diagram for use with a data
model?
31) In Microsoft Visio 2016, how do we create data models?
32) 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?
33) In Microsoft Visio 2016, how do we create database designs?
34) 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 G-21.