ER Model and Business Rules Use of a supertype/subtype relationship is necessary when which of the following exists? Attributes apply to all of the instances of an entity type. An instance of a subtype participates in a relationship that is unique to that subtype. No attributes apply to any of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. Attributes apply to all of the instances of an entity type. An instance of a subtype participates in a relationship that is unique to that subtype. No attributes apply to any of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A supertype/subtype hierarchy is which of the following? Each subtype has only one supertype. Each subtype has only one attribute. Each supertype has only one subtype. Each supertype has only one attribute. Each subtype has only one supertype. Each subtype has only one attribute. Each supertype has only one subtype. Each supertype has only one attribute. ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following? Disjoint with partial specialization Overlap with partial specialization Overlap with total specialization Disjoint with total specialization Disjoint with partial specialization Overlap with partial specialization Overlap with total specialization Disjoint with total specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules An oval represents which of the following in an EER? Attribute Relationship Entity Optional One Attribute Relationship Entity Optional One ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A subtype discriminator is which of the following? An attribute of the subtype whose values determine the subtype An attribute of the supertype whose values determine the supertype An attribute of the supertype whose values determine the subtype An attribute of the subtype whose values determine the supertype An attribute of the subtype whose values determine the subtype An attribute of the supertype whose values determine the supertype An attribute of the supertype whose values determine the subtype An attribute of the subtype whose values determine the supertype ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s). False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS