Deck 17: E-R Diagrams and the IDEF1X Standard

Question 1

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

Answer 1

A

Question 2

IDEF1X entities are the same as the entities in the extended E-R model.

Answer 2

True

Question 3

The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one,with a mandatory parent and an optional child.

Answer 3

False

Question 4

Extended E-R model weak,but non-ID-dependent relationships are called nonidentifying connection relationships in IDEF1X.

Question 5

IDEF1X category clusters may be either complete or incomplete.

Question 6

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.

Question 7

IDEF1X category entities are mutually exclusive within a cluster.

Question 8

IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R model.

Question 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

Question 10

IDEF1X categories are put into a cluster.

Question 11

The IDEF1X equivalent of the extended E-R model subtype is the category entity,and category entities are placed in categorization clusters.

Question 12

IDEF1X identifying connection relationships correspond to ID-dependent relationships in the extended E-R model.

Question 13

IDEFIX domains are numbered sets of values.

Question 14

Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.

Question 15

Extended E-R model 1:N relationships are called identifying connection relationships in IDEF1X.

Question 16

A categorization relationship is an IS-A relationship.

Question 17

The IDEF1X standard excludes the concept of domains found in the extended E-R model.

Question 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

Question 19

Extended E-R model N:M relationships are called nonidentifying connection relationships in IDEF1X.

Question 20

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

Question 21

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.

Question 22

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

Question 23

What are IDEF1X domains?

Question 24

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

Question 25

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

Question 26

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

Question 27

In IDEF1X,a type domain allows ________.

A)different data types
B)different values
C)greater specificity of values
D)default values

Question 28

What symbols are used in IDEF1X diagrams to represent cardinalities?

Question 29

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

Question 30

In IDEF1X,extended E-R model subtype entities are called ________.

A)generic entities
B)category entities
C)nonspecific entities
D)category clusters

Question 31

In IDEF1X,the two kinds of domains are ________.

A)base and column
B)base and type
C)type and column
D)entity and type

Question 32

What is IDEF1X?

Question 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

Question 34

What line symbols are used in IDEF1X diagrams to represent relationships?

Question 35

What are the IDEF1X equivalents of 1:1,1:N and N:M relationships?

Question 36

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.

Question 37

In IDEF1X,extended E-R model supertype entities are called ________.

A)generic entities
B)category entities
C)nonspecific entities
D)category clusters