Deck 15: E-R Diagrams and the Idef1x Standard
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/35
Play
Full screen (f)
Deck 15: E-R Diagrams and the Idef1x Standard
1
A categorization relationship is an IS-A relationship.
True
2
Extended E-R model 1:N relationships are called identifying connection relationships in IDEF1X.
False
3
IDEF1X identifying connection relationships correspond to ID-dependent relationships in the extended E-R model.
True
4
IDEF1X categories are put into a cluster.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
5
IDEFIX domains are numbered sets of values.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
6
IDEF1X category clusters may be either complete or incomplete.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
7
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.
E)There is no equivalent IDEF1X term.
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
8
The IDEF1X equivalence of the extended E-R model subtype is the category entity,and category entities are placed in categorization clusters.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
9
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.
E)There is no equivalent IDEF1X term.
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
10
Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
11
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.
E)There is no equivalent IDEF1X term.
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
12
IDEF1X category clusters are mutually exclusive.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
13
Extended E-R model N:M relationships are called nonidentifying connection relationships in IDEF1X.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
14
The IDEF1X excludes the concept of domains found in the extended E-R model.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
15
IDEF1X entities are the same as the entities in the extended E-R model.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
16
Extended E-R model weak,but non-ID-dependent relationships are called nonidentifying connection relationships in IDEF1X.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
17
The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one,with a mandatory parent and an optional child.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
18
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.
E)There is no equivalent IDEF1X term.
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
19
IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R model.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
20
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.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
21
In IDEF1X,a type domain allows:
A)different data types.
B)different values.
C)greater specificity of values.
D)B or C
E)A,B,or C
A)different data types.
B)different values.
C)greater specificity of values.
D)B or C
E)A,B,or C
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
22
What symbols are used in IDEF1X diagrams to represent cardinalities?
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
23
What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
24
In IDEF1X,extended E-R model weak,but non-ID-dependent relationships are called:
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
A)nonidentifying connection relationships.
B)identifying connection relationships.
C)nonspecific relationships.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
25
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.
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
26
In IDEF1X,a base domain can have a:
A)data type.
B)value.
C)range definition.
D)B or C
E)A,B,or C
A)data type.
B)value.
C)range definition.
D)B or C
E)A,B,or C
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
27
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.
E)None of the above.
A)complete category cluster.
B)incomplete category cluster.
C)inherited category cluster.
D)inconclusive category cluster.
E)None of the above.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
28
What line symbols are used in IDEF1X diagrams to represent relationships?
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
29
In IDEF1X,extended E-R model subtype entities are called:
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
30
In IDEF1X,extended E-R model supertype entities are called:
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
A)generic entities.
B)category entities.
C)nonspecific entities.
D)category clusters.
E)There is no equivalent IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
31
In IDEF1X,a domain is a:
A)domain.
B)base domain.
C)type domain.
D)B or C
E)A,B,or C
A)domain.
B)base domain.
C)type domain.
D)B or C
E)A,B,or C
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
32
What is IDEF1X?
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
33
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.
E)There is no such IDEF1X term.
A)domain.
B)base domain.
C)type domain.
D)domain cluster.
E)There is no such IDEF1X term.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
34
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.
E)None of the above.
A)complete category cluster.
B)incomplete category cluster.
C)inherited category cluster.
D)inconclusive category cluster.
E)None of the above.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
35
What are IDEF1X domains?
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck