MIS 310 Quiz 3

9) In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates: A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C

Answer: D

5) Given only the following excerpt of an E-R model: Which of the following is known to be true?

A) A single instance of ENTITY A must be related to one instance of ENTITY B. B) Many instances of ENTITY A may be related to one instance of ENTITY B. C) ENTITY B has a degree of many. D) ENTITY B is a weak entity. E) Both A and C are true. Answer: B

1) Which of the following is not a basic element of the E-R Model?

A) Identifiers B) Entities C) Cardinalities D) Use cases E) Relationships Answer: D

4) Given only the following excerpt of an E-R model: Which of the following is known to be true?

A) There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment. B) A single instance of ENTITY B may be related to many instances of ENTITY A. C) A single instance of ENTITY A must be related to many instances of ENTITY B. D) ENTITY A has a minimum cardinality of one. E) The degree of the relationship is "many." Answer: B

8) In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates:

A) a minimum cardinality of zero. B) a minimum cardinality of one. C) a maximum cardinality of one. D) a maximum cardinality of many. E) Both B and C Answer: A

7) An ID-dependent entity is:

A) a special type of weak entity. B) an entity in which the identifier of the entity includes the identifier of another entity. C) a strong entity. D) an entity with a maximum cardinality of one. E) Both A and B Answer: E

10) In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent:

A) a strong entity relationship. B) an ID-dependent weak entity relationship. C) a non-ID-dependent weak entity relationship. D) a supertype / subtype relationship. E) a recursive entity relationship. Answer: D

6) Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the

A) degree. B) recursive cardinality. C) minimum cardinality. D) maximum cardinality. E) ordinality. Answer: C

2) In the Entity-Relationship data model, all instances of an entity of a given type are grouped into:

A) entity objects. B) class objects. C) entity classes. D) identifiers. E) entity attributes. Answer: C

3) The number of entity classes involved in a relationship is known as the relationship's:

A) maximum cardinality. B) minimum cardinality. C) ordinality. D) degree. E) class. Answer: D