Deck 18: E-R Diagrams and the UML Standard

Question 1

UML-style E-R diagrams allow for the existence of class attributes which are attributes that pertain to the collection of all entities within that class,not to the individual entity instances themselves.

Answer 1

True

Question 2

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.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

The classes of all entities to be stored in the database are labeled <>.

Question 5

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

Question 6

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

Question 7

Which of the following is true about UML?

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)Both A and B are correct.

Question 8

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

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

Question 9

Attributes preceded by a + are public.

Question 10

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

Question 11

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

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

Question 12

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

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

Question 13

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

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 14

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.

Question 15

Attributes preceded by a + are protected.

Question 16

Attributes preceded by a # are private.

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

A)
B)
C)
D)

Question 22

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

Question 23

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

Question 24

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

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

Question 25

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

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

Question 26

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

Question 27

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

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

Question 28

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

A)an entity attribute
B)a method
C)a constraint
D)a class attribute

Question 29

In UML-style E-R diagrams,which of the following would be considered a class attribute of the entity class 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 30

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

A)
B)#
C)-
D)+

Question 31

What cardinality format is used in UML-style E-R diagrams?

Question 32

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

A)Class attributes
B)Relationship attributes
C)Visibility of attributes
D)Methods

Question 33

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

Question 34

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

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

Question 35

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

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

Question 36

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

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