Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

In Microsoft Visio 2010,data models are primarily created using the Entity and Relationship connector objects.The Relationship connector objects are attached line segments,and they have relationship property data such as identifier,primary key or foreign key properties stored with them.They cannot,however,be formatted so that the line style and line ends match those used in IE Crow's Foot E-R notation.Cardinality and relationship type (identifying and non-identifying relationships)date are stored using the Database Properties window for the relationship.

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

In Microsoft Visio 2010,when the Entity object is placed in a diagram,it is labeled as a(n):

Accepted Answer

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

Question 5

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Recursive Relationship object.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

In Microsoft Visio 2010,data models are

Question 7

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

Accepted Answer

A) Dynamic connector object 
B) Relationship connector object 
C) Category object 
D) Parent to category connector object 
E) Category to child connector object 
A) Dynamic connector object 
B) Relationship connector object 
C) Category object 
D) Parent to category connector object 
E) Category to child connector object

Question 8

In Microsoft Visio 2010,both data models and database designs are created using:

Accepted Answer

A) the Database Model Diagram template. 
B) the UML Model Diagram template. 
C) the Enterprise Application template. 
D) the Data Flow Model template. 
E) the Wireframe Diagram template. 
A) the Database Model Diagram template. 
B) the UML Model Diagram template. 
C) the Enterprise Application template. 
D) the Data Flow Model template. 
E) the Wireframe Diagram template.

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

In Microsoft Visio 2010,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in Database Properties is:

Accepted Answer

A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most]. 
A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most].

Question 11

In Microsoft Visio 2010,we can create supertype/subtype relationships in database designs using:

Accepted Answer

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) A and C 
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) A and C

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include:

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In Microsoft Visio 2010,whether a relationship is identifying or non-identifying can be set in the Database Properties for that Relationship object.

Accepted Answer

A) True 
 B)False

Question 16

In Microsoft Visio 2010,describe the possible cardinality settings for a Relationship object that can be set in the Database Properties for a relationship in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure 4-8?

Accepted Answer

There are five possible settings,and fou

Question 17

In Microsoft Visio 2010,for a Relationship object relationship that is many-optional on the child side of the relationship,the correct setting in Database Properties is:

Accepted Answer

A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most]. 
A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most].

Question 18

In Microsoft Visio 2010,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in Database Properties is:

Accepted Answer

A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most]. 
A) exactly one. 
B) one or more. 
C) zero or one. 
D) zero or more. 
E) range [At least][At most].

Question 19

Microsoft Visio 2010 can be used to create:

Accepted Answer

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

Question 20

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Category object.

Accepted Answer

A) True 
 B)False

Exam 21: Getting Started With Microsoft Visio 2010

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

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

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

In Microsoft Visio 2010,when the Entity object is placed in a diagram,it is labeled as a(n):

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Recursive Relationship object.

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

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

In Microsoft Visio 2010,both data models and database designs are created using:

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

In Microsoft Visio 2010,for a Relationship object relationship that is one-mandatory on the child side of the relationship,the correct setting in Database Properties is:

In Microsoft Visio 2010,we can create supertype/subtype relationships in database designs using:

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

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include:

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

In Microsoft Visio 2010,whether a relationship is identifying or non-identifying can be set in the Database Properties for that Relationship object.

In Microsoft Visio 2010,describe the possible cardinality settings for a Relationship object that can be set in the Database Properties for a relationship in a database design,and how these settings correspond to the IE Crow's Foot symbols shown in Figure 4-8?

In Microsoft Visio 2010,for a Relationship object relationship that is many-optional on the child side of the relationship,the correct setting in Database Properties is:

In Microsoft Visio 2010,for a Relationship object relationship that is many-mandatory on the child side of the relationship,the correct setting in Database Properties is:

Microsoft Visio 2010 can be used to create:

In Microsoft Visio 2010,the Entity Relationship (US units)stencil objects include a Category object.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters