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