Deck 19: E-R Diagrams and the UML Standard

Question 1

Which of the following is 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 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.

Answer 1

E

Question 2

Attributes preceded by a + are public.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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)constraints and methods
D)relationships
E)entity attributes

Question 6

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

Question 7

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 ..*
E)1:*

Question 8

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)relationships
E)entity attributes

Question 9

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.

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,a weak entity is shown by placing a filled-in diamond on the parent of the weak entity.

Question 12

Attributes preceded by a # are private.

Question 13

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

Question 14

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

Question 15

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

Question 16

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 17

Attributes preceded by a + are protected.

Question 18

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

Question 19

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.

Question 20

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 of OOP systems.
C)UML is primarily focused on database development.
D)A and B
E)A,B and C

Question 21

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
E)persistent

Question 22

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

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

Question 23

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

Question 24

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

Question 25

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

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

Question 26

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

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

Question 27

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
E)persistent

Question 28

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

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

Question 30

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
E)persistent

Question 31

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

Question 32

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

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

Question 33

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

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

Question 34

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
E)None of the above.

Question 35

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

Question 36

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
E)constraints