MGS Final

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the _____ rule A. Disjoint B. Specialization C. Generalization D. Overlap

A. Disjoint

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

In the figure below, which of the following is a subtype of a patient? A. Outpatient B. Physician C. Bed D. Date_Hired

A. Outpatient

A ______ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes A. Overlapping Rule B. Disjoint Rule C. Partial Specialization D. Total Specialization

A. Overlapping Rule

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

A. Part_Type

The process of defining one or more subtypes from one supertype and forming relationships is called: A. Specialization B. Generalization C. Creating Discord D. Selecting Classes

A. Specialization

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

A. There are attributes that apply to some but not all instances of an entity type

Which of the following is a completeness constraint? A. Total Specialization B. Partial Generalization C. Total Recall D. Partial Hybridization

A. Total Specialization

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 cannot be both at the same time. B) A rental unit can be an apartment, house or just a rental unit; it may not be more than one 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, a house or just a rental unit. It could be both an apartment and a house at the same time.

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

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

The subtype discriminator is a simple attribute when there is a(n) A. Overlap Rule B. Disjoint Rule C. Partial Specialization D. Full Specialization

B. Disjoint Rule

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ______ dependency A. Partial key-based B. Partial Functional C. Cross Key D. Merged Relation

B. Partial Functional

A relation that contains no multi-valued attributes and has nonket attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? A. First B. Second C. Third D. Fourth

B. Second

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

In a supertpe/subtype hierarchy, subtypes that are lower in the hierarchy inherit attribtes from not only their immediate supertypee but from all ____ in the hierarchy A. Relationships B. Supertypes C. Constraints D. Dimensions

B. Supertypes

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized? A. Make B. Vehicle C. Model D. Price

B. Vehicle

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

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

An attribute of the supertype that indicates which subtype(s) the instance belongs to is called the: A. Determinant B. Subtype Decision C. Disjoint Indicator D. Subtype Discriminator

D. Subtype Discriminator

In this figure below, what type of relationship is depicted? A. Binary B. Associative C. Transitive D. Unary

D. Unary

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

FALSE

An entity instance of a subtype represents the same entity instance of a supertype True or False?

TRUE

Supertype/Subtype relationships should be used when the instances of a subtype participate in relationships which are unique to that subtype True or False?

TRUE

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

C) All attributes of person and student are inherited by undergraduate.