Quiz 7 Flashcards
An identifier may be ________.
a. minimal
b. composite
c. optional
d. a relationship
b. Composite
Which of the following is not a common variant of the E-R model?
a. IE Crow’s Foot
b. Object-oriented
c. IDEF1X
d. UML
b. Object-oriented
(view question 3 in quiz 7 for image)
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above. What does the symbol next to the ORDER entity indicate?
a. A maximum cardinality of “zero”
b. A minimum cardinality of “required”
c. A minimum cardinality of “optional”
d. A maximum cardinality of “one”
c. A minimum cardinality of “optional”
(view question 4 in quiz 7 for image)
You are given an E-R diagram with two entities, ORDER and CUSTOMER, as shown above, and are asked to draw the relationship between them. If a given customer can place only one order and a given order can be placed by at most one customer, which of the following should be indicated in the relationship symbol between the two entities?
a. 1:N
b. N:M
c. N:1
d. 1:1
d. 1:1
An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n) ________.
a. strong entity
b. weak entity
c. subtype entity
d. ID-dependent entity
b. weak entity
