IS 441 Chapter 3

B. disjointedness constraint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. A. partial specialization B. disjointedness constraint C. total specialization D. disjoint rule

D. completeness

A ________ 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. overlap B. disjoint C. weak D. completeness

False

A member of a subtype does NOT necessarily have to be a member of the supertype. True False

True

A subtype can become a supertype if the subtype has other subtypes beneath it. True False

False

Based on the following diagram, a room cannot be a classroom and a laboratory at the same time. True False

C. Student_Type

For the following diagram, which one of the following is a proper discriminator attribute? A. Student_Type ( G , U , S ) B. { Student_Type } C. Student_Type D. Student_Type ( x , y )

A. only one supertype.

In a supertype/subtype hierarchy, each subtype has: A. only one supertype. B. many supertypes. C. at most two supertypes. D. at least one subtype.

B. supertypes

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy. A. subtypes B. supertypes C. dimensions D. constraints

B. must be a graduate student, an undergraduate, a special student or some other type of student.

In the figure below, a student: A. must be a graduate student or an undergraduate student. B. must be a graduate student, an undergraduate, a special student or some other type of student. C. None of these. D. must be at least a special student, a graduate student or an undergraduate student.

C. Outpatient

In the figure below, which of the following are subtypes of patient? A. Physician B. All of these C. Outpatient D. Bed

D. Outpatient

In the figure below, which of the following is not in relationship with "BED" entity? A. Resident Patient B. Responsible Physician C. Patient D. Outpatient

B. Composite

In the following diagram, the discriminator attribute is a _____________ attribute. A. Single B. Composite C. Multivalued D. Derived

False

Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. True False

D. there are attributes that apply to some but not all instances of an entity type.

Subtypes should be used when: A. None of these. B. the instances of a subtype do not participate in a relationship that is unique to that subtype. C. supertypes relate to objects outside the business. D. there are attributes that apply to some but not all instances of an entity type.

B. disjoint

The ________ rule specifies that an entity can be a member of only one subtype at a time. A. removal B. disjoint C. inclusion D. exclusion

False

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. True False

C. total specialization.

The following figure is an example of: A. completeness. B. disjointness. C. total specialization. D. partial specialization.

A. partial specialization.

The following figure is an example of: A. partial specialization. B. transunion constraint. C. disjoint completeness. D. total specialization.

True

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. True False

D. specialization.

The process of defining one or more subtypes of a supertype and forming relationships is called: A. selecting classes. B. disjointness C. generalization. D. specialization.

A. attribute inheritance.

The property by which subtype entities possess the values of all attributes of a supertype is called: A. attribute inheritance. B. generalization. C. hierarchy reception. D. class management.

B. Part_Type.

The subtype discriminator in the figure below is: A. Part_No. B. Part_Type. C. Supplier D. Manufactured Part.

A. A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.

Which of the following statements is true about the figure shown below? A. A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. B. A rental unit must be either an apartment or a house, and cannot be both at the same time. C. A rental unit must be either an apartment or a house, and could be both. D. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time.

D. A rental unit must be either an apartment or a house, and cannot be both at the same time.

Which of the following statements is true about the figure shown below? A. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. B. A rental unit must be either an apartment or a house, and could be both. C. A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. D. A rental unit must be either an apartment or a house, and cannot be both at the same time.

C. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time.

Which of the following statements is true about the figure shown below? A. A rental unit must be either an apartment or a house, and could be both. B. A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. C. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. D. A rental unit must be either an apartment or a house, and cannot be both at the same time.

A. A rental unit must be either an apartment or a house, and could be both.

Which of the following statements is true about the figure shown below? A. A rental unit must be either an apartment or a house, and could be both. B. A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time. C. A rental unit must be either an apartment or a house, and cannot be both at the same time. D. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time.

D. All attributes of person and student are inherited by undergraduate.

Which statement is true about the following diagram? A. All attributes of graduate are inherited by person. B. A student can be both an undergraduate and a graduate student at the same time. C. A person can only be a faculty, student or staff. D. All attributes of person and student are inherited by undergraduate.