Deck 16: E-R Diagrams and the UML Standard

Question 1

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:*

Answer 1

D

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

Attributes preceded by a + are public.

Question 6

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

Question 7

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 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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 13

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

Question 14

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 15

Attributes preceded by a # are private.

Question 16

Attributes preceded by a + are protected.

Question 17

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

Question 18

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 19

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 20

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 21

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

Question 22

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

Question 23

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

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

Question 24

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 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 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 27

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

Question 28

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

Question 29

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

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

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

Question 32

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 33

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 34

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

Question 35

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

Question 36

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