Info 364 Pop Quiz 7
2) The process of defining one or more subtypes of a supertype and forming relationships is called: A) specialization. B) generalization. C) creating discord. D) selecting classes.
A) specialization.
1) Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Megatype B) Supertype C) Subgroup D) Class
B) Supertype
4) The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. A) semi-specialization B) total specialization C) partial specialization D) disjointedness
C) partial specialization
9) An attribute of the supertype that determines the target subtype(s) is called the: A) determinant. B) subtype decision. C) disjoint indicator. D) subtype discriminator.
D) subtype discriminator
16) The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype. T or F
False
18) The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype. T or F
False
True or False 14) A subtype is a generic entity that has a relationship with one or more entities at a lower level. T or F
False
15) Specialization is the reverse of generalization. T or F
True
17) A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship. T or F
True
19) The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes. T or F
True
20) An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity. T or F
True
6) Which of the following is a completeness constraint? A) Total specialization B) Partial generalization C) Total recall D) Partial hybridization
A) Total specialization
3) The process of defining a more general entity type from a set of more specialized entity types is called: A) generalization. B) specialization. C) normalization. D) extrapulation.
A) generalization
11) The subtype discriminator is a composite attribute when there is a(n): A) overlap rule. B) disjoint rule. C) partial specialization. D) full specialization.`
A) overlap rule
12) An entity cluster is: A) a formal method for specifying attributes of related entities. B) a set of one or more entity types and associated relationships grouped into a single abstract entity type. C) a useful way to present data for a small and fairly simple organization. D) a way of developing more granular views of the data model.
B) a set of one or more entity types and associated relationships grouped into a single abstract entity type.
8) The ________ rule specifies that an entity can be a member of only one subtype at a time. A) exclusion B) disjoint C) removal D) inclusion
B) disjoint
10) The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes. A) disjoint B) overlap C) partial specialization D) total specialization
B) overlap
5) The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship. A) semi-specialization B) total specialization C) partial specialization D) total convergence
B) total specialization
13) A generic or template data model that can be reused as a starting point for a data modeling project is called a(n): A) packaged data model. B) universal data model. C) enterprise data model. D) collection data model.
B) universal data model.
7) A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. A) disjoint B) overlap C) completeness D) weak
C) completeness