Question 1

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) . E) There is no label used. A) . B) . C) . D) . E) There is no label used. C

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

In UML,an attribute preceded by a(n)________ is "protected."

Accepted Answer

A) ! B) # C) - D) + E) A) ! B) # C) - D) + E) B

Question 4

Which of the following is 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 does not provide 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." E) All of the above. A) UML places a filled-in diamond on the parent of a weak entity. B) UML does not provide 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." E) All of the above.

Question 5

Which of the following is true about UML?

Accepted Answer

A) UML is a methodology for developing OOP systems. 
B) UML is a set of tools to support the development OOP systems. 
C) UML is primarily focused on database development. 
D) A and B 
E) A,B,and C 
A) UML is a methodology for developing OOP systems. 
B) UML is a set of tools to support the development OOP systems. 
C) UML is primarily focused on database development. 
D) A and B 
E) A,B,and C

Question 6

In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.

Accepted Answer

A) an entity attribute 
B) a method 
C) a constraint 
D) a class attribute 
E) None of the above 
A) an entity attribute 
B) a method 
C) a constraint 
D) a class attribute 
E) None of the above

Question 7

In UML,an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________.

Accepted Answer

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

Question 8

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) 
E) A and B 
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) 
E) A and B

Question 9

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 10

What is OOP persistence,and how is it indicated in UML-style E-R diagrams?

Accepted Answer

Persistence in OOP means that

Question 11

In UML,an attribute that is accessible only by methods of its entity class is said to be ________.

Accepted Answer

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

Question 12

In UML,cardinalities are represented by an x ..y format.

Accepted Answer

A) True 
 B)False

Question 13

UML-style E-R diagrams allow for three different levels of visibility of attributes.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Attributes preceded by a + are protected.

Accepted Answer

A) True 
 B)False

Question 16

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) relationships 
E) entity attributes 
A) the name of the entity 
B) the cardinalities of the entity 
C) constraints and methods 
D) relationships 
E) entity attributes

Question 17

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

Accepted Answer

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

Question 18

UML-style E-R diagrams introduce object-oriented notation that is of limited practical value in traditional,relational database design.

Accepted Answer

A) True 
 B)False

Question 19

Attributes preceded by a + are public.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 16: E-R Diagrams and the UML Standard

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

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

In UML,an attribute preceded by a(n)________ is "protected."

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

Which of the following is true about UML?

In the UML-style entity class ORDERS shown above,"SumOfOrders" is ________.

In UML,an attribute that is accessible only by methods of its entity class or of its subclasses is said to be ________.

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

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.

What is OOP persistence,and how is it indicated in UML-style E-R diagrams?

In UML,an attribute that is accessible only by methods of its entity class is said to be ________.

In UML,cardinalities are represented by an x ..y format.

UML-style E-R diagrams allow for three different levels of visibility of attributes.

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

Attributes preceded by a + are protected.

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

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

UML-style E-R diagrams introduce object-oriented notation that is of limited practical value in traditional,relational database design.

Attributes preceded by a + are public.

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

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

Business Intelligence Systems

Filters