Database Processing, 15e (Kroenke)
Appendix C: E-R Diagrams and the IDEF1X and UML Standard
1) IDEF1X entities are the same as the entities in the extended E-R model.
2) Extended E-R model 1:1 relationships are called nonidentifying connection relationships in
IDEF1X.
3) Extended E-R model 1:N relationships are called identifying connection relationships in
IDEF1X.
4) Extended E-R model N:M relationships are called nonidentifying connection relationships in
IDEF1X.
5) Extended E-R model weak, but non-ID-dependent relationships are called nonidentifying
connection relationships in IDEF1X.
6) IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R
model.
7) IDEF1X identifying connection relationships correspond to ID-dependent relationships in the
extended E-R model.
8) The IDEF1X default cardinality of a nonidentifying connection relationship is one–to-one,
with a mandatory parent and an optional child.
9) The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a
dashed line with a filled-in circle by the child and no other notation.
10) The IDEF1X equivalent of the extended E-R model subtype is the category entity, and
category entities are placed in categorization clusters.
11) The IDEF1X standard excludes the concept of domains found in the extended E-R model.
12) A categorization relationship is an IS-A relationship.
13) IDEF1X categories are put into a cluster.
14) IDEF1X category entities are mutually exclusive within a cluster.
15) IDEF1X category clusters may be either complete or incomplete.
16) IDEFIX domains are numbered sets of values.
17) When the classes of all entities stored in a database are labeled with the keyword
<<Persistent>> it means that that data should continue to exist unless the object that processes it
is destroyed.
18) In a UML representation of HAS-A relationship, a N:M relationship is expressed as
_________.
A) _0..* 0..*_
B) 0..1 0..1_
C) 0..1 1..1_
D) 0..1 1..0_
19) In IDEF1X, extended E-R model 1:1 relationships are called ________.
A) nonidentifying connection relationships
B) identifying connection relationships
C) nonspecific relationships
D) category clusters
20) In IDEF1X, extended E-R model 1:N relationships are called ________.
A) nonidentifying connection relationships
B) identifying connection relationships
C) nonspecific relationships
D) category clusters
21) In IDEF1X, extended E-R model N:M relationships are called ________.
A) nonidentifying connection relationships
B) identifying connection relationships
C) nonspecific relationships
D) category clusters
22) In IDEF1X, extended E-R model ID-dependent relationships are called ________.
A) nonidentifying connection relationships
B) identifying connection relationships
C) nonspecific relationships
D) category clusters
23) In IDEF1X, extended E-R model weak, but non-ID-dependent relationships are called
________.
A) identifying connection relationships
B) nonspecific relationships
C) category clusters
D) There is no equivalent IDEF1X term.
24) In IDEF1X, extended E-R model supertype entities are called ________.
A) generic entities
B) category entities
C) nonspecific entities
D) category clusters
25) In IDEF1X, extended E-R model subtype entities are called ________.
A) generic entities
B) category entities
C) nonspecific entities
D) category clusters
26) In IDEF1X, extended E-R model subtype entities are grouped into ________.
A) generic entities
B) category entities
C) nonspecific entities
D) category clusters
E) There is no equivalent IDEF1X term.
27) In IDEF1X, the named set of values that an attribute can have is called a ________.
A) domain
B) base domain
C) type domain
D) domain cluster
28) In IDEF1X, the two kinds of domains are ________.
A) base and column
B) base and type
C) type and column
D) entity and type
29) In IDEF1X, a category cluster includes BLACK and WHITE, which are the only possible
categories. This is an IDEF1X ________.
A) complete category cluster
B) incomplete category cluster
C) inherited category cluster
D) inconclusive category cluster
30) In IDEF1X, a category cluster includes BLACK and WHITE, but does not show GREY,
which is also a possible category. This is an IDEF1X ________.
A) complete category cluster
B) incomplete category cluster
C) inherited category cluster
D) inconclusive category cluster
31) In IDEF1X, a base domain can have any of the following except a ________.
A) data type
B) value list
C) range definition
D) default value
32) In IDEF1X, a type domain allows ________.
A) different data types
B) different values
C) greater specificity of values
D) default values
33) In IDEF1X, a non-specific relationship is indicated by ________.
A) a hollow circle on each end of the solid relationship line
B) no circles on either end of the dotted relationship line
C) a solid circle on each end of the solid relationship line
D) a solid circle on each end of the dotted relationship line
34) In an IDEF1X identifying connection relationship, ________.
A) the identifier of the child is always part of the identifier of the parent
B) the identifier of the parent is always part of the identifier of the child
C) the identifier of the parent is always the same as the identifier of the child
D) the identifier of the parent is optional
35) What is IDEF1X?
36) What are the IDEF1X equivalents of 1:1, 1:N and N:M relationships?
37) What line symbols are used in IDEF1X diagrams to represent relationships?
38) What symbols are used in IDEF1X diagrams to represent cardinalities?
39) What are IDEF1X domains?