Deck 14: Getting Started in Systems Analysis and Design

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

Microsoft Visio 2013 is a component of Microsoft Office 2013.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

In Microsoft Visio 2013,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 13

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

Question 14

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

Question 15

Microsoft Visio 2013 can be used to create:

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

Question 16

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

Question 17

In Microsoft Visio 2013,the Crow's Foot Database Notation stencil objects include:

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

Question 18

In Microsoft Visio 2013,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.

Question 19

In Microsoft Visio 2013,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 20

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

Question 21

In Microsoft Visio 2013,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) A and B.

Question 22

In Microsoft Visio 2013,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 2013.

Question 23

In Microsoft Visio 2013,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 2013.

Question 24

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

Question 25

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

Question 26

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

Question 27

In Microsoft Visio 2013,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 2013.

Question 28

In Microsoft Visio 2013,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.

Question 29

In Microsoft Visio 2013,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

Question 30

In Microsoft Visio 2013,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 31

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

Question 32

In Microsoft Visio 2013,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 33

In Microsoft Visio 2013,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 34

In Microsoft Visio 2013,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.