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 the same as the other subtypes. No attributes apply to any of the instances of an entity type. An instance of a subtype participates in a relationship that is unique to that subtype. Attributes apply to all of the instances of an entity type. An instance of a subtype participates in a relationship that is the same as the other subtypes. No attributes apply to any of the instances of an entity type. An instance of a subtype participates in a relationship that is unique to that subtype. 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 total specialization Disjoint with partial specialization Overlap with total specialization Overlap with partial specialization Disjoint with total specialization Disjoint with partial specialization Overlap with total specialization Overlap with partial specialization ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules An oval represents which of the following in an EER? Relationship Entity Attribute Optional One Relationship Entity Attribute Optional One ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules A subtype discriminator is which of the following? An attribute of the supertype whose values determine the supertype An attribute of the subtype whose values determine the subtype An attribute of the subtype whose values determine the supertype An attribute of the supertype whose values determine the subtype An attribute of the supertype whose values determine the supertype An attribute of the subtype whose values determine the subtype An attribute of the subtype whose values determine the supertype An attribute of the supertype whose values determine the subtype ANSWER DOWNLOAD EXAMIANS APP
ER Model and Business Rules Inheritance is which of the following? When a supertype entity inherits values of the subtype attribute When a supertype entity inherits values of another supertype attribute When a subtype entity inherits values of another subtype attribute When a subtype entity inherits values of the supertype attribute When a supertype entity inherits values of the subtype attribute When a supertype entity inherits values of another supertype attribute When a subtype entity inherits values of another subtype attribute When a subtype entity inherits values of the supertype attribute 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). True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS