Question 1

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

Accepted Answer

In Microsoft Visio 2013,data models are primarily created using the Entity and Relationship connector objects.The Relationship objects are simple attached line segments,and they do not have any relationship property data such as identifier,primary key or foreign key properties stored with them.They can,however,be formatted so that the line style and line ends match those used in IE Crow's Foot E-R notation.

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

In Microsoft Visio 2013,the cardinalities of the Relationship connector object end points are formatted using ________.

Accepted Answer

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 
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 D

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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 
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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Microsoft Visio 2013 can be used to create data models.

Accepted Answer

A) True 
 B)False

Question 8

In Microsoft Visio 2013,both data models and database designs are created using the Database Model Diagram template.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 ________.

Accepted Answer

A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more 
A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

Microsoft Visio 2013 is a component of Microsoft Office 2013.

Accepted Answer

A) True 
 B)False

Question 14

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?

Accepted Answer

Data models are created using primarily

Question 15

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

In Microsoft Visio 2013,we can create database designs using ________.

Accepted Answer

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 2013. 
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 2013.

Question 17

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 ________.

Accepted Answer

A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more 
A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more

Question 18

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 ________.

Accepted Answer

A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more 
A) 1 and only 1 
B) 1 or more 
C) Zero or 1 
D) Zero or more

Question 19

In Microsoft Visio 2013,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 
A) entity 
B) table 
C) relationship 
D) dynamic connector

Question 20

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

Accepted Answer

A) an Entity object 
B) a Relationship object 
C) a Dynamic connector object 
D) Both A and B are correct 
A) an Entity object 
B) a Relationship object 
C) a Dynamic connector object 
D) Both A and B are correct

Exam 20: Getting Started With Microsoft Visio 2013

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

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

In Microsoft Visio 2013,the cardinalities of the Relationship connector object end points are formatted using ________.

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

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

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

Microsoft Visio 2013 can be used to create data models.

In Microsoft Visio 2013,both data models and database designs are created using the Database Model Diagram template.

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

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 ________.

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

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

Microsoft Visio 2013 is a component of Microsoft Office 2013.

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?

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

In Microsoft Visio 2013,we can create database designs using ________.

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 ________.

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 ________.

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

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

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

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

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters