Question 1

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 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 ..* 
E) 1:* 
A) 1:N 
B) 1 ..N 
C) 1 / * 
D) 1 ..* 
E) 1:*

Question 3

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) 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 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 simple "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 simple "1." E) All of the above.

Question 5

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 6

-In UML notation,the relationship line in a relationship between two strong entities 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.

Question 7

Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

UML-style diagrams are a relatively new

Question 9

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 10

Attributes preceded by a + are public.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Which of the following is not a characteristic that was introduced to E-R diagramming by UML?

Accepted Answer

A) class attributes 
B) relationship attributes 
C) visibility of attributes 
D) methods 
E) constraints 
A) class attributes 
B) relationship attributes 
C) visibility of attributes 
D) methods 
E) constraints

Question 13

Attributes preceded by a # are private.

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:

Accepted Answer

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

Question 15

How are entity classes drawn in UML-Style E-R diagrams?

Accepted Answer

UML-style E-R diagrams draw an entity as

Question 16

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

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

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

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

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

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

-In UML notation,the relationship line in a relationship between two strong entities is labeled as:

Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.

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

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

Attributes preceded by a + are public.

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

Which of the following is not a characteristic that was introduced to E-R diagramming by UML?

Attributes preceded by a # are private.

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

How are entity classes drawn in UML-Style E-R diagrams?

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.

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

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters

Exam 19: E-R Diagrams and the UML Standard

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

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

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

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

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

-In UML notation,the relationship line in a relationship between two strong entities is labeled as:

Persistent means that data should continue to exist in the database even if the object that processes it is destroyed.

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

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

Attributes preceded by a + are public.

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

Which of the following is not a characteristic that was introduced to E-R diagramming by UML?

Attributes preceded by a # are private.

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

How are entity classes drawn in UML-Style E-R diagrams?

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.

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

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters