Question 1

Maximum cardinalities are represented in UML-style E-R diagrams with the same notation (1:1,1:N,N:M)as in traditional E-R diagrams.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following would indicate a minimum cardinality of 1 and a maximum cardinality of many in UML notation?

Accepted Answer

A) 1:N 
B) 1 ..N 
C) 1 ..* 
D) 1:* 
A) 1:N 
B) 1 ..N 
C) 1 ..* 
D) 1:*

Question 3

In the UML-style entity class ORDERS shown above,"GetOrderNo( )" is a ________.

Accepted Answer

A) private method 
B) protected method 
C) public constraint 
D) public method 
A) private method 
B) protected method 
C) public constraint 
D) public method

Question 4

What format is used for weak entities in UML-style E-R diagrams?

Accepted Answer

UML-style E-R diagrams indicate a weak e

Question 5

In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.

Accepted Answer

A) True 
 B)False

Question 6

What new contributions to data modeling do UML-style E-R diagrams introduce?

Accepted Answer

UML-style diagrams are a relatively new

Question 7

In UML,an attribute that is accessible and can be changed by any method of any object is said to be ________.

Accepted Answer

A) private 
B) exclusive 
C) protected 
D) public 
A) private 
B) exclusive 
C) protected 
D) public

Question 8

Three levels of visibility for attributes in UML diagrams are: Private,Protected,and Public.

Accepted Answer

A) True 
 B)False

Question 9

In UML-style E-R diagrams,the third segment of an entity class contains ________.

Accepted Answer

A) the name of the entity 
B) the cardinalities of the entity 
C) constraints and methods 
D) entity attributes 
A) the name of the entity 
B) the cardinalities of the entity 
C) constraints and methods 
D) entity attributes

Question 10

In UML-style E-R diagrams,the second segment of an entity class contains ________.

Accepted Answer

A) the name of the entity 
B) the cardinalities of the entity 
C) relationships 
D) entity attributes 
A) the name of the entity 
B) the cardinalities of the entity 
C) relationships 
D) entity attributes

Question 11

UML is intended for modeling and designing object-oriented programs and applications.

Accepted Answer

A) True 
 B)False

Question 12

In UML notation,the relationship line in a relationship with an non-ID-dependent weak entity is labeled as ________.

Accepted Answer

A) B) C) D) There is no label used. A) B) C) D) There is no label used.

Question 13

In UML-style E-R diagrams,which of the following would be considered a class attribute of the entity class CUSTOMER?

Accepted Answer

A) Customer Name (meaning,the first and last name of the customer) 
B) Customer Address (meaning,the street,city,state,and zip code of the customer's residence) 
C) Customer Count (meaning,the count of the number of customers) 
D) Customer Number (meaning,an assigned number to uniquely identify a customer) 
A) Customer Name (meaning,the first and last name of the customer) 
B) Customer Address (meaning,the street,city,state,and zip code of the customer's residence) 
C) Customer Count (meaning,the count of the number of customers) 
D) Customer Number (meaning,an assigned number to uniquely identify a customer)

Question 14

One weakness of UML-style E-R diagrams is that there is no means of distinguishing between a weak entity that is ID-dependent and a weak entity that is not ID-dependent.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not a true statement about the current version of UML?

Accepted Answer

A) UML places a filled-in diamond on the parent of a weak entity. B) UML provides a means to document exclusivity among subtypes. C) UML uses the label to document an ID-dependent relationship. D) UML shows the cardinality on the parent entity of a weak entity as simply "1." A) UML places a filled-in diamond on the parent of a weak entity. B) UML provides a means to document exclusivity among subtypes. C) UML uses the label to document an ID-dependent relationship. D) UML shows the cardinality on the parent entity of a weak entity as simply "1."

Question 16

Attributes preceded by a + are protected.

Accepted Answer

A) True 
 B)False

Exam 18: E-R Diagrams and the UML Standard

Maximum cardinalities are represented in UML-style E-R diagrams with the same notation (1:1,1:N,N:M)as in traditional E-R diagrams.

Which of the following would indicate a minimum cardinality of 1 and a maximum cardinality of many in UML notation?

In the UML-style entity class ORDERS shown above,"GetOrderNo( )" is a ________.

What format is used for weak entities in UML-style E-R diagrams?

In UML-style E-R diagrams,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.

What new contributions to data modeling do UML-style E-R diagrams introduce?

In UML,an attribute that is accessible and can be changed by any method of any object is said to be ________.

Three levels of visibility for attributes in UML diagrams are: Private,Protected,and Public.

In UML-style E-R diagrams,the third segment of an entity class contains ________.

In UML-style E-R diagrams,the second segment of an entity class contains ________.

UML is intended for modeling and designing object-oriented programs and applications.

In UML notation,the relationship line in a relationship with an non-ID-dependent weak entity is labeled as ________.

In UML-style E-R diagrams,which of the following would be considered a class attribute of the entity class CUSTOMER?

One weakness of UML-style E-R diagrams is that there is no means of distinguishing between a weak entity that is ID-dependent and a weak entity that is not ID-dependent.

Which of the following is not a true statement about the current version of UML?

Attributes preceded by a + are protected.

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

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

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